using OASystem.Domain; using OASystem.Domain.Entities.Groups; using OASystem.Domain.Entities.Resource; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace OASystem.Infrastructure.Repositories.Groups { public class GroupCostRepository:BaseRepository { public GroupCostRepository(SqlSugarClient sqlSugar) : base(sqlSugar) {} public List GetAllByDiid(int diid) { return Query(x => x.Diid == diid).ToList(); } public List GetAll() { return Query(x=> x.IsDel < 1).ToList(); } public async Task SaveGroupCostList(List costList,int diid, int userid) { BeginTran(); //注释删除 //bool isTrue = await DeleteGroupCostList(diid); bool isTrue = await UpdateAsync(x => x.Diid == diid && x.IsDel == 0, x => new Grp_GroupCost { IsDel = 1, DeleteUserId = userid, DeleteTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }) ; if (costList.Count > 0) { isTrue = Adds(costList) > 0; } if (isTrue) { CommitTran(); } else { RollbackTran(); } return isTrue; } public Task DeleteGroupCostList(int diid) { return DeleteAsync(x => x.Diid == diid); } public Result CreateGroupCostByBlackCode(int diid) { Result rt = new Result(); List returnArr = new List(); DataTable resultTable = null; try { resultTable = GetTableByBlackCode(diid); if (resultTable.Rows.Count == 0 || string.IsNullOrWhiteSpace(resultTable.Rows[0][1].ToString())) { string msg = string.Empty; if (resultTable.Rows.Count > 0) { msg = resultTable.Rows[0]["Error"].ToString(); } rt.Msg = "黑屏代码有误! " + msg; rt.Data = returnArr; rt.Code = -1; } else { var timeArr = GetTimeListByDataTable(resultTable); var dayIndex = 1; var stopCity = string.Empty; foreach (var item in timeArr) { var tabSelect = resultTable.Select(string.Format("Day = '{0}'", item)); var itin = string.Empty; if (tabSelect.Length > 0) { var threeCodeValue = new List(4); foreach (var tabRow in tabSelect) { var threeCode = tabRow["Three"].ToString(); var start = threeCode.Substring(0, 3); var end = threeCode.Substring(3, 3); stopCity = end; if (start == stopCity) { threeCodeValue.Add(end); } else { threeCodeValue.Add(start); threeCodeValue.Add(end); } itin = $@"{threeCodeValue[0]}/{threeCodeValue[threeCodeValue.Count - 1]} {tabRow["Fliagtcode"].ToString()} {tabRow["StartTime"].ToString()}/{tabRow["EndTime"].ToString()}"; } } else { itin = stopCity; } Grp_GroupCost ggc = new Grp_GroupCost(); ggc.DAY = dayIndex.ToString(); ggc.Date = item; ggc.ITIN = itin; ggc.Diid = diid; returnArr.Add(ggc); dayIndex++; } rt.Data = returnArr; if (returnArr.Count > 0) { rt.Code = 0; rt.Msg = "生成成功！"; } else { rt.Code = -1; rt.Msg = "生成失败！" + "请检查机票黑屏代码！"; } } } catch (Exception ex) { rt.Code = -1; rt.Msg = ex.Message; rt.Data = ex.StackTrace; } return rt; } /// ///根据机票黑屏代码整理DataTable /// /// /// public DataTable GetTableByBlackCode(int diid) { string[] excludeArr = new string[] { "[中转]", "[转机]" }; //黑屏代码信息 List listcode = _sqlSugar.Queryable().Where(x => x.DiId == diid && x.IsDel == 0).ToList(); //测试数据为序号,航班号,起飞日期,三字码,起飞时刻,到达时刻,出发航站楼,到达航站楼,机型,飞行时间 //1.3U8391 TU17NOV CTUCAI 0220 0715 T1 T2 330 10H55M DataTable dt = new DataTable(); dt.Columns.Add("Fliagtcode", typeof(string)); //航班号 dt.Columns.Add("Date", typeof(string));//起飞日期 dt.Columns.Add("Three", typeof(string));//三字码 dt.Columns.Add("StartTime", typeof(string));//起飞时刻 dt.Columns.Add("EndTime", typeof(string));//到达时刻 dt.Columns.Add("StartBuilding", typeof(string));//出发航站楼 dt.Columns.Add("EndBuilding", typeof(string));//到达航站楼 dt.Columns.Add("AirModel", typeof(string)); //机型 dt.Columns.Add("FlightTime", typeof(string));//飞行时间 dt.Columns.Add("Day", typeof(string));//整理的起飞日期;作为排序依据 dt.Columns.Add("ArrivedDate", typeof(string));//整理的到达日期 dt.Columns.Add("Error", typeof(string));//整理的到达日期 dt.Columns.Add("Sign", typeof(string));//标识：0表示为原生黑屏代码、1表示“+1”新增的黑屏代码 //添加转机标识 dt.Columns.Add("isTransitShipment", typeof(bool)); //判断是否录入黑屏代码 if (listcode.Count() == 0 || listcode == null) { dt.Rows.Add(null, null, null, null, null, null, null, null, null, null, null, "黑屏代码未录入!", null, false); } else { //读取单段黑屏代码 for (int i = 0; i < listcode.Count; i++) { //去除序号 string[] CodeList = Regex.Split(listcode[i].BlackCode, "\\d+\\.", RegexOptions.IgnoreCase); //去除多余空格，方法一Linq扩展方法 CodeList = CodeList.Where(str => !string.IsNullOrWhiteSpace(str)).ToArray(); //读取单条黑屏代码 for (int j = 0; j < CodeList.Count(); j++) { //去除多余空格，方法二使用Split()方法进行分割,分割有一个选项是RemoveEmptyEntries CodeList[j] = CodeList[j].Replace("\r\n", string.Empty).Replace("\\r\\n", string.Empty).TrimStart().TrimEnd(); string[] Info = CodeList[j].Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); //去除多余空格 Info = Info.Where(str => !string.IsNullOrWhiteSpace(str)).ToArray(); //判断黑屏代码是否正确拆分; 理应拆成9段 if (Info.TakeWhile((x) => { return !excludeArr.Contains(x); }).Count() != 9) { dt.Rows.Add(null, null, null, null, null, null, null, null, null, null, null, "本团组第" + (i + 1) + "段黑屏代码中第" + (j + 1) + " 条有误,请联系机票同事核对", null, false); //MessageBoxEx.Show("第" + (i + 1) + "段黑屏代码中第" + (j + 1) + " 条有误, 请联系机票同事核对"); return dt; } else { try { var monthEn = Info[1].Substring(4, 3); //月 int month = Convert.ToInt32(GetLonger(monthEn)); //日 int day = Convert.ToInt32(Info[1].Substring(2, 2)); var time = new DateTime(DateTime.Now.Year, month, day); // var isExist = Info.Contains("[中转]"); if (!isExist) { isExist = Info.Contains("[转机]"); } //dt.Columns.Add("Fliagtcode", typeof(string)); //航班号 //dt.Columns.Add("Date", typeof(string));//起飞日期 //dt.Columns.Add("Three", typeof(string));//三字码 //dt.Columns.Add("StartTime", typeof(string));//起飞时刻 //dt.Columns.Add("EndTime", typeof(string));//到达时刻 //dt.Columns.Add("StartBuilding", typeof(string));//出发航站楼 //dt.Columns.Add("EndBuilding", typeof(string));//到达航站楼 //dt.Columns.Add("AirModel", typeof(string)); //机型 //dt.Columns.Add("FlightTime", typeof(string));//飞行时间 //dt.Columns.Add("Day", typeof(string));//整理的起飞日期;作为排序依据 //dt.Columns.Add("ArrivedDate", typeof(string));//整理的到达日期 //dt.Columns.Add("Error", typeof(string));//整理的到达日期 //dt.Columns.Add("Sign", typeof(string));//标识：0表示为原生黑屏代码、1表示“+1”新增的黑屏代码 dt.Rows.Add(Info[0], Info[1], Info[2], Info[3], Info[4], Info[5], Info[6], Info[7], Info[8], time.ToString("yyyy-MM-dd"), time.ToString("yyyy-MM-dd"), "", "0", isExist ); } catch (Exception ex) { string exstr = ex.Message.ToString(); } } } //排序 dt.DefaultView.Sort = "Day asc"; dt = dt.DefaultView.ToTable(); } } return dt; } public string GetLonger(string temp) { string str = ""; switch (temp.ToUpper()) { case "美元": str = "USD"; break; case "日元": str = "JPY"; break; case "英镑": str = "GBP"; break; case "欧元": str = "EUR"; break; case "港币": str = "HKD"; break; case "MO": str = "星期一"; break; case "TU": str = "星期二"; break; case "WE": str = "星期三"; break; case "TH": str = "星期四"; break; case "FR": str = "星期五"; break; case "SA": str = "星期六"; break; case "SU": str = "星期天"; break; case "JAN": str = "01"; break; case "FEB": str = "02"; break; case "MAR": str = "03"; break; case "APR": str = "04"; break; case "MAY": str = "05"; break; case "JUN": str = "06"; break; case "JUL": str = "07"; break; case "AUG": str = "08"; break; case "SEP": str = "09"; break; case "OCT": str = "10"; break; case "NOV": str = "11"; break; case "DEC": str = "12"; break; case "MONDAY": str = "星期一"; break; case "TUESDAY": str = "星期二"; break; case "WEDNESDAY": str = "星期三"; break; case "THURSDAY": str = "星期四"; break; case "FRIDAY": str = "星期五"; break; case "SATURDAY": str = "星期六"; break; case "SUNDAY": str = "星期日"; break; case "01": str = "JAN"; break; case "02": str = "FEB"; break; case "03": str = "MAR"; break; case "04": str = "APR"; break; case "05": str = "MAY"; break; case "06": str = "JUN"; break; case "07": str = "JUL"; break; case "08": str = "AUG"; break; case "09": str = "SEP"; break; case "10": str = "OCT"; break; case "11": str = "NOV"; break; case "12": str = "DEC"; break; case "2": str = "空客A"; break; case "3": str = "空客A"; break; case "7": str = "波音"; break; } return str; } public List GetTimeListByDataTable(DataTable dt) { DateTime datestart = Convert.ToDateTime(dt.Rows[0]["Day"].ToString()); DateTime dateend = Convert.ToDateTime(dt.Rows[dt.Rows.Count - 1]["ArrivedDate"].ToString()); List timeList = new List(); while (datestart <= dateend) { timeList.Add(datestart.ToString("yyyy-MM-dd")); datestart = datestart.AddDays(1); } return timeList; } } }