/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateCopy(XHD.Model.scm_bzsldygx model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update scm_bzsldygx set ");
strSql.Append("ZTIDH=@ZTIDH,");
strSql.Append("GX=@GX,");
strSql.Append("XSJ1=@XSJ1,");
strSql.Append("XSJ2=@XSJ2,");
strSql.Append("XSJ3=@XSJ3,");
strSql.Append("XSJ4=@XSJ4,");
strSql.Append("XSJ5=@XSJ5,");
strSql.Append("BZDW=@BZDW,");
strSql.Append("HSGX=@HSGX,");
strSql.Append("TXM=@TXM,");
strSql.Append("TXM8=@TXM8");
strSql.Append(" where BM=@BM");
strSql.Append(" and BZSM=@BZSM");
MySqlParameter[] parameters =
{
new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18),
new MySqlParameter("@GX", MySqlDbType.Int32, 18),
new MySqlParameter("@XSJ1", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ2", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ3", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ4", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ5", MySqlDbType.Decimal, 18),
new MySqlParameter("@BZDW", MySqlDbType.VarChar, 10),
new MySqlParameter("@HSGX", MySqlDbType.VarChar, 10),
new MySqlParameter("@TXM", MySqlDbType.VarChar, 150),
new MySqlParameter("@TXM8", MySqlDbType.VarChar, 150),
new MySqlParameter("@BM", MySqlDbType.VarChar, 30),
new MySqlParameter("@BZSM", MySqlDbType.VarChar, 10)
};
parameters[0].Value = model.ZTIDH;
parameters[1].Value = model.GX;
parameters[2].Value = model.XSJ1;
parameters[3].Value = model.XSJ2;
parameters[4].Value = model.XSJ3;
parameters[5].Value = model.XSJ4;
parameters[6].Value = model.XSJ5;
parameters[7].Value = model.BZDW;
parameters[8].Value = model.HSGX;
parameters[9].Value = model.TXM;
parameters[10].Value = model.TXM8;
parameters[11].Value = model.BM;
parameters[12].Value = model.BZSM;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool AddCopy(XHD.Model.scm_bzsldygx model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into scm_bzsldygx(");
strSql.Append("BM,ZTIDH,GX,XSJ1,XSJ2,XSJ3,XSJ4,XSJ5,BZDW,BZSM,HSGX,TXM,TXM8)");
strSql.Append(" values (");
strSql.Append("@BM,@ZTIDH,@GX,@XSJ1,@XSJ2,@XSJ3,@XSJ4,@XSJ5,@BZDW,@BZSM,@HSGX,@TXM,@TXM8)");
MySqlParameter[] parameters =
{
new MySqlParameter("@BM", MySqlDbType.VarChar, 30),
new MySqlParameter("@ZTIDH", MySqlDbType.Decimal, 18),
new MySqlParameter("@GX", MySqlDbType.Int64, 18),
new MySqlParameter("@XSJ1", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ2", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ3", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ4", MySqlDbType.Decimal, 18),
new MySqlParameter("@XSJ5", MySqlDbType.Decimal, 18),
new MySqlParameter("@BZDW", MySqlDbType.VarChar, 10),
new MySqlParameter("@BZSM", MySqlDbType.VarChar, 10),
new MySqlParameter("@HSGX", MySqlDbType.VarChar, 10),
new MySqlParameter("@TXM", MySqlDbType.VarChar, 150),
new MySqlParameter("@TXM8", MySqlDbType.VarChar, 150)
};
parameters[0].Value = model.BM;
parameters[1].Value = model.ZTIDH;
parameters[2].Value = model.GX;
parameters[3].Value = model.XSJ1;
parameters[4].Value = model.XSJ2;
parameters[5].Value = model.XSJ3;
parameters[6].Value = model.XSJ4;
parameters[7].Value = model.XSJ5;
parameters[8].Value = model.BZDW;
parameters[9].Value = model.BZSM;
parameters[10].Value = model.HSGX;
parameters[11].Value = model.TXM;
parameters[12].Value = model.TXM8;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XHD.Model.scm_bzsldygx GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select BM,ZTIDH,ID,GX,XSJ1,XSJ2,XSJ3,XSJ4,XSJ5,BZDW,BZSM,HSGX,TXM,TXM8 from bzsldygx ");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int64)
};
parameters[0].Value = ID;
XHD.Model.scm_bzsldygx model = new XHD.Model.scm_bzsldygx();
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 XHD.Model.scm_bzsldygx DataRowToModel(DataRow row)
{
XHD.Model.scm_bzsldygx model = new XHD.Model.scm_bzsldygx();
if (row != null)
{
if (row["BM"] != null)
{
model.BM = row["BM"].ToString();
}
if (row["ZTIDH"] != null && row["ZTIDH"].ToString() != "")
{
model.ZTIDH = decimal.Parse(row["ZTIDH"].ToString());
}
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = long.Parse(row["ID"].ToString());
}
if (row["GX"] != null && row["GX"].ToString() != "")
{
model.GX = int.Parse(row["GX"].ToString());
}
if (row["XSJ1"] != null && row["XSJ1"].ToString() != "")
{
model.XSJ1 = decimal.Parse(row["XSJ1"].ToString());
}
if (row["XSJ2"] != null && row["XSJ2"].ToString() != "")
{
model.XSJ2 = decimal.Parse(row["XSJ2"].ToString());
}
if (row["XSJ3"] != null && row["XSJ3"].ToString() != "")
{
model.XSJ3 = decimal.Parse(row["XSJ3"].ToString());
}
if (row["XSJ4"] != null && row["XSJ4"].ToString() != "")
{
model.XSJ4 = decimal.Parse(row["XSJ4"].ToString());
}
if (row["XSJ5"] != null && row["XSJ5"].ToString() != "")
{
model.XSJ5 = decimal.Parse(row["XSJ5"].ToString());
}
if (row["BZDW"] != null)
{
model.BZDW = row["BZDW"].ToString();
}
if (row["BZSM"] != null)
{
model.BZSM = row["BZSM"].ToString();
}
if (row["HSGX"] != null)
{
model.HSGX = row["HSGX"].ToString();
}
if (row["TXM"] != null)
{
model.TXM = row["TXM"].ToString();
}
if (row["TXM8"] != null)
{
model.TXM8 = row["TXM8"].ToString();
}
}
return(model);
}
