/// <summary> /// 根据硬盘序列号检查软件注册状态,如果没有注册信息,添加记录并返回空,并返回注册码 /// </summary> /// <param name="HDID"></param> /// <returns></returns> public string CheckHDID(string HDID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(*) as qwe from system where (HDSerie=@HDID)"); SqlParameter[] sps = { new SqlParameter("@HDID", HDID) }; if (DbHelperSQL.GetSingle(strSql.ToString(), sps).ToString() == "0") { Hownet.Model.SysTem modST = new Hownet.Model.SysTem(); modST.CompanyName = ""; modST.Fax = ""; modST.LinkMan = ""; modST.Phone = ""; modST.Registration = ""; modST.HDSerie = HDID; Add(modST); return(string.Empty); } else { string sql = "select Registration from system where (HDSerie=@HDID)"; object obj = DbHelperSQL.GetSingle(sql, sps); return(obj.ToString()); } }
/// <summary> /// /// </summary> /// <param name="EmployeeID"></param> /// <param name="TypeID">0为当天,1为当月</param> /// <returns></returns> public DataSet GetSumAmount(int EmployeeID, int TypeID) { DateTime dtOne = DateTime.Today; DateTime dtTwo = dtOne.AddDays(1); if (TypeID == 1) { dtOne = DateTime.Today.AddDays(DateTime.Today.Day * -1 + 1); } if (TypeID == 1) { Hownet.DAL.SysTem dalST = new SysTem(); Hownet.Model.SysTem modST = dalST.GetModel(dalST.GetMaxId() - 1); if (modST.Registration.Trim() != string.Empty) { dtOne = DateTime.Parse(dtOne.Year.ToString() + "-" + dtOne.Month.ToString() + "-" + modST.Registration); } else { dtOne = DateTime.Parse(dtOne.Year.ToString() + "-" + dtOne.Month.ToString() + "-" + "01"); } } if (dtOne > DateTime.Now.Date) { dtOne = dtOne.AddMonths(-1); } StringBuilder strSql = new StringBuilder(); // strSql.Append(" SELECT Materiel.Name AS Materiel, Working.Name AS WorkingName, SUM(PayInfo.Amount) AS Amount, CONVERT(varchar(10), PayInfo.DateTime, 120) AS DateTime FROM PayInfo INNER JOIN "); //strSql.Append(" MiniEmp ON PayInfo.EmployeeID = MiniEmp.ID INNER JOIN Materiel ON PayInfo.MaterielID = Materiel.ID INNER JOIN "); // strSql.Append(" Working ON PayInfo.WorkingID = Working.ID WHERE (PayInfo.DateTime < @dtTwo) AND (PayInfo.DateTime >= @dtOne) AND (MiniEmp.IDCardID = @CardID) "); //strSql.Append(" GROUP BY PayInfo.WorkingID, PayInfo.MaterielID, MiniEmp.Name, MiniEmp.Sn, Materiel.Name, Working.Name ORDER BY PayInfo.MaterielID, PayInfo.WorkingID, CONVERT(varchar(10), PayInfo.DateTime, 120) "); strSql.Append("SELECT Materiel.Name AS Materiel, Working.Name AS WorkingName, SUM(PayInfo.Amount) AS Amount,RIGHT( CONVERT(varchar(10), PayInfo.DateTime, 120),5) AS DateTime "); strSql.Append(" FROM PayInfo INNER JOIN MiniEmp ON PayInfo.EmployeeID = MiniEmp.ID INNER JOIN Materiel ON PayInfo.MaterielID = Materiel.ID INNER JOIN "); strSql.Append(" Working ON PayInfo.WorkingID = Working.ID WHERE (PayInfo.DateTime < @dtTwo) AND (PayInfo.DateTime >= @dtOne) AND (MiniEmp.IDCardID = @CardID) "); strSql.Append(" GROUP BY PayInfo.WorkingID, PayInfo.MaterielID, MiniEmp.Name, MiniEmp.Sn, Materiel.Name, Working.Name, CONVERT(varchar(10), PayInfo.DateTime, 120) "); strSql.Append(" ORDER BY DateTime, Materiel, WorkingName"); SqlParameter[] sps = { new SqlParameter("@CardID", EmployeeID), new SqlParameter("@dtOne", dtOne), new SqlParameter("@dtTwo", dtTwo) }; return(DbHelperSQL.Query(strSql.ToString(), sps)); }
public void UpDatabase() { StringBuilder strSql = new StringBuilder(); strSql.Append(" Select Top 1 DataVer from System Order by ID Desc"); string ssVer = string.Empty; try { ssVer = DbHelperSQL.GetSingle(strSql.ToString()).ToString(); } catch { strSql.Remove(0, strSql.Length); strSql.Append("ALTER TABLE dbo.SysTem ADD DataVer nvarchar(50) NOT NULL CONSTRAINT DF_SysTem_DataVer DEFAULT '1' "); DbHelperSQL.ExecuteSql(strSql.ToString()); ssVer = "1"; } if (ssVer == "1") { strSql.Remove(0, strSql.Length); strSql.Append(" ALTER TABLE dbo.Materiel ADD "); strSql.Append(" TiaoMaH nvarchar(50) NOT NULL CONSTRAINT DF_Materiel_TiaoMaH DEFAULT '',"); strSql.Append(" ChengBengJ decimal(18, 2) NOT NULL CONSTRAINT DF_Materiel_ChengBengJ DEFAULT 0,"); strSql.Append(" LingShouJia decimal(18, 2) NOT NULL CONSTRAINT DF_Materiel_LingShouJia DEFAULT 0,"); strSql.Append(" YiJiDaiLiJia decimal(18, 2) NOT NULL CONSTRAINT DF_Materiel_YiJiDaiLiJia DEFAULT 0,"); strSql.Append(" ErJiDaiLiJia decimal(18, 2) NOT NULL CONSTRAINT DF_Materiel_ErJiDaiLiJia DEFAULT 0, "); strSql.Append(" SanJiDaiLiJia decimal(18, 2) NOT NULL CONSTRAINT DF_Materiel_SanJiDaiLiJia DEFAULT 0"); DbHelperSQL.ExecuteSql(strSql.ToString()); Hownet.Model.SysTem modST = GetModel(GetMaxId() - 1); modST.DataVer = "2"; Update(modST); } if (ssVer == "2") { strSql.Remove(0, strSql.Length); strSql.Append(" "); } }
/// <summary> /// 转入生产计划 /// </summary> /// <param name="SaleID"></param> /// <returns></returns> public int ToPlan(int SaleID, int FillMan) { try { DataTable dt = GetList("(ID=" + SaleID + ")").Tables[0]; Hownet.DAL.SysTem dalST = new SysTem(); Hownet.Model.SysTem modST = dalST.GetModel(dalST.GetMaxId()); Hownet.DAL.ProductionPlan dalPP = new Hownet.DAL.ProductionPlan(); Hownet.Model.ProductionPlan modPP = new Hownet.Model.ProductionPlan(); modPP.SalesOrderInfoID = Convert.ToInt32(dt.Rows[0]["ID"]); modPP.MaterielID = Convert.ToInt32(dt.Rows[0]["MaterielID"]); modPP.BrandID = Convert.ToInt32(dt.Rows[0]["BrandID"]); // modPP.Num = dalPP.NewNum(DateTime.Today, modST.NumType); dalPP.NewNum(DateTime.Today, modST.NumType); modPP.DateTime = DateTime.Today; modPP.LastDate = Convert.ToDateTime(dt.Rows[0]["LastDate"]); modPP.Remark = dt.Rows[0]["Remark"].ToString(); modPP.PWorkingID = modPP.BomID = 0; modPP.CompanyID = Convert.ToInt32(dt.Rows[0]["CompanyID"]); modPP.IsTicket = modPP.IsBom = false; modPP.VerifyDate = Convert.ToDateTime("1900-1-1"); modPP.VerifyMan = 0; modPP.DeparmentID = 0; modPP.UpData = 1; modPP.FillDate = DateTime.Today; modPP.FilMan = FillMan; modPP.TicketDate = Convert.ToDateTime("1900-1-1"); modPP.BedNO = string.Empty; modPP.PackingMethodID = Convert.ToInt32(dt.Rows[0]["PackingMethodID"]); modPP.SewingRemark = dt.Rows[0]["SewingRemark"].ToString(); modPP.TypeID = modPP.ParentID = 0; modPP.ParentID = 0; return(dalPP.Add(modPP)); } catch //(Exception ex) { return(0); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hownet.Model.SysTem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SysTem("); strSql.Append("CompanyName,LinkMan,Phone,Fax,HDSerie,Registration,BanKName,BankNO,BankUserName,Address,Direct2Depot,Sell4Depot,AutoClient,BoxOrPic,NumType,Mobile,SellMoney,CustOder,NotPermissions,DepotAllowNegative,IsChangedSales,BackDepotWorking,OderOne,OderTwo,OderThree,AutoCaicBoardWages,DefaultRawDepot,DefaultDepot,IsShowMoney,CompanyByUser,DoubleNotDefaultWTNum,OrderDays,OrderNeedEat,IsCheckNoWork,IsCanEditAmount,IsAutoClose,IsTicketNotNeedCaic,IsShowOutEmp,DataVer,MaterielByTask,SumByWorking)"); strSql.Append(" values ("); strSql.Append("@CompanyName,@LinkMan,@Phone,@Fax,@HDSerie,@Registration,@BanKName,@BankNO,@BankUserName,@Address,@Direct2Depot,@Sell4Depot,@AutoClient,@BoxOrPic,@NumType,@Mobile,@SellMoney,@CustOder,@NotPermissions,@DepotAllowNegative,@IsChangedSales,@BackDepotWorking,@OderOne,@OderTwo,@OderThree,@AutoCaicBoardWages,@DefaultRawDepot,@DefaultDepot,@IsShowMoney,@CompanyByUser,@DoubleNotDefaultWTNum,@OrderDays,@OrderNeedEat,@IsCheckNoWork,@IsCanEditAmount,@IsAutoClose,@IsTicketNotNeedCaic,@IsShowOutEmp,@DataVer,@MaterielByTask,@SumByWorking)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50), new SqlParameter("@LinkMan", SqlDbType.NVarChar, 12), new SqlParameter("@Phone", SqlDbType.NVarChar, 50), new SqlParameter("@Fax", SqlDbType.NVarChar, 50), new SqlParameter("@HDSerie", SqlDbType.NVarChar, 50), new SqlParameter("@Registration", SqlDbType.NVarChar, 2000), new SqlParameter("@BanKName", SqlDbType.NVarChar, 255), new SqlParameter("@BankNO", SqlDbType.NVarChar, 255), new SqlParameter("@BankUserName", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 255), new SqlParameter("@Direct2Depot", SqlDbType.Bit, 1), new SqlParameter("@Sell4Depot", SqlDbType.Bit, 1), new SqlParameter("@AutoClient", SqlDbType.Bit, 1), new SqlParameter("@BoxOrPic", SqlDbType.Bit, 1), new SqlParameter("@NumType", SqlDbType.Int, 4), new SqlParameter("@Mobile", SqlDbType.NVarChar, 255), new SqlParameter("@SellMoney", SqlDbType.Int, 4), new SqlParameter("@CustOder", SqlDbType.Bit, 1), new SqlParameter("@NotPermissions", SqlDbType.Bit, 1), new SqlParameter("@DepotAllowNegative", SqlDbType.Bit, 1), new SqlParameter("@IsChangedSales", SqlDbType.Bit, 1), new SqlParameter("@BackDepotWorking", SqlDbType.Int, 4), new SqlParameter("@OderOne", SqlDbType.Int, 4), new SqlParameter("@OderTwo", SqlDbType.Int, 4), new SqlParameter("@OderThree", SqlDbType.Int, 4), new SqlParameter("@AutoCaicBoardWages", SqlDbType.Bit, 1), new SqlParameter("@DefaultRawDepot", SqlDbType.Int, 4), new SqlParameter("@DefaultDepot", SqlDbType.Int, 4), new SqlParameter("@IsShowMoney", SqlDbType.Bit, 1), new SqlParameter("@CompanyByUser", SqlDbType.Bit, 1), new SqlParameter("@DoubleNotDefaultWTNum", SqlDbType.Decimal, 9), new SqlParameter("@OrderDays", SqlDbType.Int, 4), new SqlParameter("@OrderNeedEat", SqlDbType.Bit, 1), new SqlParameter("@IsCheckNoWork", SqlDbType.Bit, 1), new SqlParameter("@IsCanEditAmount", SqlDbType.Bit, 1), new SqlParameter("@IsAutoClose", SqlDbType.Bit, 1), new SqlParameter("@IsTicketNotNeedCaic", SqlDbType.Bit, 1), new SqlParameter("@IsShowOutEmp", SqlDbType.Bit, 1), new SqlParameter("@DataVer", SqlDbType.NVarChar, 50), new SqlParameter("@MaterielByTask", SqlDbType.Bit, 1), new SqlParameter("@SumByWorking", SqlDbType.Bit, 1) }; parameters[0].Value = model.CompanyName; parameters[1].Value = model.LinkMan; parameters[2].Value = model.Phone; parameters[3].Value = model.Fax; parameters[4].Value = model.HDSerie; parameters[5].Value = model.Registration; parameters[6].Value = model.BanKName; parameters[7].Value = model.BankNO; parameters[8].Value = model.BankUserName; parameters[9].Value = model.Address; parameters[10].Value = model.Direct2Depot; parameters[11].Value = model.Sell4Depot; parameters[12].Value = model.AutoClient; parameters[13].Value = model.BoxOrPic; parameters[14].Value = model.NumType; parameters[15].Value = model.Mobile; parameters[16].Value = model.SellMoney; parameters[17].Value = model.CustOder; parameters[18].Value = model.NotPermissions; parameters[19].Value = model.DepotAllowNegative; parameters[20].Value = model.IsChangedSales; parameters[21].Value = model.BackDepotWorking; parameters[22].Value = model.OderOne; parameters[23].Value = model.OderTwo; parameters[24].Value = model.OderThree; parameters[25].Value = model.AutoCaicBoardWages; parameters[26].Value = model.DefaultRawDepot; parameters[27].Value = model.DefaultDepot; parameters[28].Value = model.IsShowMoney; parameters[29].Value = model.CompanyByUser; parameters[30].Value = model.DoubleNotDefaultWTNum; parameters[31].Value = model.OrderDays; parameters[32].Value = model.OrderNeedEat; parameters[33].Value = model.IsCheckNoWork; parameters[34].Value = model.IsCanEditAmount; parameters[35].Value = model.IsAutoClose; parameters[36].Value = model.IsTicketNotNeedCaic; parameters[37].Value = model.IsShowOutEmp; parameters[38].Value = model.DataVer; parameters[39].Value = model.MaterielByTask; parameters[40].Value = model.SumByWorking; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hownet.Model.SysTem GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,CompanyName,LinkMan,Phone,Fax,HDSerie,Registration,BanKName,BankNO,BankUserName,Address,Direct2Depot,Sell4Depot,AutoClient,BoxOrPic,NumType,Mobile,SellMoney,CustOder,NotPermissions,DepotAllowNegative,IsChangedSales,BackDepotWorking,OderOne,OderTwo,OderThree,AutoCaicBoardWages,DefaultRawDepot,DefaultDepot,IsShowMoney,CompanyByUser,DoubleNotDefaultWTNum,OrderDays,OrderNeedEat,IsCheckNoWork,IsCanEditAmount,IsAutoClose,IsTicketNotNeedCaic,IsShowOutEmp,DataVer,MaterielByTask,SumByWorking from SysTem "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; Hownet.Model.SysTem model = new Hownet.Model.SysTem(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.CompanyName = ds.Tables[0].Rows[0]["CompanyName"].ToString(); model.LinkMan = ds.Tables[0].Rows[0]["LinkMan"].ToString(); model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString(); model.Fax = ds.Tables[0].Rows[0]["Fax"].ToString(); model.HDSerie = ds.Tables[0].Rows[0]["HDSerie"].ToString(); model.Registration = ds.Tables[0].Rows[0]["Registration"].ToString(); model.BanKName = ds.Tables[0].Rows[0]["BanKName"].ToString(); model.BankNO = ds.Tables[0].Rows[0]["BankNO"].ToString(); model.BankUserName = ds.Tables[0].Rows[0]["BankUserName"].ToString(); model.Address = ds.Tables[0].Rows[0]["Address"].ToString(); if (ds.Tables[0].Rows[0]["Direct2Depot"] != null && ds.Tables[0].Rows[0]["Direct2Depot"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Direct2Depot"].ToString() == "1") || (ds.Tables[0].Rows[0]["Direct2Depot"].ToString().ToLower() == "true")) { model.Direct2Depot = true; } else { model.Direct2Depot = false; } } if (ds.Tables[0].Rows[0]["Sell4Depot"] != null && ds.Tables[0].Rows[0]["Sell4Depot"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Sell4Depot"].ToString() == "1") || (ds.Tables[0].Rows[0]["Sell4Depot"].ToString().ToLower() == "true")) { model.Sell4Depot = true; } else { model.Sell4Depot = false; } } if (ds.Tables[0].Rows[0]["AutoClient"] != null && ds.Tables[0].Rows[0]["AutoClient"].ToString() != "") { if ((ds.Tables[0].Rows[0]["AutoClient"].ToString() == "1") || (ds.Tables[0].Rows[0]["AutoClient"].ToString().ToLower() == "true")) { model.AutoClient = true; } else { model.AutoClient = false; } } if (ds.Tables[0].Rows[0]["BoxOrPic"] != null && ds.Tables[0].Rows[0]["BoxOrPic"].ToString() != "") { if ((ds.Tables[0].Rows[0]["BoxOrPic"].ToString() == "1") || (ds.Tables[0].Rows[0]["BoxOrPic"].ToString().ToLower() == "true")) { model.BoxOrPic = true; } else { model.BoxOrPic = false; } } if (ds.Tables[0].Rows[0]["NumType"] != null && ds.Tables[0].Rows[0]["NumType"].ToString() != "") { model.NumType = int.Parse(ds.Tables[0].Rows[0]["NumType"].ToString()); } model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString(); if (ds.Tables[0].Rows[0]["SellMoney"] != null && ds.Tables[0].Rows[0]["SellMoney"].ToString() != "") { model.SellMoney = int.Parse(ds.Tables[0].Rows[0]["SellMoney"].ToString()); } if (ds.Tables[0].Rows[0]["CustOder"] != null && ds.Tables[0].Rows[0]["CustOder"].ToString() != "") { if ((ds.Tables[0].Rows[0]["CustOder"].ToString() == "1") || (ds.Tables[0].Rows[0]["CustOder"].ToString().ToLower() == "true")) { model.CustOder = true; } else { model.CustOder = false; } } if (ds.Tables[0].Rows[0]["NotPermissions"] != null && ds.Tables[0].Rows[0]["NotPermissions"].ToString() != "") { if ((ds.Tables[0].Rows[0]["NotPermissions"].ToString() == "1") || (ds.Tables[0].Rows[0]["NotPermissions"].ToString().ToLower() == "true")) { model.NotPermissions = true; } else { model.NotPermissions = false; } } if (ds.Tables[0].Rows[0]["DepotAllowNegative"] != null && ds.Tables[0].Rows[0]["DepotAllowNegative"].ToString() != "") { if ((ds.Tables[0].Rows[0]["DepotAllowNegative"].ToString() == "1") || (ds.Tables[0].Rows[0]["DepotAllowNegative"].ToString().ToLower() == "true")) { model.DepotAllowNegative = true; } else { model.DepotAllowNegative = false; } } if (ds.Tables[0].Rows[0]["IsChangedSales"] != null && ds.Tables[0].Rows[0]["IsChangedSales"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsChangedSales"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsChangedSales"].ToString().ToLower() == "true")) { model.IsChangedSales = true; } else { model.IsChangedSales = false; } } if (ds.Tables[0].Rows[0]["BackDepotWorking"] != null && ds.Tables[0].Rows[0]["BackDepotWorking"].ToString() != "") { model.BackDepotWorking = int.Parse(ds.Tables[0].Rows[0]["BackDepotWorking"].ToString()); } if (ds.Tables[0].Rows[0]["OderOne"] != null && ds.Tables[0].Rows[0]["OderOne"].ToString() != "") { model.OderOne = int.Parse(ds.Tables[0].Rows[0]["OderOne"].ToString()); } if (ds.Tables[0].Rows[0]["OderTwo"] != null && ds.Tables[0].Rows[0]["OderTwo"].ToString() != "") { model.OderTwo = int.Parse(ds.Tables[0].Rows[0]["OderTwo"].ToString()); } if (ds.Tables[0].Rows[0]["OderThree"] != null && ds.Tables[0].Rows[0]["OderThree"].ToString() != "") { model.OderThree = int.Parse(ds.Tables[0].Rows[0]["OderThree"].ToString()); } if (ds.Tables[0].Rows[0]["AutoCaicBoardWages"] != null && ds.Tables[0].Rows[0]["AutoCaicBoardWages"].ToString() != "") { if ((ds.Tables[0].Rows[0]["AutoCaicBoardWages"].ToString() == "1") || (ds.Tables[0].Rows[0]["AutoCaicBoardWages"].ToString().ToLower() == "true")) { model.AutoCaicBoardWages = true; } else { model.AutoCaicBoardWages = false; } } if (ds.Tables[0].Rows[0]["DefaultRawDepot"] != null && ds.Tables[0].Rows[0]["DefaultRawDepot"].ToString() != "") { model.DefaultRawDepot = int.Parse(ds.Tables[0].Rows[0]["DefaultRawDepot"].ToString()); } if (ds.Tables[0].Rows[0]["DefaultDepot"] != null && ds.Tables[0].Rows[0]["DefaultDepot"].ToString() != "") { model.DefaultDepot = int.Parse(ds.Tables[0].Rows[0]["DefaultDepot"].ToString()); } if (ds.Tables[0].Rows[0]["IsShowMoney"] != null && ds.Tables[0].Rows[0]["IsShowMoney"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsShowMoney"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsShowMoney"].ToString().ToLower() == "true")) { model.IsShowMoney = true; } else { model.IsShowMoney = false; } } if (ds.Tables[0].Rows[0]["CompanyByUser"] != null && ds.Tables[0].Rows[0]["CompanyByUser"].ToString() != "") { if ((ds.Tables[0].Rows[0]["CompanyByUser"].ToString() == "1") || (ds.Tables[0].Rows[0]["CompanyByUser"].ToString().ToLower() == "true")) { model.CompanyByUser = true; } else { model.CompanyByUser = false; } } if (ds.Tables[0].Rows[0]["DoubleNotDefaultWTNum"] != null && ds.Tables[0].Rows[0]["DoubleNotDefaultWTNum"].ToString() != "") { model.DoubleNotDefaultWTNum = decimal.Parse(ds.Tables[0].Rows[0]["DoubleNotDefaultWTNum"].ToString()); } if (ds.Tables[0].Rows[0]["OrderDays"] != null && ds.Tables[0].Rows[0]["OrderDays"].ToString() != "") { model.OrderDays = int.Parse(ds.Tables[0].Rows[0]["OrderDays"].ToString()); } if (ds.Tables[0].Rows[0]["OrderNeedEat"] != null && ds.Tables[0].Rows[0]["OrderNeedEat"].ToString() != "") { if ((ds.Tables[0].Rows[0]["OrderNeedEat"].ToString() == "1") || (ds.Tables[0].Rows[0]["OrderNeedEat"].ToString().ToLower() == "true")) { model.OrderNeedEat = true; } else { model.OrderNeedEat = false; } } if (ds.Tables[0].Rows[0]["IsCheckNoWork"] != null && ds.Tables[0].Rows[0]["IsCheckNoWork"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsCheckNoWork"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsCheckNoWork"].ToString().ToLower() == "true")) { model.IsCheckNoWork = true; } else { model.IsCheckNoWork = false; } } if (ds.Tables[0].Rows[0]["IsCanEditAmount"] != null && ds.Tables[0].Rows[0]["IsCanEditAmount"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsCanEditAmount"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsCanEditAmount"].ToString().ToLower() == "true")) { model.IsCanEditAmount = true; } else { model.IsCanEditAmount = false; } } if (ds.Tables[0].Rows[0]["IsAutoClose"] != null && ds.Tables[0].Rows[0]["IsAutoClose"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsAutoClose"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsAutoClose"].ToString().ToLower() == "true")) { model.IsAutoClose = true; } else { model.IsAutoClose = false; } } if (ds.Tables[0].Rows[0]["IsTicketNotNeedCaic"] != null && ds.Tables[0].Rows[0]["IsTicketNotNeedCaic"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsTicketNotNeedCaic"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsTicketNotNeedCaic"].ToString().ToLower() == "true")) { model.IsTicketNotNeedCaic = true; } else { model.IsTicketNotNeedCaic = false; } } if (ds.Tables[0].Rows[0]["IsShowOutEmp"] != null && ds.Tables[0].Rows[0]["IsShowOutEmp"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsShowOutEmp"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsShowOutEmp"].ToString().ToLower() == "true")) { model.IsShowOutEmp = true; } else { model.IsShowOutEmp = false; } } model.DataVer = ds.Tables[0].Rows[0]["DataVer"].ToString(); if (ds.Tables[0].Rows[0]["MaterielByTask"] != null && ds.Tables[0].Rows[0]["MaterielByTask"].ToString() != "") { if ((ds.Tables[0].Rows[0]["MaterielByTask"].ToString() == "1") || (ds.Tables[0].Rows[0]["MaterielByTask"].ToString().ToLower() == "true")) { model.MaterielByTask = true; } else { model.MaterielByTask = false; } } if (ds.Tables[0].Rows[0]["SumByWorking"] != null && ds.Tables[0].Rows[0]["SumByWorking"].ToString() != "") { if ((ds.Tables[0].Rows[0]["SumByWorking"].ToString() == "1") || (ds.Tables[0].Rows[0]["SumByWorking"].ToString().ToLower() == "true")) { model.SumByWorking = true; } else { model.SumByWorking = false; } } model.A = 1; return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hownet.Model.SysTem model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SysTem set "); strSql.Append("CompanyName=@CompanyName,"); strSql.Append("LinkMan=@LinkMan,"); strSql.Append("Phone=@Phone,"); strSql.Append("Fax=@Fax,"); strSql.Append("HDSerie=@HDSerie,"); strSql.Append("Registration=@Registration,"); strSql.Append("BanKName=@BanKName,"); strSql.Append("BankNO=@BankNO,"); strSql.Append("BankUserName=@BankUserName,"); strSql.Append("Address=@Address,"); strSql.Append("Direct2Depot=@Direct2Depot,"); strSql.Append("Sell4Depot=@Sell4Depot,"); strSql.Append("AutoClient=@AutoClient,"); strSql.Append("BoxOrPic=@BoxOrPic,"); strSql.Append("NumType=@NumType,"); strSql.Append("Mobile=@Mobile,"); strSql.Append("SellMoney=@SellMoney,"); strSql.Append("CustOder=@CustOder,"); strSql.Append("NotPermissions=@NotPermissions,"); strSql.Append("DepotAllowNegative=@DepotAllowNegative,"); strSql.Append("IsChangedSales=@IsChangedSales,"); strSql.Append("BackDepotWorking=@BackDepotWorking,"); strSql.Append("OderOne=@OderOne,"); strSql.Append("OderTwo=@OderTwo,"); strSql.Append("OderThree=@OderThree,"); strSql.Append("AutoCaicBoardWages=@AutoCaicBoardWages,"); strSql.Append("DefaultRawDepot=@DefaultRawDepot,"); strSql.Append("DefaultDepot=@DefaultDepot,"); strSql.Append("IsShowMoney=@IsShowMoney,"); strSql.Append("CompanyByUser=@CompanyByUser,"); strSql.Append("DoubleNotDefaultWTNum=@DoubleNotDefaultWTNum,"); strSql.Append("OrderDays=@OrderDays,"); strSql.Append("OrderNeedEat=@OrderNeedEat,"); strSql.Append("IsCheckNoWork=@IsCheckNoWork,"); strSql.Append("IsCanEditAmount=@IsCanEditAmount,"); strSql.Append("IsAutoClose=@IsAutoClose,"); strSql.Append("IsTicketNotNeedCaic=@IsTicketNotNeedCaic,"); strSql.Append("IsShowOutEmp=@IsShowOutEmp,"); strSql.Append("DataVer=@DataVer,"); strSql.Append("MaterielByTask=@MaterielByTask,"); strSql.Append("SumByWorking=@SumByWorking"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50), new SqlParameter("@LinkMan", SqlDbType.NVarChar, 12), new SqlParameter("@Phone", SqlDbType.NVarChar, 50), new SqlParameter("@Fax", SqlDbType.NVarChar, 50), new SqlParameter("@HDSerie", SqlDbType.NVarChar, 50), new SqlParameter("@Registration", SqlDbType.NVarChar, 2000), new SqlParameter("@BanKName", SqlDbType.NVarChar, 255), new SqlParameter("@BankNO", SqlDbType.NVarChar, 255), new SqlParameter("@BankUserName", SqlDbType.NVarChar, 50), new SqlParameter("@Address", SqlDbType.NVarChar, 255), new SqlParameter("@Direct2Depot", SqlDbType.Bit, 1), new SqlParameter("@Sell4Depot", SqlDbType.Bit, 1), new SqlParameter("@AutoClient", SqlDbType.Bit, 1), new SqlParameter("@BoxOrPic", SqlDbType.Bit, 1), new SqlParameter("@NumType", SqlDbType.Int, 4), new SqlParameter("@Mobile", SqlDbType.NVarChar, 255), new SqlParameter("@SellMoney", SqlDbType.Int, 4), new SqlParameter("@CustOder", SqlDbType.Bit, 1), new SqlParameter("@NotPermissions", SqlDbType.Bit, 1), new SqlParameter("@DepotAllowNegative", SqlDbType.Bit, 1), new SqlParameter("@IsChangedSales", SqlDbType.Bit, 1), new SqlParameter("@BackDepotWorking", SqlDbType.Int, 4), new SqlParameter("@OderOne", SqlDbType.Int, 4), new SqlParameter("@OderTwo", SqlDbType.Int, 4), new SqlParameter("@OderThree", SqlDbType.Int, 4), new SqlParameter("@AutoCaicBoardWages", SqlDbType.Bit, 1), new SqlParameter("@DefaultRawDepot", SqlDbType.Int, 4), new SqlParameter("@DefaultDepot", SqlDbType.Int, 4), new SqlParameter("@IsShowMoney", SqlDbType.Bit, 1), new SqlParameter("@CompanyByUser", SqlDbType.Bit, 1), new SqlParameter("@DoubleNotDefaultWTNum", SqlDbType.Decimal, 9), new SqlParameter("@OrderDays", SqlDbType.Int, 4), new SqlParameter("@OrderNeedEat", SqlDbType.Bit, 1), new SqlParameter("@IsCheckNoWork", SqlDbType.Bit, 1), new SqlParameter("@IsCanEditAmount", SqlDbType.Bit, 1), new SqlParameter("@IsAutoClose", SqlDbType.Bit, 1), new SqlParameter("@IsTicketNotNeedCaic", SqlDbType.Bit, 1), new SqlParameter("@IsShowOutEmp", SqlDbType.Bit, 1), new SqlParameter("@DataVer", SqlDbType.NVarChar, 50), new SqlParameter("@MaterielByTask", SqlDbType.Bit, 1), new SqlParameter("@SumByWorking", SqlDbType.Bit, 1), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.CompanyName; parameters[1].Value = model.LinkMan; parameters[2].Value = model.Phone; parameters[3].Value = model.Fax; parameters[4].Value = model.HDSerie; parameters[5].Value = model.Registration; parameters[6].Value = model.BanKName; parameters[7].Value = model.BankNO; parameters[8].Value = model.BankUserName; parameters[9].Value = model.Address; parameters[10].Value = model.Direct2Depot; parameters[11].Value = model.Sell4Depot; parameters[12].Value = model.AutoClient; parameters[13].Value = model.BoxOrPic; parameters[14].Value = model.NumType; parameters[15].Value = model.Mobile; parameters[16].Value = model.SellMoney; parameters[17].Value = model.CustOder; parameters[18].Value = model.NotPermissions; parameters[19].Value = model.DepotAllowNegative; parameters[20].Value = model.IsChangedSales; parameters[21].Value = model.BackDepotWorking; parameters[22].Value = model.OderOne; parameters[23].Value = model.OderTwo; parameters[24].Value = model.OderThree; parameters[25].Value = model.AutoCaicBoardWages; parameters[26].Value = model.DefaultRawDepot; parameters[27].Value = model.DefaultDepot; parameters[28].Value = model.IsShowMoney; parameters[29].Value = model.CompanyByUser; parameters[30].Value = model.DoubleNotDefaultWTNum; parameters[31].Value = model.OrderDays; parameters[32].Value = model.OrderNeedEat; parameters[33].Value = model.IsCheckNoWork; parameters[34].Value = model.IsCanEditAmount; parameters[35].Value = model.IsAutoClose; parameters[36].Value = model.IsTicketNotNeedCaic; parameters[37].Value = model.IsShowOutEmp; parameters[38].Value = model.DataVer; parameters[39].Value = model.MaterielByTask; parameters[40].Value = model.SumByWorking; parameters[41].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 取得工人工资及明细 /// </summary> /// <param name="MainID"></param> /// <returns></returns> public DataSet GetEmpPay(int MainID) { DataSet ds = new DataSet(); DataSet dsInfo = new DataSet(); StringBuilder strSql = new StringBuilder(); //strSql.Append("select ID,(SELECT BegingDate FROM PayMain WHERE (ID = Pay.MainID)) AS BegingDate, "); //strSql.Append(" (SELECT EndDate FROM PayMain AS PayMain_1 WHERE (ID = Pay.MainID)) AS EndDate,(select Departmentname from Department where (Departmentid=(select DepartmentID from employee where (employeeid=pay. EmployeeID)))) as DepartmentName , "); //strSql.Append("(select employeename from employee where (employeeid=pay.employeeid)) as EmployeeName, (select Sn from employee as qwe where (employeeid=pay.employeeid)) as Sn,Month,LastRemain,Repair,BoardWages,Payment,Fact,Remain,MainID,IsEnd,EmployeeID "); //strSql.Append(" FROM Pay where (MainID=@MainID)"); //strSql.Append(" SELECT Pay.ID, (SELECT BegingDate FROM PayMain WHERE (ID = Pay.MainID)) AS BegingDate, "); //strSql.Append(" (SELECT EndDate FROM PayMain AS PayMain_1 WHERE (ID = Pay.MainID)) AS EndDate, 1 as A,"); //strSql.Append(" (SELECT DepartmentName FROM Department WHERE (DepartmentID = Employee_2.DepartmentID)) "); //strSql.Append(" AS DepartmentName, Pay.Month, Pay.LastRemain, Pay.Repair, Pay.BoardWages, Pay.Payment, "); //strSql.Append(" Pay.Fact, Pay.Remain, Pay.MainID, Pay.IsEnd, Pay.EmployeeID, Employee_2.EmployeeName, "); //strSql.Append(" Employee_2.Sn, (SELECT OtherTypeName FROM OtherType WHERE (OtherTypeID = Employee_2.PayID)) "); //strSql.Append(" AS PayName, Employee_2.LassMoney, Employee_2.Royalty, Employee_2.PayID FROM Pay INNER JOIN "); //strSql.Append(" Employee AS Employee_2 ON Pay.EmployeeID = Employee_2.EmployeeID WHERE (Pay.MainID = @MainID)"); //strSql.Append("SELECT Pay.ID, 0 as PayID,0 as LassMoney,0 as Royalty,(SELECT BegingDate FROM PayMain WHERE (ID = Pay.MainID)) AS BegingDate, (SELECT EndDate "); //strSql.Append(" FROM PayMain AS PayMain_1 WHERE (ID = Pay.MainID)) AS EndDate, 1 AS A, (SELECT Name FROM Deparment "); //strSql.Append(" WHERE (ID = MiniEmp.DepartmentID)) AS DepartmentName, Pay.Month, Pay.LastRemain,Pay.Fine, Pay.Repair,Pay.FullAttendance, Pay.BoardWages, Pay.Deposit,"); //strSql.Append(" Pay.Payment, Pay.Fact, Pay.Remain, Pay.MainID, Pay.IsEnd, Pay.EmployeeID, MiniEmp.Name, MiniEmp.Sn,MiniEmp.Deposit as AllDeposit FROM Pay INNER JOIN "); //strSql.Append(" MiniEmp ON Pay.EmployeeID = MiniEmp.ID WHERE (Pay.MainID = @MainID)"); strSql.Append("SELECT Pay.ID, (SELECT BegingDate FROM PayMain WHERE (ID = Pay.MainID)) AS BegingDate, (SELECT EndDate "); strSql.Append(" FROM PayMain AS PayMain_1 WHERE (ID = Pay.MainID)) AS EndDate, 1 AS A, Pay.Month, Pay.LastRemain, Pay.Fine, Pay.Repair, Pay.FullAttendance, "); strSql.Append(" Pay.BoardWages, Pay.Deposit, Pay.Payment, Pay.Fact, Pay.Remain, Pay.MainID, Pay.IsEnd, Pay.EmployeeID, MiniEmp.DepartmentID, MiniEmp.Sn, "); strSql.Append(" MiniEmp.Deposit AS AllDeposit, MiniEmp.PayID, MiniEmp.LassMoney,MiniEmp.BankNO,MiniEmp.BankAccountName,MiniEmp.BankName, MiniEmp.Royalty, MiniEmp.NeedDeposit, MiniEmp.Deposit AS TemDeposit "); strSql.Append(" ,Pay.Add1, Pay.Add2, Pay.Add3, Pay.Add4, Pay.Add5, Pay.Jian1, Pay.Jian2, Pay.Jian3, Pay.Jian4, Pay.Jian5, Pay.ActualMonth,Pay.NotFact "); strSql.Append(" FROM Pay INNER JOIN MiniEmp ON Pay.EmployeeID = MiniEmp.ID WHERE (Pay.MainID = @MainID)"); SqlParameter[] sp = { new SqlParameter("MainID", MainID) }; ds = DbHelperSQL.Query(strSql.ToString(), sp); ds.Tables[0].TableName = "Main"; // ds.Tables[0].Columns.Add("SumAmount", typeof(int)); strSql.Remove(0, strSql.Length); //strSql.Append("select (select Employeename from employee where (employeeid=paysum.employeeid)) as EmployeeName ,(select Materielname from materiel where (materielid=paysum.MaterielID)) as MaterielName, "); //strSql.Append(" (select workingname from working where (workingid=paysum.WorkingID)) as WorkingName,MaterielID,WorkingID, "); //strSql.Append(" Amount,Price,Amount*Price as Money, EmployeeID "); //strSql.Append(" FROM PaySum where (PayMainID=@MainID)"); strSql.Append("SELECT MaterielID, WorkingID, Amount, Price, Amount * Price AS Money, EmployeeID "); strSql.Append(" FROM PaySum WHERE (PayMainID = @MainID)"); SqlParameter[] sp1 = { new SqlParameter("MainID", MainID) }; dsInfo = DbHelperSQL.Query(strSql.ToString(), sp1); dsInfo.Tables[0].TableName = "Info"; //for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //{ // int employeeid = int.Parse(ds.Tables[0].Rows[i]["EmployeeID"].ToString()); // int amount = 0; // for (int j = 0; j < dsInfo.Tables[0].Rows.Count; j++) // { // if (int.Parse(dsInfo.Tables[0].Rows[j]["EmployeeID"].ToString()) == employeeid) // { // amount += int.Parse(dsInfo.Tables[0].Rows[j]["Amount"].ToString()); // } // } // ds.Tables[0].Rows[i]["SumAmount"] = amount; //} ds.Tables.Add(dsInfo.Tables[0].Copy()); dsInfo.Clear(); strSql.Remove(0, strSql.Length); Hownet.DAL.SysTem dalST = new SysTem(); Hownet.Model.SysTem modST = dalST.GetModel(dalST.GetMaxId() - 1); DataTable dtNoDefault = new DataTable(); if (modST.DoubleNotDefaultWTNum > 0) { strSql.Append("SELECT PaySum.MaterielID, PaySum.WorkingID, PaySum.Amount, PaySum.Price, PaySum.Amount * PaySum.Price AS Money, "); strSql.Append(" PaySum.EmployeeID FROM PaySum INNER JOIN MiniEmp AS MiniEmp_1 ON PaySum.EmployeeID = MiniEmp_1.ID INNER JOIN "); strSql.Append(" Working ON PaySum.WorkingID = Working.ID WHERE (PaySum.PayMainID = @MainID) AND (',' + MiniEmp_1.DefaultWorkType "); strSql.Append(" + ',' NOT LIKE '%,' + CAST(Working.WorkTypeID AS nvarchar) + ',%') AND (PaySum.MaterielID > 0) "); dtNoDefault = DbHelperSQL.Query(strSql.ToString(), sp1).Tables[0]; } else { strSql.Append("SELECT PaySum.MaterielID, PaySum.WorkingID, PaySum.Amount, PaySum.Price, PaySum.Amount * PaySum.Price AS Money, "); strSql.Append(" PaySum.EmployeeID FROM PaySum Where (ID=0)"); dtNoDefault = DbHelperSQL.Query(strSql.ToString(), sp1).Tables[0]; } dtNoDefault.TableName = "NoDefault"; ds.Tables.Add(dtNoDefault.Copy()); dtNoDefault.Clear(); try { ds.Relations.Add("明细", ds.Tables["Main"].Columns["EmployeeID"], ds.Tables["Info"].Columns["EmployeeID"]); } catch { } try { ds.Relations.Add("非默认工种", ds.Tables["Main"].Columns["EmployeeID"], ds.Tables["NoDefault"].Columns["EmployeeID"]); } catch (Exception ex) { } return(ds); }
private void frCompanyInfo_Load(object sender, EventArgs e) { dtOT = bllOT.GetList("(TypeID=" + (int)Hownet.BLL.Enums.OtherType.系统设置 + ")").Tables[0]; DataRow[] drs = dtOT.Select("(Name='物料使用条码出入仓')"); if (drs.Length == 0) { DataTable dtTem = dtOT.Clone(); DataRow dr = dtTem.NewRow(); dr["A"] = 1; dr["ID"] = 0; dr["Name"] = "物料使用条码出入仓"; dr["TypeID"] = (int)Hownet.BLL.Enums.OtherType.系统设置; dr["Value"] = "False"; dtTem.Rows.Add(dr); bllOT.AddByDt(dtTem); } else { try { _chb物料使用条码出入仓.Checked = Convert.ToBoolean(drs[0]["Value"]); } catch (Exception ex) { } } drs = dtOT.Select("(Name='成品需按货架存放')"); if (drs.Length == 0) { DataTable dtTem = dtOT.Clone(); DataRow dr = dtTem.NewRow(); dr["A"] = 1; dr["ID"] = 0; dr["Name"] = "成品需按货架存放"; dr["TypeID"] = (int)Hownet.BLL.Enums.OtherType.系统设置; dr["Value"] = "False"; dtTem.Rows.Add(dr); bllOT.AddByDt(dtTem); } else { try { _chb成品需按货架存放.Checked = Convert.ToBoolean(drs[0]["Value"]); } catch (Exception ex) { } } drs = dtOT.Select("(Name='分组显示为部位')"); if (drs.Length == 0) { DataTable dtTem = dtOT.Clone(); DataRow dr = dtTem.NewRow(); dr["A"] = 1; dr["ID"] = 0; dr["Name"] = "分组显示为部位"; dr["TypeID"] = (int)Hownet.BLL.Enums.OtherType.系统设置; dr["Value"] = "False"; dtTem.Rows.Add(dr); bllOT.AddByDt(dtTem); } else { try { _chb分组显示为部位.Checked = Convert.ToBoolean(drs[0]["Value"]); } catch (Exception ex) { } } drs = dtOT.Select("(Name='备份文件夹位置')"); if (drs.Length == 0) { DataTable dtTem = dtOT.Clone(); DataRow dr = dtTem.NewRow(); dr["A"] = 1; dr["ID"] = 0; dr["Name"] = "备份文件夹位置"; dr["TypeID"] = (int)Hownet.BLL.Enums.OtherType.系统设置; dr["Value"] = @"E:\Backup"; dtTem.Rows.Add(dr); bllOT.AddByDt(dtTem); } else { try { _teBackUpDir.Text = drs[0]["Value"].ToString(); } catch (Exception ex) { } } int _id = bllST.GetMaxId() - 1; // ds = bllST.GetList("(ID=" + _id + ")"); modST = bllST.GetModel(_id); Hownet.BLL.Working bllW = new Hownet.BLL.Working(); Hownet.BLL.Deparment bllD = new Hownet.BLL.Deparment(); _coBackDepot.DataSource = bllW.GetList("(IsSpecial=0)").Tables[0]; DataTable dtD = bllD.GetList("(TypeID=42)").Tables[0]; _coDefaultRaw.DataSource = dtD; DataTable dtDD = bllD.GetList("(TypeID=42) OR (TypeID=39)").Tables[0]; //DataRow dr = dtDD.NewRow(); //dr["ID"] = 0; //dr["Name"] = string.Empty; //dtDD.Rows.Add(dr); _coDefaultDepot.DataSource = dtDD; if (modST != null) { ID = modST.ID; _address.Text = modST.Address; _bank.Text = modST.BanKName; _bankID.Text = modST.BankNO; _bankUser.Text = modST.BankUserName; _comName.Text = modST.CompanyName; _fax.Text = modST.Fax; _linkMan.Text = modST.LinkMan; _phone.Text = modST.Phone; _ceDirect.Checked = modST.Direct2Depot; _ceSell.Checked = modST.Sell4Depot; _ceAutoClient.Checked = modST.AutoClient; _chBoxOrPic.Checked = modST.BoxOrPic; _Mobile.Text = modST.Mobile; _coNumType.SelectedIndex = modST.NumType; _coSellMoney.SelectedIndex = modST.SellMoney; _ceCustom.Checked = modST.CustOder; _chNotPermissions.Checked = modST.NotPermissions; _ceDepotAllowNegative.Checked = modST.DepotAllowNegative; _ceIsChangedSales.Checked = modST.IsChangedSales; _coBackDepot.SelectedValue = modST.BackDepotWorking; _mbOderOne.Text = modST.OderOne.ToString().PadLeft(2, '0'); _mbOderTwo.Text = modST.OderTwo.ToString().PadLeft(2, '0'); _mbOrderThree.Text = modST.OderThree.ToString().PadLeft(2, '0'); _ceAutoCaicBoardWages.Checked = modST.AutoCaicBoardWages; _coDefaultRaw.SelectedValue = modST.DefaultRawDepot; _coDefaultDepot.SelectedValue = modST.DefaultDepot; _ceIsShowMoney.Checked = modST.IsShowMoney; _ceCompanyByUser.Checked = modST.CompanyByUser; _teDoubleNotDefaultWTNum.Text = modST.DoubleNotDefaultWTNum.ToString(); _meOrderDays.Text = modST.OrderDays.ToString(); _ceOrderNeedEat.Checked = modST.OrderNeedEat; _ceIsCheckNoWork.Checked = modST.IsCheckNoWork; _ceIsCanEditAmount.Checked = modST.IsCanEditAmount; _ceIsAutoClose.Checked = modST.IsAutoClose; _ceIsTicketNotNeedCaic.Checked = modST.IsTicketNotNeedCaic; _ceIsShowOutEmp.Checked = modST.IsShowOutEmp; _chMaterielByTask.Checked = modST.MaterielByTask; _chMaterielByTask.Enabled = bllST.CheckCanSetMatByTask(); _ceSumByWorking.Checked = modST.SumByWorking; _tbRegistration.Text = modST.Registration; } else { modST = new Hownet.Model.SysTem(); _coDefaultRaw.SelectedValue = _coDefaultDepot.SelectedValue = 0; _teDoubleNotDefaultWTNum.Text = "0"; } }