private void InitData() { try { using (var db = SugarDao.GetInstance()) { string sqlWhere = "1=1"; if (!string.IsNullOrWhiteSpace(date_begin.Text.Trim())) { sqlWhere += $" and datetime(Date) >= datetime('{DateTime.Parse(date_begin.Text.Trim()):yyyy-MM-dd}')"; } if (!string.IsNullOrWhiteSpace(date_end.Text.Trim())) { sqlWhere += $" and datetime(Date) < datetime('{DateTime.Parse(date_end.Text.Trim()).AddDays(1):yyyy-MM-dd}')"; } if (!string.IsNullOrWhiteSpace(lue_LogType.EditValue?.ToString())) { sqlWhere += $" and LogType='{lue_LogType.Text}'"; } int count = 0; var dataList = db.Queryable <Log>().Where(sqlWhere).OrderBy(t => t.LogId, OrderByType.Desc).ToPageList(pageIndex, pageSize, ref count); if (dataList == null || !dataList.Any()) { gd_list.DataSource = null; gd_list.Refresh(); gd_list.RefreshDataSource(); return; } gd_list.DataSource = dataList; gd_list.Refresh(); gd_list.RefreshDataSource(); this.gridView1.BestFitColumns(); //自动调整所有字段宽度 gridView1.IndicatorWidth = 30; //设置显示行号的列宽 //设置奇、偶行交替颜色 gridView1.OptionsView.EnableAppearanceEvenRow = true; gridView1.OptionsView.EnableAppearanceOddRow = true; gridView1.Appearance.EvenRow.BackColor = Color.GhostWhite; gridView1.Appearance.OddRow.BackColor = Color.White; //view行中值居左 this.gridView1.Appearance.Row.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near; //view列标题居左 this.gridView1.Appearance.HeaderPanel.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near; if (pageIndex == 1) { InitPageCount(count); lbl_Sum.Text = $"总数:{count}"; } } } catch (Exception ex) { XtraMessageBox.Show("业务日志加载失败!" + ex.Message); } }
/// <summary> /// 加载下拉列表 /// </summary> <param name="lue">下拉控件</param> private void InitLookUpEdit(LookUpEdit lue) { try { using (var db = SugarDao.GetInstance()) { int i = 0; var list = new List <SelectItem>() { new SelectItem() { Key = i++.ToString(), Value = LogType.采购入库.ToString() }, new SelectItem() { Key = i++.ToString(), Value = LogType.入库明细.ToString() }, new SelectItem() { Key = i++.ToString(), Value = LogType.销售出库.ToString() }, new SelectItem() { Key = i++.ToString(), Value = LogType.出库明细.ToString() }, new SelectItem() { Key = i++.ToString(), Value = LogType.库存修改.ToString() }, new SelectItem() { Key = i++.ToString(), Value = LogType.药品信息.ToString() }, new SelectItem() { Key = i++.ToString(), Value = LogType.基础信息.ToString() }, new SelectItem() { Key = i++.ToString(), Value = LogType.其他.ToString() }, }; if (list.Count > 0) { var l = list.Select(t => new { t.Key, t.Value }).ToList(); lue.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Value", "类型")); lue.Properties.NullText = ""; lue.Properties.ImmediatePopup = true; //当用户在输入框按任一可见字符键时立即弹出下拉窗体 lue.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; //要使用户可以输入,这里须设为Standard lue.Properties.SearchMode = SearchMode.OnlyInPopup; //自动过滤掉不需要显示的数据,可以根据需要变化 lue.Properties.AutoSearchColumnIndex = 1; //lue.Properties.NullText = "请选择"; //lue.EditValue = "Id"; lue.Properties.DisplayMember = "Value"; lue.Properties.ShowHeader = true; //lue.ItemIndex = 0; //选择第一项 lue.Properties.DataSource = list; //自适应宽度 lue.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; //填充列 //lue.Properties.PopulateColumns(); //lue.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Character")); //lue.Properties.Columns[0].Visible = false; } else { lue.Properties.NullText = ""; } } } catch (Exception ex) { XtraMessageBox.Show("加载数据出错!" + ex.Message); } }
//上传西服裤子尺码表 public static bool Import_Excel_trousrs(DataTable table, string Size_Code, out string errmsg) { using (var db = SugarDao.GetInstance()) try { List <TrousersSize> tszie_list = new List <TrousersSize>(); for (int i = 0; i < table.Rows.Count; i++) { #region 处理不符合要求得数据 DataRow row = table.Rows[i]; row.BeginEdit(); for (int a = 0; a < table.Columns.Count; a++) { if (row[a].ToString().IndexOf("....") > 0) { row[a] = row[a].ToString().Replace("....", "."); } if (row[a].ToString().IndexOf("...") > 0) { row[a] = row[a].ToString().Replace("...", "."); } if (row[a].ToString().IndexOf("..") > 0) { row[a] = row[a].ToString().Replace("..", "."); } if (row[a].ToString().IndexOf("null") > 0) { row[a] = row[a].ToString().Replace("null", "0"); } if (string.IsNullOrEmpty(row[a].ToString())) { row[a] = 0; } } row.EndEdit(); #endregion #region 保存尺码 TrousersSize tszie = new TrousersSize(); foreach (DataRow item in table.Rows) { tszie.Code = item["Code"].ToString(); decimal ty = 0; if (decimal.TryParse(item["DZ_HipLength_CP"].ToString(), out ty)) { tszie.DZ_HipLength_CP = ty; } else { tszie.DZ_HipLength_CP = 0; } if (decimal.TryParse(item["SZ_HipLength_CP"].ToString(), out ty)) { tszie.SZ_HipLength_CP = ty; } else { tszie.SZ_HipLength_CP = 0; } if (decimal.TryParse(item["Crosspiece"].ToString(), out ty)) { tszie.Crosspiece = ty; } else { tszie.Crosspiece = 0; } if (decimal.TryParse(item["LegWidth_UnderTheWaves"].ToString(), out ty)) { tszie.LegWidth_UnderTheWaves = ty; } else { tszie.LegWidth_UnderTheWaves = 0; } if (decimal.TryParse(item["FrontRise_EvenWaist"].ToString(), out ty)) { tszie.FrontRise_EvenWaist = ty; } else { tszie.FrontRise_EvenWaist = 0; } if (decimal.TryParse(item["AfterTheWaves_EvenWaist"].ToString(), out ty)) { tszie.AfterTheWaves_EvenWaist = ty; } else { tszie.AfterTheWaves_EvenWaist = 0; } tszie.NetHip = item["NetHip"].ToString(); tszie.CP_WaistWidth = item["CP_WaistWidth"].ToString(); tszie.Height = item["Height"].ToString(); tszie.LongPants = item["LongPants"].ToString(); tszie.NetWaist = item["NetWaist"].ToString(); tszie.Size_Code = Size_Code; } tszie_list.Add(tszie); #endregion } db.InsertRange(tszie_list); db.CommitTran(); errmsg = ""; return(true); } catch (Exception ex) { db.RollbackTran(); //回滚事务 errmsg = ex.Message; return(false); } }
/// <summary> /// 获取列表信息 /// </summary> /// <param name="pagenum"></param> /// <param name="onepagecount"></param> /// <param name="totil"></param> /// <param name="totilpage"></param> /// <param name="exmsg"></param> /// <param name="type"></param> /// <param name="purch_code"></param> /// <returns></returns> public List <ProcurementModel> GetProcurementList(int pagenum, int onepagecount, out int totil, out int totilpage, out string exmsg, int?type, string purch_code, string OrderCode, string express_code, string supp_name) { using (var db = SugarDao.GetInstance(LoginUser.GetConstr())) { try { var getwhere = db.Queryable <busi_purchase>() .JoinTable <base_users>((s1, s2) => s1.create_user_id == s2.user_id) .JoinTable <base_supplier>((s1, s3) => s1.supp_id == s3.supp_id) .Where("s1.del_flag=1 and s2.del_flag=1 and s3.del_flag=1").OrderBy("s1.purch_id DESC"); if (type.HasValue && type > 0) { getwhere = getwhere.Where("s1.purch_status=" + type + ""); } if (!string.IsNullOrWhiteSpace(purch_code)) { getwhere = getwhere.Where("s1.purch_code LIKE '%" + purch_code + "%'"); } if (!string.IsNullOrWhiteSpace(OrderCode)) { getwhere = getwhere.Where("s1.OrderCode LIKE '%" + OrderCode + "%'"); } if (!string.IsNullOrWhiteSpace(express_code)) { getwhere = getwhere.Where("s1.express_code LIKE '%" + express_code + "%'"); } if (!string.IsNullOrWhiteSpace(supp_name)) { getwhere = getwhere.Where("s3.supp_name LIKE '%" + supp_name + "%'"); } totil = getwhere.Count(); var list = getwhere.Skip(onepagecount * (pagenum - 1)).Take(onepagecount) .Select <base_users, base_supplier, ProcurementModel>((s1, s2, s3) => new ProcurementModel { express_code = s1.express_code, purch_id = s1.purch_id, purch_code = s1.purch_code, purchase_time = s1.create_time, purch_status = s1.purch_status, emp_name = s2.user_name, purch_type = s1.purch_type, supp_name = s3.supp_name, OrderCode = s1.OrderCode, isLocked = s1.isLocked, Locked_userid = s1.Locked_userid, }).ToList(); if (totil > 0) { foreach (var item in list) { if (item.purchase_time == null) { item.purchase_timeE = ""; } else { item.purchase_timeE = item.purchase_time.Value.ToString("yyyy-MM-dd"); } item.purch_statusE = item.purch_status == 1 ? "初始" : (item.purch_status == 2 ? "已采购" : (item.purch_status == 3 ? "待收货" : (item.purch_status == 4 ? "已全部到货" : ""))); item.purch_typeE = item.purch_type == 1 ? "订单采购" : (item.purch_type == 2 ? "库存采购" : ""); item.OrderCodeE = item.OrderCode == null ? "" : item.OrderCode; item.express_codeE = item.express_code == null ? "" : item.express_code; //if (item.isLocked) //{ // var info = db.Queryable<base_users>().InSingle(item.Locked_userid); // if (info != null) // { // item.isLockedE = "已锁定 (" + info.user_name + ")"; // } // else // { // item.isLockedE = "已锁定 " + "()"; // } //} //else //{ // item.isLockedE = "未锁定"; //} } } totilpage = totil / onepagecount; exmsg = ""; if (totil % onepagecount > 0) { totilpage++; } return(list.ToList()); } catch (Exception ex) { exmsg = ex.ToString(); totil = 0; totilpage = 0; return(null); } } }
//上传西服上衣尺码表 public static bool Import_Excel_jacket(DataTable table, string size_code, string gender, out string errmsg) { using (var db = SugarDao.GetInstance()) try { db.CommandTimeOut = 3000; //设置超时时间 List <CoatSize> list = new List <CoatSize>(); db.BeginTran(); for (int i = 0; i < table.Rows.Count; i++) { #region 处理不符合要求得数据 DataRow row = table.Rows[i]; row.BeginEdit(); for (int a = 0; a < table.Columns.Count; a++) { if (row[a].ToString().IndexOf("....") > 0) { row[a] = row[a].ToString().Replace("....", "."); } if (row[a].ToString().IndexOf("...") > 0) { row[a] = row[a].ToString().Replace("...", "."); } if (row[a].ToString().IndexOf("..") > 0) { row[a] = row[a].ToString().Replace("..", "."); } } row.EndEdit(); #endregion if (!string.IsNullOrEmpty(gender)) { object ruid; if (gender == "男") { XF_SY_NAN_CodeSize cs = new XF_SY_NAN_CodeSize(); cs.Height = Convert.ToDecimal(table.Rows[i]["Height"]); cs.FrontLength = table.Rows[i]["FrontLength"] + ""; cs.NetBust = table.Rows[i]["NetBust"] + ""; cs.FinishedBust = Convert.ToDecimal(table.Rows[i]["FinishedBust"]); cs.InWaist = Convert.ToDecimal(table.Rows[i]["InWaist"]); cs.FinishedHem_NoFork = Convert.ToDecimal(table.Rows[i]["FinishedHem_NoFork"]); cs.FinishedHem_SplitEnds = Convert.ToDecimal(table.Rows[i]["FinishedHem_SplitEnds"]); cs.ShoulderWidth = Convert.ToDecimal(table.Rows[i]["ShoulderWidth"]); cs.Size_Code = size_code; cs.Height = Convert.ToDecimal(table.Rows[i]["Height"]); cs.Sleecve_Show = table.Rows[i]["FK_Sleeve_ID"] + ""; cs.CreateDateTime = DateTime.Now; cs.IsDeleted = false; cs.Status = 1; ruid = db.Insert(cs, true); } else { XF_SY_NU_CodeSize cs = new XF_SY_NU_CodeSize(); cs.Height = Convert.ToDecimal(table.Rows[i]["Height"]); cs.FrontLength = table.Rows[i]["FrontLength"] + ""; cs.NetBust = table.Rows[i]["NetBust"] + ""; cs.FinishedBust = Convert.ToDecimal(table.Rows[i]["FinishedBust"]); cs.InWaist = Convert.ToDecimal(table.Rows[i]["InWaist"]); cs.FinishedHem_NoFork = Convert.ToDecimal(table.Rows[i]["FinishedHem_NoFork"]); cs.SleeveWidth = Convert.ToDecimal(table.Rows[i]["SleeveWidth"]); cs.ShoulderWidth = Convert.ToDecimal(table.Rows[i]["ShoulderWidth"]); cs.Size_Code = size_code; cs.Sleecve_Show = table.Rows[i]["FK_Sleeve_ID"] + ""; cs.CreateDateTime = DateTime.Now; cs.IsDeleted = false; cs.Status = 1; ruid = db.Insert(cs, true); } string req = table.Rows[i]["FK_Sleeve_ID"] + ""; if (req.IndexOf(" ") > 0) { req = req.Replace(" ", "^"); } if (req.IndexOf(" ") > 0) { req = req.Replace(" ", "^"); } if (req.IndexOf(" ") > 0) { req = req.Replace(" ", "^"); } if (req.IndexOf(" ") > 0) { req = req.Replace(" ", "^"); } if (req.IndexOf(" ") > 0) { req = req.Replace(" ", "^"); } req = req.Replace(" ", "^"); req = req.Replace(":", ";"); string[] sleeve_arrey = req.Split('^'); Sleeve see = new Sleeve(); see.FK_CoatSize_ID = Convert.ToInt32(ruid); see.Code = sleeve_arrey[0].Split(';')[0]; see.Length = Convert.ToDecimal(sleeve_arrey[0].Split(';')[1]); db.Insert(see); } } db.CommitTran(); errmsg = ""; return(true); } catch (Exception ex) { db.RollbackTran(); //回滚事务 errmsg = ex.Message; return(false); } }