/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Hi.Model.BD_Ereceipt GetModel(DataRow r)
{
Hi.Model.BD_Ereceipt model = new Hi.Model.BD_Ereceipt();
model.ID = SqlHelper.GetInt(r["ID"]);
model.CompID = SqlHelper.GetInt(r["CompID"]);
model.ereceipt_rtbill = SqlHelper.GetString(r["ereceipt_rtbill"]);
model.ereceipt_kd = SqlHelper.GetString(r["ereceipt_kd"]);
model.ereceipt_nm = SqlHelper.GetString(r["ereceipt_nm"]);
model.ereceipt_std = SqlHelper.GetString(r["ereceipt_std"]);
model.ereceipt_grd = SqlHelper.GetString(r["ereceipt_grd"]);
model.ereceipt_unit = SqlHelper.GetString(r["ereceipt_unit"]);
model.ereceipt_num = SqlHelper.GetDecimal(r["ereceipt_num"]);
model.ereceipt_price = SqlHelper.GetDecimal(r["ereceipt_price"]);
model.ereceipt_value = SqlHelper.GetDecimal(r["ereceipt_value"]);
model.ereceipt_brd = SqlHelper.GetString(r["ereceipt_brd"]);
model.ereceipt_chkbill = SqlHelper.GetString(r["ereceipt_chkbill"]);
model.ereceipt_duedate = SqlHelper.GetDateTime(r["ereceipt_duedate"]);
model.ereceipt_gdsdic = SqlHelper.GetString(r["ereceipt_gdsdic"]);
model.ereceipt_hder = SqlHelper.GetString(r["ereceipt_hder"]);
model.ereceipt_gds = SqlHelper.GetString(r["ereceipt_gds"]);
model.ereceipt_whnm = SqlHelper.GetString(r["ereceipt_whnm"]);
model.ereceipt_whno = SqlHelper.GetString(r["ereceipt_whno"]);
model.ereceipt_batchno = SqlHelper.GetString(r["ereceipt_batchno"]);
model.ereceipt_sgndt = SqlHelper.GetDateTime(r["ereceipt_sgndt"]);
model.ereceipt_mfters = SqlHelper.GetString(r["ereceipt_mfters"]);
model.ts = SqlHelper.GetDateTime(r["ts"]);
model.dr = SqlHelper.GetInt(r["dr"]);
model.modifyuser = SqlHelper.GetInt(r["modifyuser"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.BD_Ereceipt model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [BD_Ereceipt](");
strSql.Append("[CompID],[ereceipt_rtbill],[ereceipt_kd],[ereceipt_nm],[ereceipt_std],[ereceipt_grd],[ereceipt_unit],[ereceipt_num],[ereceipt_price],[ereceipt_value],[ereceipt_brd],[ereceipt_chkbill],[ereceipt_duedate],[ereceipt_gdsdic],[ereceipt_hder],[ereceipt_gds],[ereceipt_whnm],[ereceipt_whno],[ereceipt_batchno],[ereceipt_sgndt],[ereceipt_mfters],[ts],[modifyuser])");
strSql.Append(" values (");
strSql.Append("@CompID,@ereceipt_rtbill,@ereceipt_kd,@ereceipt_nm,@ereceipt_std,@ereceipt_grd,@ereceipt_unit,@ereceipt_num,@ereceipt_price,@ereceipt_value,@ereceipt_brd,@ereceipt_chkbill,@ereceipt_duedate,@ereceipt_gdsdic,@ereceipt_hder,@ereceipt_gds,@ereceipt_whnm,@ereceipt_whno,@ereceipt_batchno,@ereceipt_sgndt,@ereceipt_mfters,@ts,@modifyuser)");
strSql.Append(";select @@Identity");
SqlParameter[] parameters =
{
new SqlParameter("@CompID", SqlDbType.Int),
new SqlParameter("@ereceipt_rtbill", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_kd", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_nm", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_std", SqlDbType.NVarChar, 50),
new SqlParameter("@ereceipt_grd", SqlDbType.NVarChar, 50),
new SqlParameter("@ereceipt_unit", SqlDbType.NVarChar, 50),
new SqlParameter("@ereceipt_num", SqlDbType.Decimal),
new SqlParameter("@ereceipt_price", SqlDbType.Decimal),
new SqlParameter("@ereceipt_value", SqlDbType.Decimal),
new SqlParameter("@ereceipt_brd", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_chkbill", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_duedate", SqlDbType.DateTime),
new SqlParameter("@ereceipt_gdsdic", SqlDbType.NVarChar, 800),
new SqlParameter("@ereceipt_hder", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_gds", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_whnm", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_whno", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_batchno", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_sgndt", SqlDbType.DateTime),
new SqlParameter("@ereceipt_mfters", SqlDbType.NVarChar, 200),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@modifyuser", SqlDbType.Int)
};
parameters[0].Value = model.CompID;
parameters[1].Value = model.ereceipt_rtbill;
parameters[2].Value = model.ereceipt_kd;
parameters[3].Value = model.ereceipt_nm;
parameters[4].Value = model.ereceipt_std;
if (model.ereceipt_grd != null)
{
parameters[5].Value = model.ereceipt_grd;
}
else
{
parameters[5].Value = DBNull.Value;
}
parameters[6].Value = model.ereceipt_unit;
parameters[7].Value = model.ereceipt_num;
parameters[8].Value = model.ereceipt_price;
parameters[9].Value = model.ereceipt_value;
if (model.ereceipt_brd != null)
{
parameters[10].Value = model.ereceipt_brd;
}
else
{
parameters[10].Value = DBNull.Value;
}
if (model.ereceipt_chkbill != null)
{
parameters[11].Value = model.ereceipt_chkbill;
}
else
{
parameters[11].Value = DBNull.Value;
}
parameters[12].Value = model.ereceipt_duedate;
if (model.ereceipt_gdsdic != null)
{
parameters[13].Value = model.ereceipt_gdsdic;
}
else
{
parameters[13].Value = DBNull.Value;
}
if (model.ereceipt_hder != null)
{
parameters[14].Value = model.ereceipt_hder;
}
else
{
parameters[14].Value = DBNull.Value;
}
if (model.ereceipt_gds != null)
{
parameters[15].Value = model.ereceipt_gds;
}
else
{
parameters[15].Value = DBNull.Value;
}
parameters[16].Value = model.ereceipt_whnm;
parameters[17].Value = model.ereceipt_whno;
parameters[18].Value = model.ereceipt_batchno;
if (model.ereceipt_sgndt != DateTime.MinValue)
{
parameters[19].Value = model.ereceipt_sgndt;
}
else
{
parameters[19].Value = DBNull.Value;
}
parameters[20].Value = model.ereceipt_mfters;
if (model.ts != DateTime.MinValue)
{
parameters[21].Value = model.ts;
}
else
{
parameters[21].Value = DBNull.Value;
}
parameters[22].Value = model.modifyuser;
return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters)));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.BD_Ereceipt model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [BD_Ereceipt] set ");
strSql.Append("[CompID]=@CompID,");
strSql.Append("[ereceipt_rtbill]=@ereceipt_rtbill,");
strSql.Append("[ereceipt_kd]=@ereceipt_kd,");
strSql.Append("[ereceipt_nm]=@ereceipt_nm,");
strSql.Append("[ereceipt_std]=@ereceipt_std,");
strSql.Append("[ereceipt_grd]=@ereceipt_grd,");
strSql.Append("[ereceipt_unit]=@ereceipt_unit,");
strSql.Append("[ereceipt_num]=@ereceipt_num,");
strSql.Append("[ereceipt_price]=@ereceipt_price,");
strSql.Append("[ereceipt_value]=@ereceipt_value,");
strSql.Append("[ereceipt_brd]=@ereceipt_brd,");
strSql.Append("[ereceipt_chkbill]=@ereceipt_chkbill,");
strSql.Append("[ereceipt_duedate]=@ereceipt_duedate,");
strSql.Append("[ereceipt_gdsdic]=@ereceipt_gdsdic,");
strSql.Append("[ereceipt_hder]=@ereceipt_hder,");
strSql.Append("[ereceipt_gds]=@ereceipt_gds,");
strSql.Append("[ereceipt_whnm]=@ereceipt_whnm,");
strSql.Append("[ereceipt_whno]=@ereceipt_whno,");
strSql.Append("[ereceipt_batchno]=@ereceipt_batchno,");
strSql.Append("[ereceipt_sgndt]=@ereceipt_sgndt,");
strSql.Append("[ereceipt_mfters]=@ereceipt_mfters,");
strSql.Append("[ts]=@ts,");
strSql.Append("[dr]=@dr,");
strSql.Append("[modifyuser]=@modifyuser");
strSql.Append(" where [ID]=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@CompID", SqlDbType.Int),
new SqlParameter("@ereceipt_rtbill", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_kd", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_nm", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_std", SqlDbType.NVarChar, 50),
new SqlParameter("@ereceipt_grd", SqlDbType.NVarChar, 50),
new SqlParameter("@ereceipt_unit", SqlDbType.NVarChar, 50),
new SqlParameter("@ereceipt_num", SqlDbType.Decimal),
new SqlParameter("@ereceipt_price", SqlDbType.Decimal),
new SqlParameter("@ereceipt_value", SqlDbType.Decimal),
new SqlParameter("@ereceipt_brd", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_chkbill", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_duedate", SqlDbType.DateTime),
new SqlParameter("@ereceipt_gdsdic", SqlDbType.NVarChar, 800),
new SqlParameter("@ereceipt_hder", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_gds", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_whnm", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_whno", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_batchno", SqlDbType.NVarChar, 200),
new SqlParameter("@ereceipt_sgndt", SqlDbType.DateTime),
new SqlParameter("@ereceipt_mfters", SqlDbType.NVarChar, 200),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@dr", SqlDbType.SmallInt),
new SqlParameter("@modifyuser", SqlDbType.Int)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CompID;
parameters[2].Value = model.ereceipt_rtbill;
parameters[3].Value = model.ereceipt_kd;
parameters[4].Value = model.ereceipt_nm;
parameters[5].Value = model.ereceipt_std;
if (model.ereceipt_grd != null)
{
parameters[6].Value = model.ereceipt_grd;
}
else
{
parameters[6].Value = DBNull.Value;
}
parameters[7].Value = model.ereceipt_unit;
parameters[8].Value = model.ereceipt_num;
parameters[9].Value = model.ereceipt_price;
parameters[10].Value = model.ereceipt_value;
if (model.ereceipt_brd != null)
{
parameters[11].Value = model.ereceipt_brd;
}
else
{
parameters[11].Value = DBNull.Value;
}
if (model.ereceipt_chkbill != null)
{
parameters[12].Value = model.ereceipt_chkbill;
}
else
{
parameters[12].Value = DBNull.Value;
}
parameters[13].Value = model.ereceipt_duedate;
if (model.ereceipt_gdsdic != null)
{
parameters[14].Value = model.ereceipt_gdsdic;
}
else
{
parameters[14].Value = DBNull.Value;
}
if (model.ereceipt_hder != null)
{
parameters[15].Value = model.ereceipt_hder;
}
else
{
parameters[15].Value = DBNull.Value;
}
if (model.ereceipt_gds != null)
{
parameters[16].Value = model.ereceipt_gds;
}
else
{
parameters[16].Value = DBNull.Value;
}
parameters[17].Value = model.ereceipt_whnm;
parameters[18].Value = model.ereceipt_whno;
parameters[19].Value = model.ereceipt_batchno;
if (model.ereceipt_sgndt != DateTime.MinValue)
{
parameters[20].Value = model.ereceipt_sgndt;
}
else
{
parameters[20].Value = DBNull.Value;
}
parameters[21].Value = model.ereceipt_mfters;
if (model.ts != DateTime.MinValue)
{
parameters[22].Value = model.ts;
}
else
{
parameters[22].Value = DBNull.Value;
}
parameters[23].Value = model.dr;
parameters[24].Value = model.modifyuser;
return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0);
}