/// <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)); }