/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.xlkzc GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RQ,DWMC,JE,DJHM,ZTIDH,BMBM,XM,ZH,BZ,JZ,LSH,ZD,YHJE,NIAN,YF,HSLX,SKSM,YSDH,ID,IsInsert,d_confirm,f_confirm,emp_check,emp_dc,emp_fc,red_rush from xlkzc ");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int64, 20)
};
parameters[0].Value = ID;
FMS_Model.xlkzc model = new FMS_Model.xlkzc();
DataSet ds = DbHelperMySQL.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(FMS_Model.xlkzc model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into xlkzc(");
strSql.Append("RQ,DWMC,JE,DJHM,ZTIDH,BMBM,XM,ZH,BZ,JZ,LSH,ZD,YHJE,NIAN,YF,HSLX,SKSM,YSDH,ID,IsInsert,d_confirm,f_confirm,emp_check,emp_dc,emp_fc,red_rush)");
strSql.Append(" values (");
strSql.Append("@RQ,@DWMC,@JE,@DJHM,@ZTIDH,@BMBM,@XM,@ZH,@BZ,@JZ,@LSH,@ZD,@YHJE,@NIAN,@YF,@HSLX,@SKSM,@YSDH,@ID,@IsInsert,@d_confirm,@f_confirm,@emp_check,@emp_dc,@emp_fc,@red_rush)");
MySqlParameter[] parameters =
{
new MySqlParameter("@RQ", MySqlDbType.DateTime),
new MySqlParameter("@DWMC", MySqlDbType.VarChar, 60),
new MySqlParameter("@JE", MySqlDbType.Decimal, 15),
new MySqlParameter("@DJHM", MySqlDbType.Int64, 20),
new MySqlParameter("@ZTIDH", MySqlDbType.Int64, 20),
new MySqlParameter("@BMBM", MySqlDbType.VarChar, 50),
new MySqlParameter("@XM", MySqlDbType.VarChar, 50),
new MySqlParameter("@ZH", MySqlDbType.VarChar, 50),
new MySqlParameter("@BZ", MySqlDbType.VarChar, 50),
new MySqlParameter("@JZ", MySqlDbType.VarChar, 50),
new MySqlParameter("@LSH", MySqlDbType.Int64, 20),
new MySqlParameter("@ZD", MySqlDbType.VarChar, 50),
new MySqlParameter("@YHJE", MySqlDbType.Decimal, 12),
new MySqlParameter("@NIAN", MySqlDbType.Int64, 20),
new MySqlParameter("@YF", MySqlDbType.Int64, 20),
new MySqlParameter("@HSLX", MySqlDbType.VarChar, 50),
new MySqlParameter("@SKSM", MySqlDbType.VarChar, 60),
new MySqlParameter("@YSDH", MySqlDbType.VarChar, 50),
new MySqlParameter("@ID", MySqlDbType.Int64, 20),
new MySqlParameter("@IsInsert", MySqlDbType.Int32, 11),
new MySqlParameter("@d_confirm", MySqlDbType.Int16, 2),
new MySqlParameter("@f_confirm", MySqlDbType.Int16, 2),
new MySqlParameter("@emp_check", MySqlDbType.VarChar, 60),
new MySqlParameter("@emp_dc", MySqlDbType.VarChar, 60),
new MySqlParameter("@emp_fc", MySqlDbType.VarChar, 60),
new MySqlParameter("@red_rush", MySqlDbType.Int16, 2)
};
parameters[0].Value = model.RQ;
parameters[1].Value = model.DWMC;
parameters[2].Value = model.JE;
parameters[3].Value = model.DJHM;
parameters[4].Value = model.ZTIDH;
parameters[5].Value = model.BMBM;
parameters[6].Value = model.XM;
parameters[7].Value = model.ZH;
parameters[8].Value = model.BZ;
parameters[9].Value = model.JZ;
parameters[10].Value = model.LSH;
parameters[11].Value = model.ZD;
parameters[12].Value = model.YHJE;
parameters[13].Value = model.NIAN;
parameters[14].Value = model.YF;
parameters[15].Value = model.HSLX;
parameters[16].Value = model.SKSM;
parameters[17].Value = model.YSDH;
parameters[18].Value = model.ID;
parameters[19].Value = model.IsInsert;
parameters[20].Value = model.d_confirm;
parameters[21].Value = model.f_confirm;
parameters[22].Value = model.emp_check;
parameters[23].Value = model.emp_dc;
parameters[24].Value = model.emp_fc;
parameters[25].Value = model.red_rush;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FMS_Model.xlkzc DataRowToModel(DataRow row)
{
FMS_Model.xlkzc model = new FMS_Model.xlkzc();
if (row != null)
{
if (row["RQ"] != null && row["RQ"].ToString() != "")
{
model.RQ = DateTime.Parse(row["RQ"].ToString());
}
if (row["DWMC"] != null)
{
model.DWMC = row["DWMC"].ToString();
}
if (row["JE"] != null && row["JE"].ToString() != "")
{
model.JE = decimal.Parse(row["JE"].ToString());
}
if (row["DJHM"] != null && row["DJHM"].ToString() != "")
{
model.DJHM = long.Parse(row["DJHM"].ToString());
}
if (row["ZTIDH"] != null && row["ZTIDH"].ToString() != "")
{
model.ZTIDH = long.Parse(row["ZTIDH"].ToString());
}
if (row["BMBM"] != null)
{
model.BMBM = row["BMBM"].ToString();
}
if (row["XM"] != null)
{
model.XM = row["XM"].ToString();
}
if (row["ZH"] != null)
{
model.ZH = row["ZH"].ToString();
}
if (row["BZ"] != null)
{
model.BZ = row["BZ"].ToString();
}
if (row["JZ"] != null)
{
model.JZ = row["JZ"].ToString();
}
if (row["LSH"] != null && row["LSH"].ToString() != "")
{
model.LSH = long.Parse(row["LSH"].ToString());
}
if (row["ZD"] != null)
{
model.ZD = row["ZD"].ToString();
}
if (row["YHJE"] != null && row["YHJE"].ToString() != "")
{
model.YHJE = decimal.Parse(row["YHJE"].ToString());
}
if (row["NIAN"] != null && row["NIAN"].ToString() != "")
{
model.NIAN = long.Parse(row["NIAN"].ToString());
}
if (row["YF"] != null && row["YF"].ToString() != "")
{
model.YF = long.Parse(row["YF"].ToString());
}
if (row["HSLX"] != null)
{
model.HSLX = row["HSLX"].ToString();
}
if (row["SKSM"] != null)
{
model.SKSM = row["SKSM"].ToString();
}
if (row["YSDH"] != null)
{
model.YSDH = row["YSDH"].ToString();
}
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = long.Parse(row["ID"].ToString());
}
if (row["IsInsert"] != null && row["IsInsert"].ToString() != "")
{
model.IsInsert = int.Parse(row["IsInsert"].ToString());
}
if (row["d_confirm"] != null && row["d_confirm"].ToString() != "")
{
model.d_confirm = int.Parse(row["d_confirm"].ToString());
}
if (row["f_confirm"] != null && row["f_confirm"].ToString() != "")
{
model.f_confirm = int.Parse(row["f_confirm"].ToString());
}
if (row["emp_check"] != null)
{
model.emp_check = row["emp_check"].ToString();
}
if (row["emp_dc"] != null)
{
model.emp_dc = row["emp_dc"].ToString();
}
if (row["emp_fc"] != null)
{
model.emp_fc = row["emp_fc"].ToString();
}
if (row["red_rush"] != null && row["red_rush"].ToString() != "")
{
model.red_rush = int.Parse(row["red_rush"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FMS_Model.xlkzc model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update xlkzc set ");
strSql.Append("RQ=@RQ,");
strSql.Append("DWMC=@DWMC,");
strSql.Append("JE=@JE,");
strSql.Append("DJHM=@DJHM,");
strSql.Append("ZTIDH=@ZTIDH,");
strSql.Append("BMBM=@BMBM,");
strSql.Append("XM=@XM,");
strSql.Append("ZH=@ZH,");
strSql.Append("BZ=@BZ,");
strSql.Append("JZ=@JZ,");
strSql.Append("LSH=@LSH,");
strSql.Append("ZD=@ZD,");
strSql.Append("YHJE=@YHJE,");
strSql.Append("NIAN=@NIAN,");
strSql.Append("YF=@YF,");
strSql.Append("HSLX=@HSLX,");
strSql.Append("SKSM=@SKSM,");
strSql.Append("YSDH=@YSDH,");
strSql.Append("IsInsert=@IsInsert,");
strSql.Append("d_confirm=@d_confirm,");
strSql.Append("f_confirm=@f_confirm,");
strSql.Append("emp_check=@emp_check,");
strSql.Append("emp_dc=@emp_dc,");
strSql.Append("emp_fc=@emp_fc,");
strSql.Append("red_rush=@red_rush");
strSql.Append(" where ID=@ID ");
MySqlParameter[] parameters =
{
new MySqlParameter("@RQ", MySqlDbType.DateTime),
new MySqlParameter("@DWMC", MySqlDbType.VarChar, 60),
new MySqlParameter("@JE", MySqlDbType.Decimal, 15),
new MySqlParameter("@DJHM", MySqlDbType.Int64, 20),
new MySqlParameter("@ZTIDH", MySqlDbType.Int64, 20),
new MySqlParameter("@BMBM", MySqlDbType.VarChar, 50),
new MySqlParameter("@XM", MySqlDbType.VarChar, 50),
new MySqlParameter("@ZH", MySqlDbType.VarChar, 50),
new MySqlParameter("@BZ", MySqlDbType.VarChar, 50),
new MySqlParameter("@JZ", MySqlDbType.VarChar, 50),
new MySqlParameter("@LSH", MySqlDbType.Int64, 20),
new MySqlParameter("@ZD", MySqlDbType.VarChar, 50),
new MySqlParameter("@YHJE", MySqlDbType.Decimal, 12),
new MySqlParameter("@NIAN", MySqlDbType.Int64, 20),
new MySqlParameter("@YF", MySqlDbType.Int64, 20),
new MySqlParameter("@HSLX", MySqlDbType.VarChar, 50),
new MySqlParameter("@SKSM", MySqlDbType.VarChar, 60),
new MySqlParameter("@YSDH", MySqlDbType.VarChar, 50),
new MySqlParameter("@IsInsert", MySqlDbType.Int32, 11),
new MySqlParameter("@d_confirm", MySqlDbType.Int16, 2),
new MySqlParameter("@f_confirm", MySqlDbType.Int16, 2),
new MySqlParameter("@emp_check", MySqlDbType.VarChar, 60),
new MySqlParameter("@emp_dc", MySqlDbType.VarChar, 60),
new MySqlParameter("@emp_fc", MySqlDbType.VarChar, 60),
new MySqlParameter("@red_rush", MySqlDbType.Int16, 2),
new MySqlParameter("@ID", MySqlDbType.Int64, 20)
};
parameters[0].Value = model.RQ;
parameters[1].Value = model.DWMC;
parameters[2].Value = model.JE;
parameters[3].Value = model.DJHM;
parameters[4].Value = model.ZTIDH;
parameters[5].Value = model.BMBM;
parameters[6].Value = model.XM;
parameters[7].Value = model.ZH;
parameters[8].Value = model.BZ;
parameters[9].Value = model.JZ;
parameters[10].Value = model.LSH;
parameters[11].Value = model.ZD;
parameters[12].Value = model.YHJE;
parameters[13].Value = model.NIAN;
parameters[14].Value = model.YF;
parameters[15].Value = model.HSLX;
parameters[16].Value = model.SKSM;
parameters[17].Value = model.YSDH;
parameters[18].Value = model.IsInsert;
parameters[19].Value = model.d_confirm;
parameters[20].Value = model.f_confirm;
parameters[21].Value = model.emp_check;
parameters[22].Value = model.emp_dc;
parameters[23].Value = model.emp_fc;
parameters[24].Value = model.red_rush;
parameters[25].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
