/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Rec_WGD GetModel(string WGDH, string PCH, string PH, string GG, string SCX, string WLH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WGDH,PCH,PH,GG,BB,SCX,NCWLBMID,WLH,WLMC,FZDW,ZXBZ,PCSX,PCLX,ZLDJ,ZPGP,PCXH,WCBZ,PGBZ,ZJBZ,ZPDJBZ,Rev_Time,End_Time,PEnd_Time,FEW_scx,SendEnd,IsTran,YWLH,YWLMC,YPH,YGG,YZXBZ,ZDR,ZDDATE,UPDATERY,UPDATEDATE,FLAG,Filed1,PCInfo,Filed2,SendBack,vfree0,vfree1,vfree2,vfree3,vfree4,yvfree0,yvfree1,yvfree2,yvfree3,yvfree4,GPZL from WMS_Bms_Rec_WGD ");
strSql.Append(" where WGDH=:WGDH and PCH=:PCH and PH=:PH and GG=:GG and SCX=:SCX and WLH=:WLH ");
SqlParameter[] parameters =
{
new SqlParameter(":WGDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":PH", SqlDbType.VarChar, 30),
new SqlParameter(":GG", SqlDbType.VarChar, 30),
new SqlParameter(":SCX", SqlDbType.VarChar, 50),
new SqlParameter(":WLH", SqlDbType.VarChar, 20)
};
parameters[0].Value = WGDH;
parameters[1].Value = PCH;
parameters[2].Value = PH;
parameters[3].Value = GG;
parameters[4].Value = SCX;
parameters[5].Value = WLH;
Mod_WMS_Bms_Rec_WGD model = new Mod_WMS_Bms_Rec_WGD();
DataSet ds = DbHelper_SQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_WMS_Bms_Rec_WGD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WMS_Bms_Rec_WGD(");
strSql.Append("WGDH,PCH,PH,GG,BB,SCX,NCWLBMID,WLH,WLMC,FZDW,ZXBZ,PCSX,PCLX,ZLDJ,ZPGP,PCXH,WCBZ,PGBZ,ZJBZ,ZPDJBZ,Rev_Time,End_Time,PEnd_Time,FEW_scx,SendEnd,IsTran,YWLH,YWLMC,YPH,YGG,YZXBZ,ZDR,ZDDATE,UPDATERY,UPDATEDATE,FLAG,Filed1,PCInfo,Filed2,SendBack,vfree0,vfree1,vfree2,vfree3,vfree4,yvfree0,yvfree1,yvfree2,yvfree3,yvfree4,GPZL)");
strSql.Append(" values (");
strSql.Append(":WGDH,:PCH,:PH,:GG,:BB,:SCX,:NCWLBMID,:WLH,:WLMC,:FZDW,:ZXBZ,:PCSX,:PCLX,:ZLDJ,:ZPGP,:PCXH,:WCBZ,:PGBZ,:ZJBZ,:ZPDJBZ,:Rev_Time,:End_Time,:PEnd_Time,:FEW_scx,:SendEnd,:IsTran,:YWLH,:YWLMC,:YPH,:YGG,:YZXBZ,:ZDR,:ZDDATE,:UPDATERY,:UPDATEDATE,:FLAG,:Filed1,:PCInfo,:Filed2,:SendBack,:vfree0,:vfree1,:vfree2,:vfree3,:vfree4,:yvfree0,:yvfree1,:yvfree2,:yvfree3,:yvfree4,:GPZL)");
SqlParameter[] parameters =
{
new SqlParameter(":WGDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":PH", SqlDbType.VarChar, 30),
new SqlParameter(":GG", SqlDbType.VarChar, 30),
new SqlParameter(":BB", SqlDbType.VarChar, 10),
new SqlParameter(":SCX", SqlDbType.VarChar, 50),
new SqlParameter(":NCWLBMID", SqlDbType.VarChar, 20),
new SqlParameter(":WLH", SqlDbType.VarChar, 20),
new SqlParameter(":WLMC", SqlDbType.VarChar, 100),
new SqlParameter(":FZDW", SqlDbType.VarChar, 10),
new SqlParameter(":ZXBZ", SqlDbType.VarChar, 40),
new SqlParameter(":PCSX", SqlDbType.VarChar, 30),
new SqlParameter(":PCLX", SqlDbType.Int, 4),
new SqlParameter(":ZLDJ", SqlDbType.VarChar, 10),
new SqlParameter(":ZPGP", SqlDbType.VarChar, 30),
new SqlParameter(":PCXH", SqlDbType.Int, 4),
new SqlParameter(":WCBZ", SqlDbType.Int, 4),
new SqlParameter(":PGBZ", SqlDbType.Int, 4),
new SqlParameter(":ZJBZ", SqlDbType.Int, 4),
new SqlParameter(":ZPDJBZ", SqlDbType.Int, 4),
new SqlParameter(":Rev_Time", SqlDbType.DateTime),
new SqlParameter(":End_Time", SqlDbType.DateTime),
new SqlParameter(":PEnd_Time", SqlDbType.DateTime),
new SqlParameter(":FEW_scx", SqlDbType.VarChar, 10),
new SqlParameter(":SendEnd", SqlDbType.Int, 4),
new SqlParameter(":IsTran", SqlDbType.Int, 4),
new SqlParameter(":YWLH", SqlDbType.VarChar, 50),
new SqlParameter(":YWLMC", SqlDbType.VarChar, 50),
new SqlParameter(":YPH", SqlDbType.VarChar, 50),
new SqlParameter(":YGG", SqlDbType.VarChar, 50),
new SqlParameter(":YZXBZ", SqlDbType.VarChar, 50),
new SqlParameter(":ZDR", SqlDbType.VarChar, 20),
new SqlParameter(":ZDDATE", SqlDbType.DateTime),
new SqlParameter(":UPDATERY", SqlDbType.VarChar, 20),
new SqlParameter(":UPDATEDATE", SqlDbType.DateTime),
new SqlParameter(":FLAG", SqlDbType.VarChar, 10),
new SqlParameter(":Filed1", SqlDbType.VarChar, 50),
new SqlParameter(":PCInfo", SqlDbType.VarChar, 150),
new SqlParameter(":Filed2", SqlDbType.VarChar, 50),
new SqlParameter(":SendBack", SqlDbType.Bit, 1),
new SqlParameter(":vfree0", SqlDbType.VarChar, 50),
new SqlParameter(":vfree1", SqlDbType.VarChar, 50),
new SqlParameter(":vfree2", SqlDbType.VarChar, 50),
new SqlParameter(":vfree3", SqlDbType.VarChar, 50),
new SqlParameter(":vfree4", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree0", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree1", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree2", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree3", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree4", SqlDbType.VarChar, 50),
new SqlParameter(":GPZL", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.WGDH;
parameters[1].Value = model.PCH;
parameters[2].Value = model.PH;
parameters[3].Value = model.GG;
parameters[4].Value = model.BB;
parameters[5].Value = model.SCX;
parameters[6].Value = model.NCWLBMID;
parameters[7].Value = model.WLH;
parameters[8].Value = model.WLMC;
parameters[9].Value = model.FZDW;
parameters[10].Value = model.ZXBZ;
parameters[11].Value = model.PCSX;
parameters[12].Value = model.PCLX;
parameters[13].Value = model.ZLDJ;
parameters[14].Value = model.ZPGP;
parameters[15].Value = model.PCXH;
parameters[16].Value = model.WCBZ;
parameters[17].Value = model.PGBZ;
parameters[18].Value = model.ZJBZ;
parameters[19].Value = model.ZPDJBZ;
parameters[20].Value = model.Rev_Time;
parameters[21].Value = model.End_Time;
parameters[22].Value = model.PEnd_Time;
parameters[23].Value = model.FEW_scx;
parameters[24].Value = model.SendEnd;
parameters[25].Value = model.IsTran;
parameters[26].Value = model.YWLH;
parameters[27].Value = model.YWLMC;
parameters[28].Value = model.YPH;
parameters[29].Value = model.YGG;
parameters[30].Value = model.YZXBZ;
parameters[31].Value = model.ZDR;
parameters[32].Value = model.ZDDATE;
parameters[33].Value = model.UPDATERY;
parameters[34].Value = model.UPDATEDATE;
parameters[35].Value = model.FLAG;
parameters[36].Value = model.Filed1;
parameters[37].Value = model.PCInfo;
parameters[38].Value = model.Filed2;
parameters[39].Value = model.SendBack;
parameters[40].Value = model.vfree0;
parameters[41].Value = model.vfree1;
parameters[42].Value = model.vfree2;
parameters[43].Value = model.vfree3;
parameters[44].Value = model.vfree4;
parameters[45].Value = model.yvfree0;
parameters[46].Value = model.yvfree1;
parameters[47].Value = model.yvfree2;
parameters[48].Value = model.yvfree3;
parameters[49].Value = model.yvfree4;
parameters[50].Value = model.GPZL;
int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Rec_WGD DataRowToModel(DataRow row)
{
Mod_WMS_Bms_Rec_WGD model = new Mod_WMS_Bms_Rec_WGD();
if (row != null)
{
if (row["WGDH"] != null)
{
model.WGDH = row["WGDH"].ToString();
}
if (row["PCH"] != null)
{
model.PCH = row["PCH"].ToString();
}
if (row["PH"] != null)
{
model.PH = row["PH"].ToString();
}
if (row["GG"] != null)
{
model.GG = row["GG"].ToString();
}
if (row["BB"] != null)
{
model.BB = row["BB"].ToString();
}
if (row["SCX"] != null)
{
model.SCX = row["SCX"].ToString();
}
if (row["NCWLBMID"] != null)
{
model.NCWLBMID = row["NCWLBMID"].ToString();
}
if (row["WLH"] != null)
{
model.WLH = row["WLH"].ToString();
}
if (row["WLMC"] != null)
{
model.WLMC = row["WLMC"].ToString();
}
if (row["FZDW"] != null)
{
model.FZDW = row["FZDW"].ToString();
}
if (row["ZXBZ"] != null)
{
model.ZXBZ = row["ZXBZ"].ToString();
}
if (row["PCSX"] != null)
{
model.PCSX = row["PCSX"].ToString();
}
if (row["PCLX"] != null && row["PCLX"].ToString() != "")
{
model.PCLX = int.Parse(row["PCLX"].ToString());
}
if (row["ZLDJ"] != null)
{
model.ZLDJ = row["ZLDJ"].ToString();
}
if (row["ZPGP"] != null)
{
model.ZPGP = row["ZPGP"].ToString();
}
if (row["PCXH"] != null && row["PCXH"].ToString() != "")
{
model.PCXH = int.Parse(row["PCXH"].ToString());
}
if (row["WCBZ"] != null && row["WCBZ"].ToString() != "")
{
model.WCBZ = int.Parse(row["WCBZ"].ToString());
}
if (row["PGBZ"] != null && row["PGBZ"].ToString() != "")
{
model.PGBZ = int.Parse(row["PGBZ"].ToString());
}
if (row["ZJBZ"] != null && row["ZJBZ"].ToString() != "")
{
model.ZJBZ = int.Parse(row["ZJBZ"].ToString());
}
if (row["ZPDJBZ"] != null && row["ZPDJBZ"].ToString() != "")
{
model.ZPDJBZ = int.Parse(row["ZPDJBZ"].ToString());
}
if (row["Rev_Time"] != null && row["Rev_Time"].ToString() != "")
{
model.Rev_Time = DateTime.Parse(row["Rev_Time"].ToString());
}
if (row["End_Time"] != null && row["End_Time"].ToString() != "")
{
model.End_Time = DateTime.Parse(row["End_Time"].ToString());
}
if (row["PEnd_Time"] != null && row["PEnd_Time"].ToString() != "")
{
model.PEnd_Time = DateTime.Parse(row["PEnd_Time"].ToString());
}
if (row["FEW_scx"] != null)
{
model.FEW_scx = row["FEW_scx"].ToString();
}
if (row["SendEnd"] != null && row["SendEnd"].ToString() != "")
{
model.SendEnd = int.Parse(row["SendEnd"].ToString());
}
if (row["IsTran"] != null && row["IsTran"].ToString() != "")
{
model.IsTran = int.Parse(row["IsTran"].ToString());
}
if (row["YWLH"] != null)
{
model.YWLH = row["YWLH"].ToString();
}
if (row["YWLMC"] != null)
{
model.YWLMC = row["YWLMC"].ToString();
}
if (row["YPH"] != null)
{
model.YPH = row["YPH"].ToString();
}
if (row["YGG"] != null)
{
model.YGG = row["YGG"].ToString();
}
if (row["YZXBZ"] != null)
{
model.YZXBZ = row["YZXBZ"].ToString();
}
if (row["ZDR"] != null)
{
model.ZDR = row["ZDR"].ToString();
}
if (row["ZDDATE"] != null && row["ZDDATE"].ToString() != "")
{
model.ZDDATE = DateTime.Parse(row["ZDDATE"].ToString());
}
if (row["UPDATERY"] != null)
{
model.UPDATERY = row["UPDATERY"].ToString();
}
if (row["UPDATEDATE"] != null && row["UPDATEDATE"].ToString() != "")
{
model.UPDATEDATE = DateTime.Parse(row["UPDATEDATE"].ToString());
}
if (row["FLAG"] != null)
{
model.FLAG = row["FLAG"].ToString();
}
if (row["Filed1"] != null)
{
model.Filed1 = row["Filed1"].ToString();
}
if (row["PCInfo"] != null)
{
model.PCInfo = row["PCInfo"].ToString();
}
if (row["Filed2"] != null)
{
model.Filed2 = row["Filed2"].ToString();
}
if (row["SendBack"] != null && row["SendBack"].ToString() != "")
{
if ((row["SendBack"].ToString() == "1") || (row["SendBack"].ToString().ToLower() == "true"))
{
model.SendBack = true;
}
else
{
model.SendBack = false;
}
}
if (row["vfree0"] != null)
{
model.vfree0 = row["vfree0"].ToString();
}
if (row["vfree1"] != null)
{
model.vfree1 = row["vfree1"].ToString();
}
if (row["vfree2"] != null)
{
model.vfree2 = row["vfree2"].ToString();
}
if (row["vfree3"] != null)
{
model.vfree3 = row["vfree3"].ToString();
}
if (row["vfree4"] != null)
{
model.vfree4 = row["vfree4"].ToString();
}
if (row["yvfree0"] != null)
{
model.yvfree0 = row["yvfree0"].ToString();
}
if (row["yvfree1"] != null)
{
model.yvfree1 = row["yvfree1"].ToString();
}
if (row["yvfree2"] != null)
{
model.yvfree2 = row["yvfree2"].ToString();
}
if (row["yvfree3"] != null)
{
model.yvfree3 = row["yvfree3"].ToString();
}
if (row["yvfree4"] != null)
{
model.yvfree4 = row["yvfree4"].ToString();
}
if (row["GPZL"] != null && row["GPZL"].ToString() != "")
{
model.GPZL = decimal.Parse(row["GPZL"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_WMS_Bms_Rec_WGD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WMS_Bms_Rec_WGD set ");
strSql.Append("BB=:BB,");
strSql.Append("NCWLBMID=:NCWLBMID,");
strSql.Append("WLMC=:WLMC,");
strSql.Append("FZDW=:FZDW,");
strSql.Append("ZXBZ=:ZXBZ,");
strSql.Append("PCSX=:PCSX,");
strSql.Append("PCLX=:PCLX,");
strSql.Append("ZLDJ=:ZLDJ,");
strSql.Append("ZPGP=:ZPGP,");
strSql.Append("PCXH=:PCXH,");
strSql.Append("WCBZ=:WCBZ,");
strSql.Append("PGBZ=:PGBZ,");
strSql.Append("ZJBZ=:ZJBZ,");
strSql.Append("ZPDJBZ=:ZPDJBZ,");
strSql.Append("Rev_Time=:Rev_Time,");
strSql.Append("End_Time=:End_Time,");
strSql.Append("PEnd_Time=:PEnd_Time,");
strSql.Append("FEW_scx=:FEW_scx,");
strSql.Append("SendEnd=:SendEnd,");
strSql.Append("IsTran=:IsTran,");
strSql.Append("YWLH=:YWLH,");
strSql.Append("YWLMC=:YWLMC,");
strSql.Append("YPH=:YPH,");
strSql.Append("YGG=:YGG,");
strSql.Append("YZXBZ=:YZXBZ,");
strSql.Append("ZDR=:ZDR,");
strSql.Append("ZDDATE=:ZDDATE,");
strSql.Append("UPDATERY=:UPDATERY,");
strSql.Append("UPDATEDATE=:UPDATEDATE,");
strSql.Append("FLAG=:FLAG,");
strSql.Append("Filed1=:Filed1,");
strSql.Append("PCInfo=:PCInfo,");
strSql.Append("Filed2=:Filed2,");
strSql.Append("SendBack=:SendBack,");
strSql.Append("vfree0=:vfree0,");
strSql.Append("vfree1=:vfree1,");
strSql.Append("vfree2=:vfree2,");
strSql.Append("vfree3=:vfree3,");
strSql.Append("vfree4=:vfree4,");
strSql.Append("yvfree0=:yvfree0,");
strSql.Append("yvfree1=:yvfree1,");
strSql.Append("yvfree2=:yvfree2,");
strSql.Append("yvfree3=:yvfree3,");
strSql.Append("yvfree4=:yvfree4,");
strSql.Append("GPZL=:GPZL");
strSql.Append(" where WGDH=:WGDH and PCH=:PCH and PH=:PH and GG=:GG and SCX=:SCX and WLH=:WLH ");
SqlParameter[] parameters =
{
new SqlParameter(":BB", SqlDbType.VarChar, 10),
new SqlParameter(":NCWLBMID", SqlDbType.VarChar, 20),
new SqlParameter(":WLMC", SqlDbType.VarChar, 100),
new SqlParameter(":FZDW", SqlDbType.VarChar, 10),
new SqlParameter(":ZXBZ", SqlDbType.VarChar, 40),
new SqlParameter(":PCSX", SqlDbType.VarChar, 30),
new SqlParameter(":PCLX", SqlDbType.Int, 4),
new SqlParameter(":ZLDJ", SqlDbType.VarChar, 10),
new SqlParameter(":ZPGP", SqlDbType.VarChar, 30),
new SqlParameter(":PCXH", SqlDbType.Int, 4),
new SqlParameter(":WCBZ", SqlDbType.Int, 4),
new SqlParameter(":PGBZ", SqlDbType.Int, 4),
new SqlParameter(":ZJBZ", SqlDbType.Int, 4),
new SqlParameter(":ZPDJBZ", SqlDbType.Int, 4),
new SqlParameter(":Rev_Time", SqlDbType.DateTime),
new SqlParameter(":End_Time", SqlDbType.DateTime),
new SqlParameter(":PEnd_Time", SqlDbType.DateTime),
new SqlParameter(":FEW_scx", SqlDbType.VarChar, 10),
new SqlParameter(":SendEnd", SqlDbType.Int, 4),
new SqlParameter(":IsTran", SqlDbType.Int, 4),
new SqlParameter(":YWLH", SqlDbType.VarChar, 50),
new SqlParameter(":YWLMC", SqlDbType.VarChar, 50),
new SqlParameter(":YPH", SqlDbType.VarChar, 50),
new SqlParameter(":YGG", SqlDbType.VarChar, 50),
new SqlParameter(":YZXBZ", SqlDbType.VarChar, 50),
new SqlParameter(":ZDR", SqlDbType.VarChar, 20),
new SqlParameter(":ZDDATE", SqlDbType.DateTime),
new SqlParameter(":UPDATERY", SqlDbType.VarChar, 20),
new SqlParameter(":UPDATEDATE", SqlDbType.DateTime),
new SqlParameter(":FLAG", SqlDbType.VarChar, 10),
new SqlParameter(":Filed1", SqlDbType.VarChar, 50),
new SqlParameter(":PCInfo", SqlDbType.VarChar, 150),
new SqlParameter(":Filed2", SqlDbType.VarChar, 50),
new SqlParameter(":SendBack", SqlDbType.Bit, 1),
new SqlParameter(":vfree0", SqlDbType.VarChar, 50),
new SqlParameter(":vfree1", SqlDbType.VarChar, 50),
new SqlParameter(":vfree2", SqlDbType.VarChar, 50),
new SqlParameter(":vfree3", SqlDbType.VarChar, 50),
new SqlParameter(":vfree4", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree0", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree1", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree2", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree3", SqlDbType.VarChar, 50),
new SqlParameter(":yvfree4", SqlDbType.VarChar, 50),
new SqlParameter(":GPZL", SqlDbType.Decimal, 9),
new SqlParameter(":WGDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":PH", SqlDbType.VarChar, 30),
new SqlParameter(":GG", SqlDbType.VarChar, 30),
new SqlParameter(":SCX", SqlDbType.VarChar, 50),
new SqlParameter(":WLH", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.BB;
parameters[1].Value = model.NCWLBMID;
parameters[2].Value = model.WLMC;
parameters[3].Value = model.FZDW;
parameters[4].Value = model.ZXBZ;
parameters[5].Value = model.PCSX;
parameters[6].Value = model.PCLX;
parameters[7].Value = model.ZLDJ;
parameters[8].Value = model.ZPGP;
parameters[9].Value = model.PCXH;
parameters[10].Value = model.WCBZ;
parameters[11].Value = model.PGBZ;
parameters[12].Value = model.ZJBZ;
parameters[13].Value = model.ZPDJBZ;
parameters[14].Value = model.Rev_Time;
parameters[15].Value = model.End_Time;
parameters[16].Value = model.PEnd_Time;
parameters[17].Value = model.FEW_scx;
parameters[18].Value = model.SendEnd;
parameters[19].Value = model.IsTran;
parameters[20].Value = model.YWLH;
parameters[21].Value = model.YWLMC;
parameters[22].Value = model.YPH;
parameters[23].Value = model.YGG;
parameters[24].Value = model.YZXBZ;
parameters[25].Value = model.ZDR;
parameters[26].Value = model.ZDDATE;
parameters[27].Value = model.UPDATERY;
parameters[28].Value = model.UPDATEDATE;
parameters[29].Value = model.FLAG;
parameters[30].Value = model.Filed1;
parameters[31].Value = model.PCInfo;
parameters[32].Value = model.Filed2;
parameters[33].Value = model.SendBack;
parameters[34].Value = model.vfree0;
parameters[35].Value = model.vfree1;
parameters[36].Value = model.vfree2;
parameters[37].Value = model.vfree3;
parameters[38].Value = model.vfree4;
parameters[39].Value = model.yvfree0;
parameters[40].Value = model.yvfree1;
parameters[41].Value = model.yvfree2;
parameters[42].Value = model.yvfree3;
parameters[43].Value = model.yvfree4;
parameters[44].Value = model.GPZL;
parameters[45].Value = model.WGDH;
parameters[46].Value = model.PCH;
parameters[47].Value = model.PH;
parameters[48].Value = model.GG;
parameters[49].Value = model.SCX;
parameters[50].Value = model.WLH;
int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}