/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.Manufacturer model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_Manufacturer("); strSql.Append("manufacturerName,manufacturerTel,manufacturerAdd)"); strSql.Append(" values ("); strSql.Append("@manufacturerName,@manufacturerTel,@manufacturerAdd)"); OleDbParameter[] parameters = { new OleDbParameter("@manufacturerName", OleDbType.VarChar,255), new OleDbParameter("@manufacturerTel", OleDbType.VarChar,255), new OleDbParameter("@manufacturerAdd", OleDbType.VarChar,255)}; parameters[0].Value = model.manufacturerName; parameters[1].Value = model.manufacturerTel; parameters[2].Value = model.manufacturerAdd; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.BuLiangShiJianInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_BuLiangShiJian("); strSql.Append("b_ylqxmc,b_ggxh,b_sccj,b_cpdm,b_sl,b_sydw,b_scrq,b_zlsgqk,b_bgr,b_bgsj,b_sydwyj,b_fzr,b_resj,b_qyzgfzryj,b_fzrqz,b_fzrqzsj,b_zgclqk,b_zgjbr,b_zgjbsj,DataType)"); strSql.Append(" values ("); strSql.Append("@b_ylqxmc,@b_ggxh,@b_sccj,@b_cpdm,@b_sl,@b_sydw,@b_scrq,@b_zlsgqk,@b_bgr,@b_bgsj,@b_sydwyj,@b_fzr,@b_resj,@b_qyzgfzryj,@b_fzrqz,@b_fzrqzsj,@b_zgclqk,@b_zgjbr,@b_zgjbsj,@DataType)"); OleDbParameter[] parameters = { new OleDbParameter("@b_ylqxmc", OleDbType.VarChar,255), new OleDbParameter("@b_ggxh", OleDbType.VarChar,255), new OleDbParameter("@b_sccj", OleDbType.VarChar,255), new OleDbParameter("@b_cpdm", OleDbType.VarChar,255), new OleDbParameter("@b_sl", OleDbType.Integer,4), new OleDbParameter("@b_sydw", OleDbType.VarChar,255), new OleDbParameter("@b_scrq", OleDbType.VarChar,255), new OleDbParameter("@b_zlsgqk", OleDbType.VarChar,255), new OleDbParameter("@b_bgr", OleDbType.VarChar,255), new OleDbParameter("@b_bgsj", OleDbType.Date), new OleDbParameter("@b_sydwyj", OleDbType.VarChar,255), new OleDbParameter("@b_fzr", OleDbType.VarChar,255), new OleDbParameter("@b_resj", OleDbType.Date), new OleDbParameter("@b_qyzgfzryj", OleDbType.VarChar,255), new OleDbParameter("@b_fzrqz", OleDbType.VarChar,255), new OleDbParameter("@b_fzrqzsj", OleDbType.Date), new OleDbParameter("@b_zgclqk", OleDbType.VarChar,255), new OleDbParameter("@b_zgjbr", OleDbType.VarChar,255), new OleDbParameter("@b_zgjbsj", OleDbType.Date), new OleDbParameter("@DataType", OleDbType.Integer,4),}; parameters[0].Value = model.b_ylqxmc; parameters[1].Value = model.b_ggxh; parameters[2].Value = model.b_sccj; parameters[3].Value = model.b_cpdm; parameters[4].Value = model.b_sl; parameters[5].Value = model.b_sydw; parameters[6].Value = model.b_scrq; parameters[7].Value = model.b_zlsgqk; parameters[8].Value = model.b_bgr; parameters[9].Value = model.b_bgsj; parameters[10].Value = model.b_sydwyj; parameters[11].Value = model.b_fzr; parameters[12].Value = model.b_resj; parameters[13].Value = model.b_qyzgfzryj; parameters[14].Value = model.b_fzrqz; parameters[15].Value = model.b_fzrqzsj; parameters[16].Value = model.b_zgclqk; parameters[17].Value = model.b_zgjbr; parameters[18].Value = model.b_zgjbsj; parameters[19].Value = model.DataType; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
public void GetListData(UIModels.EntryType _type,KPS.Model.DeviceInfo _device) { ThisType = _type; DeviceInfo = _device; _thread = new System.Threading.Thread(new System.Threading.ThreadStart(ThreadStart)); _thread.IsBackground = true; _thread.Start(); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.ShouHouInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_ShouHou("); strSql.Append("y_date,y_pm,y_ggxh,y_dw,y_sl,y_sccj,y_cpdm,y_ghdw,y_cpzczh,y_scph,y_mjph,y_yxq,y_isHGZ,y_zlqk,y_zgy,y_fhrqz,y_managertype,DataType)"); strSql.Append(" values ("); strSql.Append("@y_date,@y_pm,@y_ggxh,@y_dw,@y_sl,@y_sccj,@y_cpdm,@y_ghdw,@y_cpzczh,@y_scph,@y_mjph,@y_yxq,@y_isHGZ,@y_zlqk,@y_zgy,@y_fhrqz,@y_managertype,@DataType)"); OleDbParameter[] parameters = { new OleDbParameter("@y_date", OleDbType.Date), new OleDbParameter("@y_pm", OleDbType.VarChar,255), new OleDbParameter("@y_ggxh", OleDbType.VarChar,255), new OleDbParameter("@y_dw", OleDbType.VarChar,255), new OleDbParameter("@y_sl", OleDbType.Integer,4), new OleDbParameter("@y_sccj", OleDbType.VarChar,255), new OleDbParameter("@y_cpdm", OleDbType.VarChar,255), new OleDbParameter("@y_ghdw", OleDbType.VarChar,255), new OleDbParameter("@y_cpzczh", OleDbType.VarChar,255), new OleDbParameter("@y_scph", OleDbType.VarChar,255), new OleDbParameter("@y_mjph", OleDbType.VarChar,255), new OleDbParameter("@y_yxq", OleDbType.VarChar,255), new OleDbParameter("@y_isHGZ", OleDbType.Boolean,1), new OleDbParameter("@y_zlqk", OleDbType.VarChar,255), new OleDbParameter("@y_zgy", OleDbType.VarChar,255), new OleDbParameter("@y_fhrqz", OleDbType.VarChar,255), new OleDbParameter("@y_managertype",OleDbType.Boolean,1), new OleDbParameter("@DataType", OleDbType.Integer,4),}; parameters[0].Value = model.y_date; parameters[1].Value = model.y_pm; parameters[2].Value = model.y_ggxh; parameters[3].Value = model.y_dw; parameters[4].Value = model.y_sl; parameters[5].Value = model.y_sccj; parameters[6].Value = model.y_cpdm; parameters[7].Value = model.y_ghdw; parameters[8].Value = model.y_cpzczh; parameters[9].Value = model.y_scph; parameters[10].Value = model.y_mjph; parameters[11].Value = model.y_yxq; parameters[12].Value = model.y_isHGZ; parameters[13].Value = model.y_zlqk; parameters[14].Value = model.y_zgy; parameters[15].Value = model.y_fhrqz; parameters[16].Value = model.y_managertype; parameters[17].Value = model.DataType; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.GouJinInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_GouJin("); strSql.Append("p_date,p_cpmc,p_ggxh,p_clmc,p_ph,p_dw,p_sl1,p_mjph,p_zzs,p_zczh,p_gys,p_sl2,p_jsr,DataType,RemarkInfo,p_valid,Reconfirm)"); strSql.Append(" values ("); strSql.Append("@p_date,@p_cpmc,@p_ggxh,@p_clmc,@p_ph,@p_dw,@p_sl1,@p_mjph,@p_zzs,@p_zczh,@p_gys,@p_sl2,@p_jsr,@DataType,@RemarkInfo,@p_valid,@Reconfirm)"); OleDbParameter[] parameters = { new OleDbParameter("@p_date", OleDbType.Date), new OleDbParameter("@p_cpmc", OleDbType.VarChar,255), new OleDbParameter("@p_ggxh", OleDbType.VarChar,255), new OleDbParameter("@p_clmc", OleDbType.VarChar,255), new OleDbParameter("@p_ph", OleDbType.VarChar,255), new OleDbParameter("@p_dw", OleDbType.VarChar,255), new OleDbParameter("@p_sl1", OleDbType.Integer,4), new OleDbParameter("@p_mjph", OleDbType.VarChar,255), new OleDbParameter("@p_zzs", OleDbType.VarChar,255), new OleDbParameter("@p_zczh", OleDbType.VarChar,255), new OleDbParameter("@p_gys", OleDbType.VarChar,255), new OleDbParameter("@p_sl2", OleDbType.VarChar,255), new OleDbParameter("@p_jsr", OleDbType.VarChar,255), new OleDbParameter("@DataType", OleDbType.Integer,4), new OleDbParameter("@RemarkInfo", OleDbType.VarChar,255), new OleDbParameter("@p_valid", OleDbType.Date),//有效期 new OleDbParameter("@Reconfirm", OleDbType.VarChar,255)//复核人 }; parameters[0].Value = model.p_date; parameters[1].Value = model.p_cpmc; parameters[2].Value = model.p_ggxh; parameters[3].Value = model.p_clmc; parameters[4].Value = model.p_ph; parameters[5].Value = model.p_dw; parameters[6].Value = model.p_sl1; parameters[7].Value = model.p_mjph; parameters[8].Value = model.p_zzs; parameters[9].Value = model.p_zczh; parameters[10].Value = model.p_gys; parameters[11].Value = model.p_sl2; parameters[12].Value = model.p_jsr; parameters[13].Value = model.DataType; parameters[14].Value = model.RemarkInfo; parameters[15].Value = model.p_valid;//有效期 parameters[16].Value = model.Reconfirm;//复核人 int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
public bool CheckIfRealPerson(User user) { KPS client = new KPS(); bool result; result = client.TCDogrula(user.FirstName, user.LastName, user.DateOfBirth.Year.ToString()); Console.WriteLine("Kimlik doğrulama : " + (result ? "başarılı" : "başarısız")); return(result); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.CunChuInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_CunChu("); strSql.Append("s_csmc,s_date,s_sywdfw,s_syxdsdfw,s_sworxw,s_wd,s_sd,s_cqcs,s_wded,s_sded,s_jlr,DataType)"); strSql.Append(" values ("); strSql.Append("@s_csmc,@s_date,@s_sywdfw,@s_syxdsdfw,@s_sworxw,@s_wd,@s_sd,@s_cqcs,@s_wded,@s_sded,@s_jlr,@DataType)"); OleDbParameter[] parameters = { new OleDbParameter("@s_csmc", OleDbType.VarChar,255), new OleDbParameter("@s_date", OleDbType.Date), new OleDbParameter("@s_sywdfw", OleDbType.VarChar,255), new OleDbParameter("@s_syxdsdfw", OleDbType.VarChar,255), new OleDbParameter("@s_sworxw", OleDbType.Integer,4), new OleDbParameter("@s_wd", OleDbType.VarChar,255), new OleDbParameter("@s_sd", OleDbType.VarChar,255), new OleDbParameter("@s_cqcs", OleDbType.VarChar,255), new OleDbParameter("@s_wded", OleDbType.VarChar,255), new OleDbParameter("@s_sded", OleDbType.VarChar,255), new OleDbParameter("@s_jlr", OleDbType.VarChar,255), new OleDbParameter("@DataType", OleDbType.Integer,4)}; parameters[0].Value = model.s_csmc; parameters[1].Value = model.s_date; parameters[2].Value = model.s_sywdfw; parameters[3].Value = model.s_syxdsdfw; parameters[4].Value = model.s_sworxw; parameters[5].Value = model.s_wd; parameters[6].Value = model.s_sd; parameters[7].Value = model.s_cqcs; parameters[8].Value = model.s_wded; parameters[9].Value = model.s_sded; parameters[10].Value = model.s_jlr; parameters[11].Value = model.DataType; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// ����һ������ /// </summary> public bool Add(KPS.Model.ProcessLoggingInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_ProcessLogging("); strSql.Append("ProcessDate,ProcessCustomerUnit,Processlinkman,Processtel,ProcessProductName,ProcessStandard,ProcessPurchasingDate,ProcessContentInquired,ProcessHandlingSuggestion,ProcessServiceUser,DataType)"); strSql.Append(" values ("); strSql.Append("@ProcessDate,@ProcessCustomerUnit,@Processlinkman,@Processtel,@ProcessProductName,@ProcessStandard,@ProcessPurchasingDate,@ProcessContentInquired,@ProcessHandlingSuggestion,@ProcessServiceUser,@DataType)"); OleDbParameter[] parameters = { new OleDbParameter("@ProcessDate", OleDbType.Date), new OleDbParameter("@ProcessCustomerUnit", OleDbType.VarChar,255), new OleDbParameter("@Processlinkman", OleDbType.VarChar,255), new OleDbParameter("@Processtel", OleDbType.VarChar,255), new OleDbParameter("@ProcessProductName", OleDbType.VarChar,255), new OleDbParameter("@ProcessStandard", OleDbType.VarChar,255), new OleDbParameter("@ProcessPurchasingDate", OleDbType.Date), new OleDbParameter("@ProcessContentInquired", OleDbType.VarChar,255), new OleDbParameter("@ProcessHandlingSuggestion", OleDbType.VarChar,255), new OleDbParameter("@ProcessServiceUser", OleDbType.VarChar,255), new OleDbParameter("@DataType", OleDbType.Integer,4)}; parameters[0].Value = model.ProcessDate; parameters[1].Value = model.ProcessCustomerUnit; parameters[2].Value = model.Processlinkman; parameters[3].Value = model.Processtel; parameters[4].Value = model.ProcessProductName; parameters[5].Value = model.ProcessStandard; parameters[6].Value = model.ProcessPurchasingDate; parameters[7].Value = model.ProcessContentInquired; parameters[8].Value = model.ProcessHandlingSuggestion; parameters[9].Value = model.ProcessServiceUser; parameters[10].Value = model.DataType; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.Supplier model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_Supplier("); strSql.Append("supplierName)"); strSql.Append(" values ("); strSql.Append("@supplierName)"); OleDbParameter[] parameters = { new OleDbParameter("@supplierName", OleDbType.VarChar,255)}; parameters[0].Value = model.supplierName; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.ProductInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_ProductInfo("); strSql.Append("productname,promoney)"); strSql.Append(" values ("); strSql.Append("@productname,@promoney)"); OleDbParameter[] parameters = { new OleDbParameter("@productname", OleDbType.VarChar,255), new OleDbParameter("@promoney", OleDbType.Double,2)}; parameters[0].Value = model.productname; parameters[1].Value = model.promoney; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.PermissionInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into PSI_Permission("); strSql.Append("userName,moduleInfoID)"); strSql.Append(" values ("); strSql.Append("@userName,@moduleInfoID)"); OleDbParameter[] parameters = { new OleDbParameter("@userName", OleDbType.VarChar,255), new OleDbParameter("@moduleInfoID", OleDbType.Integer,4)}; parameters[0].Value = model.userName; parameters[1].Value = model.moduleInfoID; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.Supplier model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update PSI_Supplier set "); strSql.Append("supplierName=@supplierName"); strSql.Append(" where supplierID=@supplierID"); OleDbParameter[] parameters = { new OleDbParameter("@supplierName", OleDbType.VarChar,255), new OleDbParameter("@supplierID", OleDbType.Integer,4)}; parameters[0].Value = model.supplierName; parameters[1].Value = model.supplierID; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.GouJinInfo model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.PermissionInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update PSI_Permission set "); strSql.Append("userName=@userName,"); strSql.Append("moduleInfoID=@moduleInfoID"); strSql.Append(" where permissionID=@permissionID"); OleDbParameter[] parameters = { new OleDbParameter("@userName", OleDbType.VarChar,255), new OleDbParameter("@moduleInfoID", OleDbType.Integer,4), new OleDbParameter("@permissionID", OleDbType.Integer,4)}; parameters[0].Value = model.userName; parameters[1].Value = model.moduleInfoID; parameters[2].Value = model.permissionID; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.Manufacturer model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.GouJinInfo model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.GouJinInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update PSI_GouJin set "); strSql.Append("p_date=@p_date,"); strSql.Append("p_cpmc=@p_cpmc,"); strSql.Append("p_ggxh=@p_ggxh,"); strSql.Append("p_clmc=@p_clmc,"); strSql.Append("p_ph=@p_ph,"); strSql.Append("p_dw=@p_dw,"); strSql.Append("p_sl1=@p_sl1,"); strSql.Append("p_mjph=@p_mjph,"); strSql.Append("p_zzs=@p_zzs,"); strSql.Append("p_zczh=@p_zczh,"); strSql.Append("p_gys=@p_gys,"); strSql.Append("p_sl2=@p_sl2,"); strSql.Append("p_jsr=@p_jsr,"); strSql.Append("DataType=@DataType,"); strSql.Append("RemarkInfo=@RemarkInfo,"); strSql.Append("p_valid=@p_valid,");//有效期 strSql.Append("Reconfirm=@Reconfirm");//复核人 strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@p_date", OleDbType.Date), new OleDbParameter("@p_cpmc", OleDbType.VarChar,255), new OleDbParameter("@p_ggxh", OleDbType.VarChar,255), new OleDbParameter("@p_clmc", OleDbType.VarChar,255), new OleDbParameter("@p_ph", OleDbType.VarChar,255), new OleDbParameter("@p_dw", OleDbType.VarChar,255), new OleDbParameter("@p_sl1", OleDbType.Integer,4), new OleDbParameter("@p_mjph", OleDbType.VarChar,255), new OleDbParameter("@p_zzs", OleDbType.VarChar,255), new OleDbParameter("@p_zczh", OleDbType.VarChar,255), new OleDbParameter("@p_gys", OleDbType.VarChar,255), new OleDbParameter("@p_sl2", OleDbType.VarChar,255), new OleDbParameter("@p_jsr", OleDbType.VarChar,255), new OleDbParameter("@DataType", OleDbType.Integer,4), new OleDbParameter("@RemarkInfo", OleDbType.VarChar,255), new OleDbParameter("@p_valid", OleDbType.Date),//有效期 new OleDbParameter("@Reconfirm", OleDbType.VarChar,255),//复核人 new OleDbParameter("@ID", OleDbType.Integer,4)}; parameters[0].Value = model.p_date; parameters[1].Value = model.p_cpmc; parameters[2].Value = model.p_ggxh; parameters[3].Value = model.p_clmc; parameters[4].Value = model.p_ph; parameters[5].Value = model.p_dw; parameters[6].Value = model.p_sl1; parameters[7].Value = model.p_mjph; parameters[8].Value = model.p_zzs; parameters[9].Value = model.p_zczh; parameters[10].Value = model.p_gys; parameters[11].Value = model.p_sl2; parameters[12].Value = model.p_jsr; parameters[13].Value = model.DataType; parameters[14].Value = model.RemarkInfo; parameters[15].Value = model.p_valid;//有效期 parameters[16].Value = model.Reconfirm;//复核人 parameters[17].Value = model.ID; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.CunChuInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update PSI_CunChu set "); strSql.Append("s_csmc=@s_csmc,"); strSql.Append("s_date=@s_date,"); strSql.Append("s_sywdfw=@s_sywdfw,"); strSql.Append("s_syxdsdfw=@s_syxdsdfw,"); strSql.Append("s_sworxw=@s_sworxw,"); strSql.Append("s_wd=@s_wd,"); strSql.Append("s_sd=@s_sd,"); strSql.Append("s_cqcs=@s_cqcs,"); strSql.Append("s_wded=@s_wded,"); strSql.Append("s_sded=@s_sded,"); strSql.Append("s_jlr=@s_jlr,"); strSql.Append("DataType=@DataType"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@s_csmc", OleDbType.VarChar,255), new OleDbParameter("@s_date", OleDbType.Date), new OleDbParameter("@s_sywdfw", OleDbType.VarChar,255), new OleDbParameter("@s_syxdsdfw", OleDbType.VarChar,255), new OleDbParameter("@s_sworxw", OleDbType.Integer,4), new OleDbParameter("@s_wd", OleDbType.VarChar,255), new OleDbParameter("@s_sd", OleDbType.VarChar,255), new OleDbParameter("@s_cqcs", OleDbType.VarChar,255), new OleDbParameter("@s_wded", OleDbType.VarChar,255), new OleDbParameter("@s_sded", OleDbType.VarChar,255), new OleDbParameter("@s_jlr", OleDbType.VarChar,255), new OleDbParameter("@DataType", OleDbType.Integer,4), new OleDbParameter("@ID", OleDbType.Integer,4)}; parameters[0].Value = model.s_csmc; parameters[1].Value = model.s_date; parameters[2].Value = model.s_sywdfw; parameters[3].Value = model.s_syxdsdfw; parameters[4].Value = model.s_sworxw; parameters[5].Value = model.s_wd; parameters[6].Value = model.s_sd; parameters[7].Value = model.s_cqcs; parameters[8].Value = model.s_wded; parameters[9].Value = model.s_sded; parameters[10].Value = model.s_jlr; parameters[11].Value = model.DataType; parameters[12].Value = model.ID; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据(内部根据 产品名称+厂家+注册证号+批号 判断是否已存在,若存在则只更新数量) /// </summary> public bool Add(KPS.Model.GouJinInfo model) { bool _bolSucced = false; bool _RecordIsExt = false; int _ToltalRecordCount = 0; int _RecordID = -1; #region 判断产品记录是否已存在 StringBuilder strQuerySQL = new StringBuilder(); strQuerySQL.Append("select ID,p_date,p_cpmc,p_ggxh,p_clmc,p_ph,p_dw,p_sl1,p_mjph,p_zzs,p_zczh,p_gys,p_sl2,p_jsr,DataType,RemarkInfo "); strQuerySQL.Append(" FROM PSI_Inventory where p_cpmc=@p_cpmc and p_zczh=@p_zczh and p_zzs=@p_zzs and p_ph=@p_ph"); OleDbParameter[] parameters = { new OleDbParameter("@p_cpmc", OleDbType.VarChar,255), new OleDbParameter("@p_zczh", OleDbType.VarChar,255), new OleDbParameter("@p_zzs", OleDbType.VarChar,255), new OleDbParameter("@p_ph", OleDbType.VarChar,255)}; parameters[0].Value = model.p_cpmc; parameters[1].Value = model.p_zczh; parameters[2].Value = model.p_zzs; parameters[3].Value = model.p_ph; DataSet _ds= DbHelperOleDb.Query(strQuerySQL.ToString(),parameters); if (_ds != null && _ds.Tables[0].Rows.Count > 0) { try { _ToltalRecordCount = Convert.ToInt32(_ds.Tables[0].Rows[0]["p_sl1"]); _RecordID = Convert.ToInt32(_ds.Tables[0].Rows[0]["ID"]); _RecordIsExt = true; } catch (Exception ex) { } } #endregion if (!_RecordIsExt) { #region 新增记录 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PSI_Inventory("); strSql.Append("p_date,p_cpmc,p_ggxh,p_clmc,p_ph,p_dw,p_sl1,p_mjph,p_zzs,p_zczh,p_gys,p_sl2,p_jsr,DataType,RemarkInfo)"); strSql.Append(" values ("); strSql.Append("@p_date,@p_cpmc,@p_ggxh,@p_clmc,@p_ph,@p_dw,@p_sl1,@p_mjph,@p_zzs,@p_zczh,@p_gys,@p_sl2,@p_jsr,@DataType,@RemarkInfo)"); OleDbParameter[] parameterstwo = { new OleDbParameter("@p_date", OleDbType.Date), new OleDbParameter("@p_cpmc", OleDbType.VarChar,255), new OleDbParameter("@p_ggxh", OleDbType.VarChar,255), new OleDbParameter("@p_clmc", OleDbType.VarChar,255), new OleDbParameter("@p_ph", OleDbType.VarChar,255), new OleDbParameter("@p_dw", OleDbType.VarChar,255), new OleDbParameter("@p_sl1", OleDbType.Integer,4), new OleDbParameter("@p_mjph", OleDbType.VarChar,255), new OleDbParameter("@p_zzs", OleDbType.VarChar,255), new OleDbParameter("@p_zczh", OleDbType.VarChar,255), new OleDbParameter("@p_gys", OleDbType.VarChar,255), new OleDbParameter("@p_sl2", OleDbType.VarChar,255), new OleDbParameter("@p_jsr", OleDbType.VarChar,255), new OleDbParameter("@DataType", OleDbType.Integer,4), new OleDbParameter("@RemarkInfo", OleDbType.VarChar,255)}; parameterstwo[0].Value = model.p_date; parameterstwo[1].Value = model.p_cpmc; parameterstwo[2].Value = model.p_ggxh; parameterstwo[3].Value = model.p_clmc; parameterstwo[4].Value = model.p_ph; parameterstwo[5].Value = model.p_dw; parameterstwo[6].Value = model.p_sl1; parameterstwo[7].Value = model.p_mjph; parameterstwo[8].Value = model.p_zzs; parameterstwo[9].Value = model.p_zczh; parameterstwo[10].Value = model.p_gys; parameterstwo[11].Value = model.p_sl2; parameterstwo[12].Value = model.p_jsr; parameterstwo[13].Value = model.DataType; parameterstwo[14].Value = model.RemarkInfo; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameterstwo); if (rows > 0) { _bolSucced = true; } else { _bolSucced = false; } #endregion } else { int SurplusNumber = _ToltalRecordCount + model.p_sl1.Value;//统计总数量 #region 更新产品库存数量 StringBuilder strSql = new StringBuilder(); strSql.Append("update PSI_Inventory set "); strSql.Append("p_sl1=@p_sl1,"); strSql.Append("p_date=@p_date"); strSql.Append(" where ID=@ID"); OleDbParameter[] upparameters = { new OleDbParameter("@p_sl1", OleDbType.Integer,4), new OleDbParameter("@p_date", OleDbType.Date), new OleDbParameter("@ID", OleDbType.Integer,4)}; upparameters[0].Value = SurplusNumber; upparameters[1].Value =DateTime.Now; upparameters[2].Value = _RecordID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), upparameters); if (rows > 0) { return true; } else { return false; } #endregion } return _bolSucced; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.Manufacturer model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.ChuKuInfo model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.BuLiangShiJianInfo model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update PSI_BuLiangShiJian set "); strSql.Append("b_ylqxmc=@b_ylqxmc,"); strSql.Append("b_ggxh=@b_ggxh,"); strSql.Append("b_sccj=@b_sccj,"); strSql.Append("b_cpdm=@b_cpdm,"); strSql.Append("b_sl=@b_sl,"); strSql.Append("b_sydw=@b_sydw,"); strSql.Append("b_scrq=@b_scrq,"); strSql.Append("b_zlsgqk=@b_zlsgqk,"); strSql.Append("b_bgr=@b_bgr,"); strSql.Append("b_bgsj=@b_bgsj,"); strSql.Append("b_sydwyj=@b_sydwyj,"); strSql.Append("b_fzr=@b_fzr,"); strSql.Append("b_resj=@b_resj,"); strSql.Append("b_qyzgfzryj=@b_qyzgfzryj,"); strSql.Append("b_fzrqz=@b_fzrqz,"); strSql.Append("b_fzrqzsj=@b_fzrqzsj,"); strSql.Append("b_zgclqk=@b_zgclqk,"); strSql.Append("b_zgjbr=@b_zgjbr,"); strSql.Append("b_zgjbsj=@b_zgjbsj,"); strSql.Append("DataType=@DataType"); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@b_ylqxmc", OleDbType.VarChar,255), new OleDbParameter("@b_ggxh", OleDbType.VarChar,255), new OleDbParameter("@b_sccj", OleDbType.VarChar,255), new OleDbParameter("@b_cpdm", OleDbType.VarChar,255), new OleDbParameter("@b_sl", OleDbType.Integer,4), new OleDbParameter("@b_sydw", OleDbType.VarChar,255), new OleDbParameter("@b_scrq", OleDbType.VarChar,255), new OleDbParameter("@b_zlsgqk", OleDbType.VarChar,255), new OleDbParameter("@b_bgr", OleDbType.VarChar,255), new OleDbParameter("@b_bgsj", OleDbType.Date), new OleDbParameter("@b_sydwyj", OleDbType.VarChar,255), new OleDbParameter("@b_fzr", OleDbType.VarChar,255), new OleDbParameter("@b_resj", OleDbType.Date), new OleDbParameter("@b_qyzgfzryj", OleDbType.VarChar,255), new OleDbParameter("@b_fzrqz", OleDbType.VarChar,255), new OleDbParameter("@b_fzrqzsj", OleDbType.Date), new OleDbParameter("@b_zgclqk", OleDbType.VarChar,255), new OleDbParameter("@b_zgjbr", OleDbType.VarChar,255), new OleDbParameter("@b_zgjbsj", OleDbType.Date), new OleDbParameter("@DataType", OleDbType.Integer,4), new OleDbParameter("@ID", OleDbType.Integer,4)}; parameters[0].Value = model.b_ylqxmc; parameters[1].Value = model.b_ggxh; parameters[2].Value = model.b_sccj; parameters[3].Value = model.b_cpdm; parameters[4].Value = model.b_sl; parameters[5].Value = model.b_sydw; parameters[6].Value = model.b_scrq; parameters[7].Value = model.b_zlsgqk; parameters[8].Value = model.b_bgr; parameters[9].Value = model.b_bgsj; parameters[10].Value = model.b_sydwyj; parameters[11].Value = model.b_fzr; parameters[12].Value = model.b_resj; parameters[13].Value = model.b_qyzgfzryj; parameters[14].Value = model.b_fzrqz; parameters[15].Value = model.b_fzrqzsj; parameters[16].Value = model.b_zgclqk; parameters[17].Value = model.b_zgjbr; parameters[18].Value = model.b_zgjbsj; parameters[19].Value = model.DataType; parameters[20].Value = model.ID; int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.PermissionInfo model) { return dal.Update(model); }
public DataQueryFrm(UIModels.EntryType _Type,KPS.Model.DeviceInfo _device) { ThisType = _Type; //ThisDevice = _device; InitializeComponent(); }
/// <summary> /// 销售(当添加产品的销售记录时,则通过此方法更新已有产品的销售记录) /// </summary> /// <param name="model"></param> /// <returns></returns> public InventoryUpState Sell(KPS.Model.XiaoShouInfo model) { InventoryUpState _state = InventoryUpState.SysTemError; bool _RecordIsExt = false; int _ToltalRecordCount = 0; int _RecordID = -1; int _GouJinRecordID = -1; #region 更新销售记录的GJID(购进记录编号) string StrSQLA = "select ID FROM PSI_GouJin where p_cpmc=@p_cpmc and p_zczh=@p_zczh and p_zzs=@p_zzs and p_ph=@p_ph"; OleDbParameter[] parametersA = { new OleDbParameter("@p_cpmc", OleDbType.VarChar,255), new OleDbParameter("@p_zczh", OleDbType.VarChar,255), new OleDbParameter("@p_zzs", OleDbType.VarChar,255), new OleDbParameter("@p_ph", OleDbType.VarChar,255)}; parametersA[0].Value = model.p_cpmc; parametersA[1].Value = model.p_zczh; parametersA[2].Value = model.p_zzs; parametersA[3].Value = model.p_ph; DataSet _ds = DbHelperOleDb.Query(StrSQLA.ToString(), parametersA); if (_ds != null && _ds.Tables[0].Rows.Count > 0) { try { _GouJinRecordID = Convert.ToInt32(_ds.Tables[0].Rows[0]["ID"]); model.GJID = _GouJinRecordID; } catch (Exception ex) {} } #endregion if (_GouJinRecordID > -1) { #region 判断产品记录是否已存在 StringBuilder strQuerySQL = new StringBuilder(); strQuerySQL.Append("select ID,p_date,p_cpmc,p_ggxh,p_clmc,p_ph,p_dw,p_sl1,p_mjph,p_zzs,p_zczh,p_gys,p_sl2,p_jsr,DataType,RemarkInfo "); strQuerySQL.Append(" FROM PSI_Inventory where p_cpmc=@p_cpmc and p_zczh=@p_zczh and p_zzs=@p_zzs and p_ph=@p_ph"); OleDbParameter[] parameters = { new OleDbParameter("@p_cpmc", OleDbType.VarChar,255), new OleDbParameter("@p_zczh", OleDbType.VarChar,255), new OleDbParameter("@p_zzs", OleDbType.VarChar,255), new OleDbParameter("@p_ph", OleDbType.VarChar,255)}; parameters[0].Value = model.p_cpmc; parameters[1].Value = model.p_zczh; parameters[2].Value = model.p_zzs; parameters[3].Value = model.p_ph; _ds = DbHelperOleDb.Query(strQuerySQL.ToString(), parameters); if (_ds != null && _ds.Tables[0].Rows.Count > 0) { try { _ToltalRecordCount = Convert.ToInt32(_ds.Tables[0].Rows[0]["p_sl1"]); _RecordID = Convert.ToInt32(_ds.Tables[0].Rows[0]["ID"]); _RecordIsExt = true; } catch (Exception ex) { _state = InventoryUpState.SysTemError; } } else { _RecordIsExt = false; } #endregion } if (_RecordIsExt) { #region 存在产品的购进记录时 if (model.p_sl1.Value > _ToltalRecordCount) { _state = InventoryUpState.ProductLacking; } else { int SurplusNumber = _ToltalRecordCount-model.p_sl1.Value;//统计总数量 #region 更新产品库存数量 StringBuilder strSql = new StringBuilder(); strSql.Append("update PSI_Inventory set "); strSql.Append("p_sl1=@p_sl1,"); strSql.Append("p_date=@p_date"); strSql.Append(" where ID=@ID"); OleDbParameter[] upparameters = { new OleDbParameter("@p_sl1", OleDbType.Integer,4), new OleDbParameter("@p_date", OleDbType.Date), new OleDbParameter("@ID", OleDbType.Integer,4)}; upparameters[0].Value = SurplusNumber; upparameters[1].Value = DateTime.Now; upparameters[2].Value = _RecordID; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), upparameters); if (rows > 0) { _state = InventoryUpState.Succed; } else { _state = InventoryUpState.ProductNoExt; } #endregion } #endregion } else { _state = InventoryUpState.ProductNoExt; } return _state; }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.PermissionInfo model) { return dal.Add(model); }
/// <summary> /// 销售 减少库存(当添加产品的销售记录时,则通过此方法更新已有产品的销售记录) /// </summary> /// <param name="xsmodel"></param> /// <returns></returns> public KPS.Model.InventoryUpState Sell(KPS.Model.XiaoShouInfo xsmodel) { return dal.Sell(xsmodel); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.ChuKuInfo model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(KPS.Model.Supplier model) { return dal.Update(model); }
/// <summary> /// 更改医疗器械类型 /// </summary> /// <param name="_Device"></param> public override void ChangeDeviceType(KPS.Model.DeviceInfo _Device) { thisdevice = _Device; button1_Click(null, null); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(KPS.Model.Supplier model) { return dal.Add(model); }