/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_WMS_Bms_Tra_ZKD_Total GetModel(string ZKDH, string PCH, string SX, string CPH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ZKDH,PCH,SX,CPH,CKNUM,RKNUM,CKOperator,CKTime,YKOperator,YKTime from WMS_Bms_Tra_ZKD_Total ");
strSql.Append(" where ZKDH=:ZKDH and PCH=:PCH and SX=:SX and CPH=:CPH ");
SqlParameter[] parameters =
{
new SqlParameter(":ZKDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":SX", SqlDbType.VarChar, 30),
new SqlParameter(":CPH", SqlDbType.VarChar, 30)
};
parameters[0].Value = ZKDH;
parameters[1].Value = PCH;
parameters[2].Value = SX;
parameters[3].Value = CPH;
Mod_WMS_Bms_Tra_ZKD_Total model = new Mod_WMS_Bms_Tra_ZKD_Total();
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 Mod_WMS_Bms_Tra_ZKD_Total DataRowToModel(DataRow row)
{
Mod_WMS_Bms_Tra_ZKD_Total model = new Mod_WMS_Bms_Tra_ZKD_Total();
if (row != null)
{
if (row["ZKDH"] != null)
{
model.ZKDH = row["ZKDH"].ToString();
}
if (row["PCH"] != null)
{
model.PCH = row["PCH"].ToString();
}
if (row["SX"] != null)
{
model.SX = row["SX"].ToString();
}
if (row["CPH"] != null)
{
model.CPH = row["CPH"].ToString();
}
if (row["CKNUM"] != null && row["CKNUM"].ToString() != "")
{
model.CKNUM = int.Parse(row["CKNUM"].ToString());
}
if (row["RKNUM"] != null && row["RKNUM"].ToString() != "")
{
model.RKNUM = int.Parse(row["RKNUM"].ToString());
}
if (row["CKOperator"] != null)
{
model.CKOperator = row["CKOperator"].ToString();
}
if (row["CKTime"] != null && row["CKTime"].ToString() != "")
{
model.CKTime = DateTime.Parse(row["CKTime"].ToString());
}
if (row["YKOperator"] != null)
{
model.YKOperator = row["YKOperator"].ToString();
}
if (row["YKTime"] != null && row["YKTime"].ToString() != "")
{
model.YKTime = DateTime.Parse(row["YKTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_WMS_Bms_Tra_ZKD_Total model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WMS_Bms_Tra_ZKD_Total set ");
strSql.Append("CKNUM=:CKNUM,");
strSql.Append("RKNUM=:RKNUM,");
strSql.Append("CKOperator=:CKOperator,");
strSql.Append("CKTime=:CKTime,");
strSql.Append("YKOperator=:YKOperator,");
strSql.Append("YKTime=:YKTime");
strSql.Append(" where ZKDH=:ZKDH and PCH=:PCH and SX=:SX and CPH=:CPH ");
SqlParameter[] parameters =
{
new SqlParameter(":CKNUM", SqlDbType.Int, 4),
new SqlParameter(":RKNUM", SqlDbType.Int, 4),
new SqlParameter(":CKOperator", SqlDbType.VarChar, 20),
new SqlParameter(":CKTime", SqlDbType.DateTime),
new SqlParameter(":YKOperator", SqlDbType.VarChar, 20),
new SqlParameter(":YKTime", SqlDbType.DateTime),
new SqlParameter(":ZKDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":SX", SqlDbType.VarChar, 30),
new SqlParameter(":CPH", SqlDbType.VarChar, 30)
};
parameters[0].Value = model.CKNUM;
parameters[1].Value = model.RKNUM;
parameters[2].Value = model.CKOperator;
parameters[3].Value = model.CKTime;
parameters[4].Value = model.YKOperator;
parameters[5].Value = model.YKTime;
parameters[6].Value = model.ZKDH;
parameters[7].Value = model.PCH;
parameters[8].Value = model.SX;
parameters[9].Value = model.CPH;
int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_WMS_Bms_Tra_ZKD_Total model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WMS_Bms_Tra_ZKD_Total(");
strSql.Append("ZKDH,PCH,SX,CPH,CKNUM,RKNUM,CKOperator,CKTime,YKOperator,YKTime)");
strSql.Append(" values (");
strSql.Append(":ZKDH,:PCH,:SX,:CPH,:CKNUM,:RKNUM,:CKOperator,:CKTime,:YKOperator,:YKTime)");
SqlParameter[] parameters =
{
new SqlParameter(":ZKDH", SqlDbType.VarChar, 50),
new SqlParameter(":PCH", SqlDbType.VarChar, 20),
new SqlParameter(":SX", SqlDbType.VarChar, 30),
new SqlParameter(":CPH", SqlDbType.VarChar, 30),
new SqlParameter(":CKNUM", SqlDbType.Int, 4),
new SqlParameter(":RKNUM", SqlDbType.Int, 4),
new SqlParameter(":CKOperator", SqlDbType.VarChar, 20),
new SqlParameter(":CKTime", SqlDbType.DateTime),
new SqlParameter(":YKOperator", SqlDbType.VarChar, 20),
new SqlParameter(":YKTime", SqlDbType.DateTime)
};
parameters[0].Value = model.ZKDH;
parameters[1].Value = model.PCH;
parameters[2].Value = model.SX;
parameters[3].Value = model.CPH;
parameters[4].Value = model.CKNUM;
parameters[5].Value = model.RKNUM;
parameters[6].Value = model.CKOperator;
parameters[7].Value = model.CKTime;
parameters[8].Value = model.YKOperator;
parameters[9].Value = model.YKTime;
int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
