/// <summary> /// 增加一条数据 /// </summary> public int Add(ref TB_OrderEntity Entity, string DishListJson) { intReturn = 0; SqlParameter[] sqlParameters = { new SqlParameter("@PKCode", SqlDbType.VarChar, 32) { Value = Entity.PKCode }, new SqlParameter("@Id", Entity.Id), new SqlParameter("@StoCode", Entity.StoCode), new SqlParameter("@CCode", Entity.CCode), new SqlParameter("@CCname", Entity.CCname), new SqlParameter("@OrderMoney", Entity.OrderMoney), new SqlParameter("@Remar", Entity.Remar), new SqlParameter("@DisNum", Entity.DisNum), new SqlParameter("@OrderType", Entity.OrderType), }; sqlParameters[0].Direction = ParameterDirection.Output; intReturn = DBHelper.ExecuteNonQuery("dbo.p_TB_Order_Add", CommandType.StoredProcedure, sqlParameters); if (intReturn == 1) { Entity.PKCode = sqlParameters[0].Value.ToString(); int disRel = -1; try { //解析json拼接SQL DataTable dtDish = JsonHelper.ToDataTable(DishListJson); string dishSql = " declare @odiscode varchar(32);"; dishSql += " declare @podiscode varchar(32);"; dishSql += " set @podiscode='';"; string checkmoneySql = " declare @allmoney decimal(18,2);"; checkmoneySql += " set @allmoney=0; "; if (dtDish != null && dtDish.Rows.Count > 0) { foreach (DataRow dr in dtDish.Rows) { string disPrice = dr["price"].ToString(); string totalmoney = "0"; totalmoney = disPrice + "*" + dr["disnum"].ToString() + "+" + dr["cookmoney"].ToString(); string tempSql = " exec[dbo].[p_GetOrderCode] @odiscode output;"; tempSql += " insert into TB_OrderDish([StoCode],[OrderCode],[DisCode],[DisName],[Price],[DisNum],[PKCode],[CookName],[CookMoney],[TotalMoney]) "; tempSql += " values('" + Entity.StoCode + "','" + Entity.PKCode + "','" + dr["discode"] + "','" + dr["disname"] + "'," + dr["price"] + "," + dr["disnum"] + ",@odiscode,'" + dr["cookname"] + "'," + dr["cookmoney"] + "," + totalmoney + ");"; dishSql += tempSql; } disRel = DBHelper.ExecuteNonQuery(dishSql, CommandType.Text, new SqlParameter[] { }); } } catch (Exception ex) {} if (disRel != 0) { //删除订单信息,返回失败 string meg = ""; Delete(Entity.PKCode, Entity.StoCode, ref meg); intReturn = -1; } } return(intReturn); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(string GUID, string UID, TB_OrderEntity UEntity) { //更新数据 int result = dal.Update(UEntity); //检测执行结果 CheckResult(result, ""); }
/// <summary> /// 单行数据转实体对象 /// </summary> /// <param name="dr"></param> /// <returns></returns> private TB_OrderEntity SetEntityInfo(DataRow dr) { TB_OrderEntity Entity = new TB_OrderEntity(); Entity.Id = StringHelper.StringToLong(dr["Id"].ToString()); Entity.StoCode = dr["StoCode"].ToString(); Entity.CCode = dr["CCode"].ToString(); Entity.CCname = dr["CCname"].ToString(); Entity.TStatus = dr["TStatus"].ToString(); Entity.PKCode = dr["PKCode"].ToString(); Entity.OrderMoney = StringHelper.StringToDecimal(dr["OrderMoney"].ToString()); Entity.Remar = dr["Remar"].ToString(); Entity.CheckTime = StringHelper.StringToDateTime(dr["CheckTime"].ToString()); return(Entity); }
private void Update(Dictionary <string, object> dicPar) { //要检测的参数信息 List <string> pra = new List <string>() { "GUID", "USER_ID", "Id", "BusCode", "StoCode", "CCode", "CCname", "TStatus", "PKCode", "OpenCodeList", "OrderMoney", "DisNum", "DisTypeNum", "Remar", "CheckTime", "BillCode" }; //检测方法需要的参数 if (!CheckActionParameters(dicPar, pra)) { return; } //获取参数信息 string GUID = dicPar["GUID"].ToString(); string USER_ID = dicPar["USER_ID"].ToString(); string Id = dicPar["Id"].ToString(); string BusCode = dicPar["BusCode"].ToString(); string StoCode = dicPar["StoCode"].ToString(); string CCode = dicPar["CCode"].ToString(); string CCname = dicPar["CCname"].ToString(); string TStatus = dicPar["TStatus"].ToString(); string PKCode = dicPar["PKCode"].ToString(); string OrderMoney = dicPar["OrderMoney"].ToString(); string Remar = dicPar["Remar"].ToString(); string CheckTime = dicPar["CheckTime"].ToString(); string BillCode = dicPar["BillCode"].ToString(); //调用逻辑 TB_OrderEntity UEntity = bll.GetEntitySigInfo("where pkcode='" + PKCode + "'"); UEntity.Remar = Remar; UEntity.TStatus = TStatus; bll.Update(GUID, USER_ID, UEntity); ReturnResultJson(bll.oResult.Code, bll.oResult.Msg); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(TB_OrderEntity Entity) { SqlParameter[] sqlParameters = { new SqlParameter("@Id", Entity.Id), new SqlParameter("@StoCode", Entity.StoCode), new SqlParameter("@CCode", Entity.CCode), new SqlParameter("@CCname", Entity.CCname), new SqlParameter("@TStatus", Entity.TStatus), new SqlParameter("@PKCode", Entity.PKCode), new SqlParameter("@OrderMoney", Entity.OrderMoney), new SqlParameter("@Remar", Entity.Remar), new SqlParameter("@CheckTime", Entity.CheckTime), new SqlParameter("@OrderType", Entity.OrderType), new SqlParameter("@PayMoney", Entity.PayMoney), new SqlParameter("@CouponMoney", Entity.CouponMoney), new SqlParameter("@WxBillCode", Entity.WxBillCode), new SqlParameter("@CouponCode", Entity.CouponCode), new SqlParameter("@FTime", Entity.FTime), }; return(DBHelper.ExecuteNonQuery("dbo.p_TB_Order_Update", CommandType.StoredProcedure, sqlParameters)); }
/// <summary> /// 检验表单数据 /// </summary> /// <returns></returns> public bool CheckPageInfo(string type, string Id, string StoCode, string CCode, string CCname, string TStatus, string PKCode, string OrderMoney, string Remar, int OrderType) { bool rel = false; try { Entity = new TB_OrderEntity(); Entity.Id = StringHelper.StringToLong(Id); Entity.StoCode = StoCode; Entity.CCode = CCode; Entity.CCname = CCname; Entity.TStatus = TStatus; Entity.PKCode = PKCode; Entity.OrderMoney = StringHelper.StringToDecimal(OrderMoney); Entity.Remar = Remar; Entity.OrderType = OrderType; rel = true; } catch (System.Exception) { } return(rel); }