private void SetPage(string discode) { TB_DishEntity disEntity = bll.GetEntitySigInfo("DisCode='" + discode + "'"); if (disEntity != null && !string.IsNullOrWhiteSpace(disEntity.DisCode)) { ddlStore.SelectedValue = disEntity.StoCode; txt_disname.Value = disEntity.DisName; txt_disothername.Value = disEntity.OtherName; txt_quickcode.Value = disEntity.QuickCode; txt_selunit.Value = disEntity.Unit; txt_price.Value = disEntity.Price.ToString("f2"); txt_costprice.Value = disEntity.CostPrice.ToString("f2"); txt_remark.Value = disEntity.Descript; TB_DishTypeEntity typeEntity = new bllTB_DishType().GetEntitySigInfo(" PKCode='" + disEntity.TypeCode + "' "); if (typeEntity != null && !string.IsNullOrWhiteSpace(typeEntity.PKCode)) { ddl_selDisheType.SelectedValue = typeEntity.PKKCode; ddl_selDisheType_SelectedIndexChanged(null, null); ddl_sel_dishetypetwo.SelectedValue = disEntity.TypeCode; } } DataTable dtImage = new bllPaging().GetPagingInfo("TR_DishImage", "id", "*", int.MaxValue, 1, "discode='" + discode + "'", "", "", out int recnums, out int pagenums); if (dtImage != null) { string imageHtml = ""; foreach (DataRow dr in dtImage.Rows) { imageHtml += "<img imgindex=\"\" width=\"200\" height=\"200\" style=\"float: left; margin - left:6px; \" src=\"/UploadFiles" + dr["ImgUrl"] + "\" onclick=\"deleteimage(this, '')\" />"; } HidImagesHtml.Value = imageHtml; } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(string GUID, string UID, TB_DishEntity UEntity) { //更新数据 int result = dal.Update(UEntity); CheckResult(result, ""); }
/// <summary> /// 修改状态 /// </summary> /// <param name="dicPar"></param> private void UpdateStatus(Dictionary <string, object> dicPar) { ///要检测的参数信息 List <string> pra = new List <string>() { "GUID", "USER_ID", "id", "status" }; //检测方法需要的参数 if (!CheckActionParameters(dicPar, pra)) { return; } //获取参数信息 string GUID = dicPar["GUID"].ToString(); string USER_ID = dicPar["USER_ID"].ToString(); string ids = dicPar["id"].ToString(); string status = dicPar["status"].ToString(); string DisCode = dicPar["id"].ToString().Trim(','); TB_DishEntity UEntity = bll.GetEntitySigInfo("Where DisCode='" + DisCode + "'"); UEntity.TStatus = status; bll.Update(GUID, USER_ID, UEntity); ReturnResultJson(bll.oResult.Code, bll.oResult.Msg); }
/// <summary> /// 检验表单数据 /// </summary> /// <returns></returns> public bool CheckPageInfo(string type, string Images, string StoCode, string TStatus, string DisName, string OtherName, string TypeCode, string QuickCode, string Unit, string Price, string CostPrice, string Descript) { bool rel = false; try { Entity = new TB_DishEntity(); Entity.Id = 0; Entity.ImageName = Images; Entity.StoCode = StoCode; Entity.TStatus = TStatus; Entity.DisName = DisName; Entity.OtherName = OtherName; Entity.TypeCode = TypeCode; Entity.QuickCode = QuickCode; Entity.Unit = Unit; Entity.Price = StringHelper.StringToDecimal(Price); Entity.CostPrice = StringHelper.StringToDecimal(CostPrice); Entity.Descript = Descript; rel = true; } catch (Exception) { } return(rel); }
//private void Add(Dictionary<string, object> dicPar) //{ // //要检测的参数信息 // List<string> pra = new List<string>() { "GUID", "USER_ID", "userid", "BusCode", "StoCode", "CCname", "UCname", "TStatus", "ChannelCodeList", "DisCode", "DisName", "OtherName", "TypeCode", "QuickCode", "CusDisCode", "Unit", "Price", "MenuCode", "MemPrice", "CostPrice", "RoyMoney", "ExtCode", "FinCode", "KitCode", "CookerCode", "MakeTime", "QRCode", "WarCode", "MatCode", "Descript", "IsCount", "DefCount", "CountPrice", "IsVarPrice", "IsWeight", "IsMethod", "IsStock", "IsPoint", "IsMemPrice", "IsCoupon", "IsKeep", "IsCombo", "CCode", "UCode", "ImageName", "dishesMethodsJson", "dishescombosJson", "dishescomboinfoJson" }; // //检测方法需要的参数 // if (!CheckActionParameters(dicPar, pra)) // { // return; // } // //获取参数信息 // string userid = dicPar["userid"].ToString(); // string GUID = dicPar["GUID"].ToString(); // string USER_ID = dicPar["USER_ID"].ToString(); // string BusCode = dicPar["BusCode"].ToString(); // string StoCode = dicPar["StoCode"].ToString(); // string TStatus = dicPar["TStatus"].ToString(); // string ChannelCodeList = ""; // string DisCode = dicPar["DisCode"].ToString(); // string DisName = dicPar["DisName"].ToString(); // string OtherName = dicPar["OtherName"].ToString(); // string TypeCode = dicPar["TypeCode"].ToString(); // string QuickCode = dicPar["QuickCode"].ToString(); // string Unit = dicPar["Unit"].ToString(); // string Price = dicPar["Price"].ToString(); // string CostPrice = dicPar["CostPrice"].ToString(); // string QRCode = dicPar["QRCode"].ToString(); // string Descript = dicPar["Descript"].ToString(); // if (string.IsNullOrEmpty(QuickCode)) // { // QuickCode = StringHelper.GetChineseSpell(DisName); // } // //调用逻辑 // bll.Add( GUID, USER_ID, BusCode, StoCode, TStatus, ChannelCodeList, DisCode, DisName, OtherName, TypeCode, QuickCode, Unit, Price, CostPrice, QRCode, Descript); // ReturnResultJson(bll.oResult.Code, bll.oResult.Msg); //} private void Update(Dictionary <string, object> dicPar) { //要检测的参数信息 List <string> pra = new List <string>() { "GUID", "USER_ID", "userid", "BusCode", "StoCode", "CCname", "UCname", "TStatus", "ChannelCodeList", "DisCode", "DisName", "OtherName", "TypeCode", "QuickCode", "CusDisCode", "Unit", "Price", "MenuCode", "MemPrice", "CostPrice", "RoyMoney", "ExtCode", "FinCode", "KitCode", "CookerCode", "MakeTime", "QRCode", "WarCode", "MatCode", "Descript", "IsCount", "DefCount", "CountPrice", "IsVarPrice", "IsWeight", "IsMethod", "IsStock", "IsPoint", "IsMemPrice", "IsCoupon", "IsKeep", "IsCombo", "CCode", "UCode", "ImageName", "dishesMethodsJson", "dishescombosJson", "dishescomboinfoJson" }; //检测方法需要的参数 if (!CheckActionParameters(dicPar, pra)) { return; } //获取参数信息 string userid = dicPar["userid"].ToString(); string GUID = dicPar["GUID"].ToString(); string USER_ID = dicPar["USER_ID"].ToString(); string StoCode = dicPar["StoCode"].ToString(); string ChannelCodeList = ""; string DisCode = dicPar["DisCode"].ToString(); string DisName = dicPar["DisName"].ToString(); string OtherName = dicPar["OtherName"].ToString(); string QuickCode = dicPar["QuickCode"].ToString(); string Unit = dicPar["Unit"].ToString(); string Price = dicPar["Price"].ToString(); string CostPrice = dicPar["CostPrice"].ToString(); string QRCode = dicPar["QRCode"].ToString(); string Descript = dicPar["Descript"].ToString(); if (string.IsNullOrEmpty(QuickCode)) { QuickCode = StringHelper.GetChineseSpell(DisName); } //调用逻辑 TB_DishEntity UEntity = bll.GetEntitySigInfo("Where DisCode='" + DisCode + "' and Stocode='" + StoCode + "'"); UEntity.ChannelCodeList = ChannelCodeList; UEntity.CostPrice = StringHelper.StringToDecimal(CostPrice); UEntity.Descript = Descript; UEntity.DisName = DisName; UEntity.OtherName = OtherName; UEntity.Price = StringHelper.StringToDecimal(Price); UEntity.QRCode = QRCode; UEntity.QuickCode = QuickCode; UEntity.Unit = Unit; bll.Update(GUID, USER_ID, UEntity); ReturnResultJson(bll.oResult.Code, bll.oResult.Msg); }
/// <summary> /// 保存菜品信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Save_btn_Click(object sender, EventArgs e) { string StoCode = ddlStore.SelectedValue; string ChannelCodeList = ""; string disname = txt_disname.Value; string OtherName = txt_disothername.Value; string typecode = ddl_sel_dishetypetwo.SelectedValue; string QuickCode = txt_quickcode.Value; string UnitName = txt_selunit.Value; string price = txt_price.Value; string costprice = txt_costprice.Value; string Descript = txt_remark.Value; string imagename = hidimages.Value; if (hidid.Value.Length == 0 || hidid.Value == "0")//添加信息 { bll.Add("", "", imagename, StoCode, "1", disname, OtherName, typecode, QuickCode, UnitName, price, costprice, Descript); hidid.Value = bll.oResult.Data; if (bll.oResult.Code == "1") { //添加图片 } this.PageTitle.Operate = "修改"; } else//修改信息 { TB_DishEntity UEntity = bll.GetEntitySigInfo(" discode='" + hidid.Value + "'"); UEntity.StoCode = StoCode; UEntity.ChannelCodeList = ChannelCodeList; UEntity.DisName = disname; UEntity.OtherName = OtherName; UEntity.TypeCode = typecode; UEntity.QuickCode = QuickCode; UEntity.Unit = UnitName; UEntity.ImageName = imagename; UEntity.Price = StringHelper.StringToDecimal(price); UEntity.CostPrice = StringHelper.StringToDecimal(costprice); bll.Update("0", "0", UEntity); } //显示结果 ShowResult(bll.oResult.Code, bll.oResult.Msg, errormessage); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(TB_DishEntity Entity) { StringBuilder sql = new StringBuilder(); sql.Append(" declare @ID int;"); sql.Append(" declare @returnval int;"); sql.Append(" set @returnval=0;"); sql.Append(" declare @DisCode varchar(32);"); sql.Append(" set @DisCode='" + Entity.DisCode + "';"); sql.Append("declare @DisMethodCode varchar(32)"); sql.Append(" if not exists(select 1 from TB_Dish where StoCode='" + Entity.StoCode + "' and DisCode='" + Entity.DisCode + "') set @returnval=2; "); sql.Append(" if exists(select 1 from TB_Dish where StoCode='" + Entity.StoCode + "' and DisCode<>'" + Entity.DisCode + "' and ((QRCode='" + Entity.QRCode + "' and '" + Entity.QRCode + "'<>'') or DisName='" + Entity.DisName + "')) set @returnval=7; "); sql.Append(" if @returnval=0 begin"); string InsertSql = "[StoCode] ='{0}',[DisName] ='{1}',[OtherName] ='{2}',[TypeCode] ='{3}',[QuickCode] ='{4}',[Unit] ='{5}',[Price] ={6},[CostPrice] ={7} ,[QRCode] ='{8}' ,[Descript] ='{9}'"; InsertSql = string.Format(InsertSql, Entity.StoCode, Entity.DisName, Entity.OtherName, Entity.TypeCode, Entity.QuickCode, Entity.Unit, Entity.Price, Entity.CostPrice, Entity.QRCode, Entity.Descript); sql.AppendFormat(" UPDATE TB_Dish SET " + InsertSql + " where DisCode='" + Entity.DisCode + "' and StoCode='" + Entity.StoCode + "' ;"); #region 菜品图片 if (!string.IsNullOrEmpty(Entity.ImageName)) { sql.AppendLine(" delete TR_DishImage where DisCode=@DisCode;"); string[] ins = Entity.ImageName.TrimEnd(',').Split(','); foreach (string name in ins) { sql.AppendFormat(" INSERT INTO TR_DishImage(DisCode,ImgUrl) values(@DisCode,'" + name + "');"); } } #endregion sql.AppendFormat(" set @returnval=1;"); sql.AppendLine(" end"); sql.AppendLine(" select @returnval;"); DataTable dt = DBHelper.ExecuteDataTable(sql.ToString()); if (dt != null && dt.Rows.Count > 0) { return(StringHelper.StringToInt(dt.Rows[0][0].ToString())); } else { return(2); } }
/// <summary> /// 单行数据转实体对象 /// </summary> /// <param name="dr"></param> /// <returns></returns> private TB_DishEntity SetEntityInfo(DataRow dr) { TB_DishEntity Entity = new TB_DishEntity(); Entity.Id = StringHelper.StringToLong(dr["Id"].ToString()); //Entity.BusCode = dr["BusCode"].ToString(); Entity.StoCode = dr["StoCode"].ToString(); Entity.TStatus = dr["TStatus"].ToString(); //Entity.ChannelCodeList = dr["ChannelCodeList"].ToString(); Entity.DisCode = dr["DisCode"].ToString(); Entity.DisName = dr["DisName"].ToString(); Entity.OtherName = dr["OtherName"].ToString(); Entity.TypeCode = dr["TypeCode"].ToString(); Entity.QuickCode = dr["QuickCode"].ToString(); Entity.Unit = dr["Unit"].ToString(); Entity.Price = StringHelper.StringToDecimal(dr["Price"].ToString()); Entity.QRCode = dr["QRCode"].ToString(); Entity.Descript = dr["Descript"].ToString(); Entity.CostPrice = StringHelper.StringToDecimal(dr["CostPrice"].ToString()); return(Entity); }
/// <summary> /// 获取详情 /// </summary> /// <param name="dicPar"></param> private void Detail(Dictionary <string, object> dicPar) { ///要检测的参数信息 List <string> pra = new List <string>() { "GUID", "USER_ID", "userid", "DisCode" }; //检测方法需要的参数 if (!CheckActionParameters(dicPar, pra)) { return; } //获取参数信息 string GUID = dicPar["GUID"].ToString(); string USER_ID = dicPar["USER_ID"].ToString(); string DisCode = dicPar["DisCode"].ToString(); //调用逻辑 TB_DishEntity DEntity = bll.GetEntitySigInfo("Where DisCode='" + DisCode + "'"); ReturnJsonByT <TB_DishEntity>(DEntity); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ref TB_DishEntity Entity) { StringBuilder sql = new StringBuilder(); sql.Append(" declare @ID int;"); sql.Append(" declare @returnval int;"); sql.Append(" set @returnval=0;"); sql.Append("declare @DisCode varchar(32);"); sql.Append("declare @DisMethodCode varchar(32);"); sql.Append("exec [dbo].[p_GetbaseCode] @DisCode output;"); sql.Append(" if exists(select 1 from TB_Dish where StoCode='" + Entity.StoCode + "' and DisName='" + Entity.DisName + "') set @returnval=1;"); sql.Append("BEGIN TRANSACTION tan1"); string InsertSql = " values('{0}',getdate(),'1',@DisCode,'{1}','{2}','{3}','{4}','{5}',{6},{7},'{8}','{9}')"; InsertSql = string.Format(InsertSql, Entity.StoCode, Entity.DisName, Entity.OtherName, Entity.TypeCode, Entity.QuickCode, Entity.Unit, Entity.Price, Entity.CostPrice, Entity.QRCode, Entity.Descript); sql.AppendFormat(" INSERT INTO TB_Dish " + InsertSql + " ;"); #region 菜品图片 if (!string.IsNullOrEmpty(Entity.ImageName)) { string[] ins = Entity.ImageName.Split(','); foreach (string name in ins) { sql.AppendFormat(" INSERT INTO TR_DishImage(DisCode,ImgUrl) values(@DisCode,'/uploads/UpDishImages/" + name + "');"); } } #endregion sql.AppendLine(" if(@@error=0) begin set @returnval=0; commit TRANSACTION tan1; end else begin rollback TRANSACTION tran1;set @returnval=1; end"); sql.AppendLine(" select @returnval;"); DataTable dt = DBHelper.ExecuteDataTable(sql.ToString()); if (dt != null && dt.Rows.Count > 0) { return(StringHelper.StringToInt(dt.Rows[0][0].ToString())); } else { return(2); } }