/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string Id, string BusCode, string StoCode, string CCode, string CCname, string AuthCode, string AuthName, string TStatus, string OrderCode, string OrderDisCode, string ReasonCode, string ReasonName, string Remar, string BackNum)
{
bool rel = false;
try
{
Entity = new TB_BackOrderEntity();
Entity.Id = StringHelper.StringToLong(Id);
Entity.BusCode = BusCode;
Entity.StoCode = StoCode;
Entity.CCode = CCode;
Entity.CCname = CCname;
Entity.AuthCode = AuthCode;
Entity.AuthName = AuthName;
Entity.TStatus = TStatus;
Entity.OrderCode = OrderCode;
Entity.OrderDisCode = OrderDisCode;
Entity.ReasonCode = ReasonCode;
Entity.ReasonName = ReasonName;
Entity.Remar = Remar;
Entity.BackNum = StringHelper.StringToDecimal(BackNum);
rel = true;
}
catch (Exception)
{
}
return(rel);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_BackOrderEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@AuthCode", Entity.AuthCode),
new SqlParameter("@AuthName", Entity.AuthName),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@OrderCode", Entity.OrderCode),
new SqlParameter("@OrderDisCode", Entity.OrderDisCode),
new SqlParameter("@ReasonCode", Entity.ReasonCode),
new SqlParameter("@ReasonName", Entity.ReasonName),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@BackNum", Entity.BackNum),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_BackOrder_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.Id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, TB_BackOrderEntity OldEntity)
{
//更新数据
int result = dal.Update(OldEntity);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TB_BackOrderEntity SetEntityInfo(DataRow dr)
{
TB_BackOrderEntity Entity = new TB_BackOrderEntity();
Entity.Id = StringHelper.StringToLong(dr["Id"].ToString());
Entity.BusCode = dr["BusCode"].ToString();
Entity.StoCode = dr["StoCode"].ToString();
Entity.CCode = dr["CCode"].ToString();
Entity.CCname = dr["CCname"].ToString();
Entity.AuthCode = dr["AuthCode"].ToString();
Entity.AuthName = dr["AuthName"].ToString();
Entity.TStatus = dr["TStatus"].ToString();
Entity.OrderCode = dr["OrderCode"].ToString();
Entity.OrderDisCode = dr["OrderDisCode"].ToString();
Entity.ReasonCode = dr["ReasonCode"].ToString();
Entity.ReasonName = dr["ReasonName"].ToString();
Entity.Remar = dr["Remar"].ToString();
Entity.BackNum = StringHelper.StringToDecimal(dr["BackNum"].ToString());
return(Entity);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_BackOrderEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@BusCode", Entity.BusCode),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@CCode", Entity.CCode),
new SqlParameter("@CCname", Entity.CCname),
new SqlParameter("@AuthCode", Entity.AuthCode),
new SqlParameter("@AuthName", Entity.AuthName),
new SqlParameter("@TStatus", Entity.TStatus),
new SqlParameter("@OrderCode", Entity.OrderCode),
new SqlParameter("@OrderDisCode", Entity.OrderDisCode),
new SqlParameter("@ReasonCode", Entity.ReasonCode),
new SqlParameter("@ReasonName", Entity.ReasonName),
new SqlParameter("@Remar", Entity.Remar),
new SqlParameter("@BackNum", Entity.BackNum),
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_BackOrder_Update", CommandType.StoredProcedure, sqlParameters));
}
