/// <summary>
/// 检验表单数据
/// </summary>
/// <returns></returns>
public bool CheckPageInfo(string type, string Id, string BusCode, string StoCode, string CCode, string CCname, string OrderCode, string FinCode, string DisTypeCode, string DisCode, string DisName, string MemPrice, string Price, string DisUite, string DisNum, string ReturnNum, string IsPackage, string PDisCode, string Remar, string PKCode, string DiscountPrice, string DiscountRemark, string DiscountType, string DisCase, string Favor, string ItemNum, string ItemPrice, string CookName, string CookMoney, string TotalMoney)
{
bool rel = false;
try
{
Entity = new TB_OrderDishEntity();
Entity.Id = StringHelper.StringToLong(Id);
Entity.StoCode = StoCode;
Entity.OrderCode = OrderCode;
Entity.DisCode = DisCode;
Entity.DisName = DisName;
Entity.Price = StringHelper.StringToDecimal(Price);
Entity.DisUite = DisUite;
Entity.DisNum = StringHelper.StringToDecimal(DisNum);
Entity.PKCode = PKCode;
Entity.TotalMoney = StringHelper.StringToDecimal(TotalMoney);
rel = true;
}
catch (System.Exception)
{
}
return(rel);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(string GUID, string UID, TB_OrderDishEntity UEntity)
{
//更新数据
int result = dal.Update(UEntity);
//检测执行结果
CheckResult(result, "");
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(TB_OrderDishEntity Entity)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@OrderCode", Entity.OrderCode),
new SqlParameter("@DisCode", Entity.DisCode),
new SqlParameter("@DisName", Entity.DisName),
new SqlParameter("@Price", Entity.Price),
new SqlParameter("@DisUite", Entity.DisUite),
new SqlParameter("@DisNum", Entity.DisNum),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@TotalMoney", Entity.TotalMoney),
};
return(DBHelper.ExecuteNonQuery("dbo.p_TB_OrderDish_Update", CommandType.StoredProcedure, sqlParameters));
}
/// <summary>
/// 单行数据转实体对象
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private TB_OrderDishEntity SetEntityInfo(DataRow dr)
{
TB_OrderDishEntity Entity = new TB_OrderDishEntity();
Entity.Id = StringHelper.StringToLong(dr["Id"].ToString());
Entity.StoCode = dr["StoCode"].ToString();
Entity.OrderCode = dr["OrderCode"].ToString();
Entity.DisCode = dr["DisCode"].ToString();
Entity.DisName = dr["DisName"].ToString();
Entity.Price = StringHelper.StringToDecimal(dr["Price"].ToString());
Entity.DisUite = dr["DisUite"].ToString();
Entity.DisNum = StringHelper.StringToDecimal(dr["DisNum"].ToString());
Entity.PKCode = dr["PKCode"].ToString();
Entity.TotalMoney = StringHelper.StringToDecimal(dr["TotalMoney"].ToString());
return(Entity);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ref TB_OrderDishEntity Entity)
{
intReturn = 0;
SqlParameter[] sqlParameters =
{
new SqlParameter("@Id", Entity.Id),
new SqlParameter("@StoCode", Entity.StoCode),
new SqlParameter("@OrderCode", Entity.OrderCode),
new SqlParameter("@DisCode", Entity.DisCode),
new SqlParameter("@DisName", Entity.DisName),
new SqlParameter("@Price", Entity.Price),
new SqlParameter("@DisUite", Entity.DisUite),
new SqlParameter("@DisNum", Entity.DisNum),
new SqlParameter("@PKCode", Entity.PKCode),
new SqlParameter("@TotalMoney", Entity.TotalMoney),
};
sqlParameters[0].Direction = ParameterDirection.Output;
intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_OrderDish_Add", CommandType.StoredProcedure, sqlParameters);
if (intReturn == 0)
{
Entity.Id = int.Parse(sqlParameters[0].Value.ToString());
}
return(intReturn);
}
