/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref sumcouponNEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@sumid", Entity.sumid),
new SqlParameter("@sumcode", Entity.sumcode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@cname", Entity.cname),
new SqlParameter("@ctype", Entity.ctype),
new SqlParameter("@status", Entity.status),
new SqlParameter("@descr", Entity.descr),
new SqlParameter("@audcode", Entity.audcode),
new SqlParameter("@audcname", Entity.audcname),
new SqlParameter("@audremark", Entity.audremark),
new SqlParameter("@audstatus", Entity.audstatus),
new SqlParameter("@ccode", Entity.ccode),
new SqlParameter("@ccname", Entity.ccname)
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_sumcouponN_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.sumid = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string sumid, string sumcode, string buscode, string stocode, string cname, string ctype, string status, string descr, string audcode, string audcname, string audremark, string audstatus, string ccode, string ccname)
{
bool rel = false;
try
{
Entity = new sumcouponNEntity();
Entity.sumid = StringHelper.StringToLong(sumid);
Entity.sumcode = sumcode;
Entity.buscode = buscode;
Entity.stocode = stocode;
Entity.cname = cname;
Entity.ctype = ctype;
Entity.status = status;
Entity.descr = descr;
Entity.audcode = audcode;
Entity.audcname = audcname;
Entity.audremark = audremark;
Entity.audstatus = audstatus;
Entity.ccode = ccode;
Entity.ccname = ccname;
rel = true;
}
catch (System.Exception)
{
}
return(rel);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, sumcouponNEntity UEntity)
{
//更新数据
int result = dal.Update(UEntity);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(sumcouponNEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@sumid", Entity.sumid),
new SqlParameter("@sumcode", Entity.sumcode),
new SqlParameter("@buscode", Entity.buscode),
new SqlParameter("@stocode", Entity.stocode),
new SqlParameter("@cname", Entity.cname),
new SqlParameter("@ctype", Entity.ctype),
new SqlParameter("@status", Entity.status),
new SqlParameter("@descr", Entity.descr),
new SqlParameter("@audcode", Entity.audcode),
new SqlParameter("@audcname", Entity.audcname),
new SqlParameter("@audremark", Entity.audremark),
new SqlParameter("@audstatus", Entity.audstatus)
};
return(DBHelper.ExecuteNonQuery("dbo.p_sumcouponN_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private sumcouponNEntity SetEntityInfo(DataRow dr)
{
sumcouponNEntity Entity = new sumcouponNEntity();
Entity.sumid = StringHelper.StringToLong(dr["sumid"].ToString());
Entity.sumcode = dr["sumcode"].ToString();
Entity.buscode = dr["buscode"].ToString();
Entity.stocode = dr["stocode"].ToString();
Entity.cname = dr["cname"].ToString();
Entity.ctype = dr["ctype"].ToString();
Entity.status = dr["status"].ToString();
Entity.descr = dr["descr"].ToString();
Entity.audcode = dr["audcode"].ToString();
Entity.audcname = dr["audcname"].ToString();
Entity.audremark = dr["audremark"].ToString();
Entity.audstatus = dr["audstatus"].ToString();
Entity.ccode = dr["ccode"].ToString();
Entity.ccname = dr["ccname"].ToString();
return(Entity);
}
