/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_BackReasonEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@UCode", Entity.UCode),
new SqlParameter("@UCname", Entity.UCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@Sort", Entity.Sort),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@Reason", Entity.Reason),
new SqlParameter("@Ascription", Entity.Ascription),
new SqlParameter("@Remark", Entity.Remark),
};
sqlParameters[8].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_BackReason_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.PKCode = sqlParameters[8].Value.ToString();
}
return(intReturn);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_BackReasonEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@UCode", Entity.UCode),
new SqlParameter("@UCname", Entity.UCname),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@Sort", Entity.Sort),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@Reason", Entity.Reason),
new SqlParameter("@Ascription", Entity.Ascription),
new SqlParameter("@Remark", Entity.Remark),
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_BackReason_Update", CommandType.StoredProcedure, sqlParameters));
}
