/// <summary>
/// 得到一个对象实体
/// </summary>
public ZH_ST_ZDCZB GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CPH,CPYS,ZZ,ZS,CS,XZ,CXL,CPTX,JCSJ,ZX,CD,CZY,ZDBZ,SFCX,SFXZ,FJBZ,XHZL,JCZT,SJDJ,PLATE,FX from zh_st_zdczb ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ZH_ST_ZDCZB model = new ZH_ST_ZDCZB();
DataSet ds = DbHelperSQL.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 Update(ZH_ST_ZDCZB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update zh_st_zdczb set ");
strSql.Append("CPH=@CPH,");
strSql.Append("CPYS=@CPYS,");
strSql.Append("ZZ=@ZZ,");
strSql.Append("ZS=@ZS,");
strSql.Append("CS=@CS,");
strSql.Append("XZ=@XZ,");
strSql.Append("CXL=@CXL,");
strSql.Append("CPTX=@CPTX,");
strSql.Append("JCSJ=@JCSJ,");
strSql.Append("ZX=@ZX,");
strSql.Append("CD=@CD,");
strSql.Append("CZY=@CZY,");
strSql.Append("ZDBZ=@ZDBZ,");
strSql.Append("SFCX=@SFCX,");
strSql.Append("SFXZ=@SFXZ,");
strSql.Append("FJBZ=@FJBZ,");
strSql.Append("XHZL=@XHZL,");
strSql.Append("JCZT=@JCZT,");
strSql.Append("SJDJ=@SJDJ,");
strSql.Append("PLATE=@PLATE,");
strSql.Append("FX=@FX");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CPH", SqlDbType.NVarChar, 50),
new SqlParameter("@CPYS", SqlDbType.NVarChar, 50),
new SqlParameter("@ZZ", SqlDbType.BigInt, 8),
new SqlParameter("@ZS", SqlDbType.Int, 4),
new SqlParameter("@CS", SqlDbType.Decimal, 5),
new SqlParameter("@XZ", SqlDbType.BigInt, 8),
new SqlParameter("@CXL", SqlDbType.Int, 4),
new SqlParameter("@CPTX", SqlDbType.NVarChar, 500),
new SqlParameter("@JCSJ", SqlDbType.DateTime),
new SqlParameter("@ZX", SqlDbType.Int, 4),
new SqlParameter("@CD", SqlDbType.Int, 4),
new SqlParameter("@CZY", SqlDbType.NVarChar, 50),
new SqlParameter("@ZDBZ", SqlDbType.NVarChar, 60),
new SqlParameter("@SFCX", SqlDbType.Int, 4),
new SqlParameter("@SFXZ", SqlDbType.Int, 4),
new SqlParameter("@FJBZ", SqlDbType.Int, 4),
new SqlParameter("@XHZL", SqlDbType.BigInt, 8),
new SqlParameter("@JCZT", SqlDbType.Int, 4),
new SqlParameter("@SJDJ", SqlDbType.Int, 4),
new SqlParameter("@PLATE", SqlDbType.NVarChar, 100),
new SqlParameter("@FX", SqlDbType.Char, 10),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.CPH;
parameters[1].Value = model.CPYS;
parameters[2].Value = model.ZZ;
parameters[3].Value = model.ZS;
parameters[4].Value = model.CS;
parameters[5].Value = model.XZ;
parameters[6].Value = model.CXL;
parameters[7].Value = model.CPTX;
parameters[8].Value = model.JCSJ;
parameters[9].Value = model.ZX;
parameters[10].Value = model.CD;
parameters[11].Value = model.CZY;
parameters[12].Value = model.ZDBZ;
parameters[13].Value = model.SFCX;
parameters[14].Value = model.SFXZ;
parameters[15].Value = model.FJBZ;
parameters[16].Value = model.XHZL;
parameters[17].Value = model.JCZT;
parameters[18].Value = model.SJDJ;
parameters[19].Value = model.PLATE;
parameters[20].Value = model.FX;
parameters[21].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZH_ST_ZDCZB DataRowToModel(DataRow row)
{
ZH_ST_ZDCZB model = new ZH_ST_ZDCZB();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["CPH"] != null)
{
model.CPH = row["CPH"].ToString();
}
if (row["CPYS"] != null)
{
model.CPYS = row["CPYS"].ToString();
}
if (row["ZZ"] != null && row["ZZ"].ToString() != "")
{
model.ZZ = long.Parse(row["ZZ"].ToString());
}
if (row["ZS"] != null && row["ZS"].ToString() != "")
{
model.ZS = int.Parse(row["ZS"].ToString());
}
if (row["CS"] != null && row["CS"].ToString() != "")
{
model.CS = decimal.Parse(row["CS"].ToString());
}
if (row["XZ"] != null && row["XZ"].ToString() != "")
{
model.XZ = long.Parse(row["XZ"].ToString());
}
if (row["CXL"] != null && row["CXL"].ToString() != "")
{
model.CXL = int.Parse(row["CXL"].ToString());
}
if (row["CPTX"] != null)
{
model.CPTX = row["CPTX"].ToString();
}
if (row["JCSJ"] != null && row["JCSJ"].ToString() != "")
{
model.JCSJ = DateTime.Parse(row["JCSJ"].ToString());
}
if (row["ZX"] != null && row["ZX"].ToString() != "")
{
model.ZX = int.Parse(row["ZX"].ToString());
}
if (row["CD"] != null && row["CD"].ToString() != "")
{
model.CD = int.Parse(row["CD"].ToString());
}
if (row["CZY"] != null)
{
model.CZY = row["CZY"].ToString();
}
if (row["ZDBZ"] != null)
{
model.ZDBZ = row["ZDBZ"].ToString();
}
if (row["SFCX"] != null && row["SFCX"].ToString() != "")
{
model.SFCX = int.Parse(row["SFCX"].ToString());
}
if (row["SFXZ"] != null && row["SFXZ"].ToString() != "")
{
model.SFXZ = int.Parse(row["SFXZ"].ToString());
}
if (row["FJBZ"] != null && row["FJBZ"].ToString() != "")
{
model.FJBZ = int.Parse(row["FJBZ"].ToString());
}
if (row["XHZL"] != null && row["XHZL"].ToString() != "")
{
model.XHZL = long.Parse(row["XHZL"].ToString());
}
if (row["JCZT"] != null && row["JCZT"].ToString() != "")
{
model.JCZT = int.Parse(row["JCZT"].ToString());
}
if (row["SJDJ"] != null && row["SJDJ"].ToString() != "")
{
model.SJDJ = int.Parse(row["SJDJ"].ToString());
}
if (row["PLATE"] != null)
{
model.PLATE = row["PLATE"].ToString();
}
if (row["FX"] != null)
{
model.FX = row["FX"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ZH_ST_ZDCZB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into zh_st_zdczb(");
strSql.Append("CPH,CPYS,ZZ,ZS,CS,XZ,CXL,CPTX,JCSJ,ZX,CD,CZY,ZDBZ,SFCX,SFXZ,FJBZ,XHZL,JCZT,SJDJ,PLATE,FX,CWTX,CMTX,Video,SFSC)");
strSql.Append(" values (");
strSql.Append("@CPH,@CPYS,@ZZ,@ZS,@CS,@XZ,@CXL,@CPTX,@JCSJ,@ZX,@CD,@CZY,@ZDBZ,@SFCX,@SFXZ,@FJBZ,@XHZL,@JCZT,@SJDJ,@PLATE,@FX,@CWTX,@CMTX,@Video,@SFSC)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CPH", SqlDbType.NVarChar, 50),
new SqlParameter("@CPYS", SqlDbType.NVarChar, 50),
new SqlParameter("@ZZ", SqlDbType.BigInt, 8),
new SqlParameter("@ZS", SqlDbType.Int, 4),
new SqlParameter("@CS", SqlDbType.Decimal, 5),
new SqlParameter("@XZ", SqlDbType.BigInt, 8),
new SqlParameter("@CXL", SqlDbType.Int, 4),
new SqlParameter("@CPTX", SqlDbType.NVarChar, 500),
new SqlParameter("@JCSJ", SqlDbType.DateTime),
new SqlParameter("@ZX", SqlDbType.Int, 4),
new SqlParameter("@CD", SqlDbType.Int, 4),
new SqlParameter("@CZY", SqlDbType.NVarChar, 50),
new SqlParameter("@ZDBZ", SqlDbType.NVarChar, 60),
new SqlParameter("@SFCX", SqlDbType.Int, 4),
new SqlParameter("@SFXZ", SqlDbType.Int, 4),
new SqlParameter("@FJBZ", SqlDbType.Int, 4),
new SqlParameter("@XHZL", SqlDbType.BigInt, 8),
new SqlParameter("@JCZT", SqlDbType.Int, 4),
new SqlParameter("@SJDJ", SqlDbType.Int, 4),
new SqlParameter("@PLATE", SqlDbType.NVarChar, 100),
new SqlParameter("@FX", SqlDbType.Char, 10),
new SqlParameter("@CWTX", SqlDbType.NVarChar, 500),
new SqlParameter("@CMTX", SqlDbType.NVarChar, 500),
new SqlParameter("@Video", SqlDbType.NVarChar, 500),
new SqlParameter("@SFSC", SqlDbType.Int, 4),
};
parameters[0].Value = model.CPH;
parameters[1].Value = model.CPYS;
parameters[2].Value = model.ZZ;
parameters[3].Value = model.ZS;
parameters[4].Value = model.CS;
parameters[5].Value = model.XZ;
parameters[6].Value = model.CXL;
parameters[7].Value = model.CPTX;
parameters[8].Value = model.JCSJ;
parameters[9].Value = model.ZX;
parameters[10].Value = model.CD;
parameters[11].Value = model.CZY;
parameters[12].Value = model.ZDBZ;
parameters[13].Value = model.SFCX;
parameters[14].Value = model.SFXZ;
parameters[15].Value = model.FJBZ;
parameters[16].Value = model.XHZL;
parameters[17].Value = model.JCZT;
parameters[18].Value = model.SJDJ;
parameters[19].Value = model.PLATE;
parameters[20].Value = model.FX;
parameters[21].Value = model.CWTX;
parameters[22].Value = model.CMTX;
parameters[23].Value = model.Video;
parameters[24].Value = model.SFSC;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}