/// <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);
}
