protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { openid = MyCommFun.QueryString("openid"); aid = MyCommFun.RequestInt("aid"); shopid = MyCommFun.RequestInt("shopid"); shopinfo = shopBll.GetModel(shopid); hotelName = shopinfo.hotelName; idf = MyCommFun.RequestInt("id"); if (idf != 0) { member = menberbll.GetModel(idf); name = member.memberName; phone = member.menberTel; this.note.InnerText = member.memberAddress; } categories = "{"; DataSet category1 = categorybll.GetList(shopid); if (category1.Tables[0].Rows.Count > 0) { for (int i = 0; i < category1.Tables[0].Rows.Count; i++) { categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ","; } } categories = categories.Substring(0, categories.Length - 1); categories += "}"; } }
protected void BindFormControl() { BLL.wx_diancai_caipin_category categorybll = new BLL.wx_diancai_caipin_category(); BLL.wx_diancai_member menberbll = new BLL.wx_diancai_member(); Model.wx_diancai_member member = new Model.wx_diancai_member(); BLL.wx_diancai_shopinfo shopBll = new BLL.wx_diancai_shopinfo(); Model.wx_diancai_shopinfo shopinfo = new Model.wx_diancai_shopinfo(); openid = MyCommFun.QueryString("openid"); shopid = MyCommFun.RequestInt("shopid"); wid = MyCommFun.QueryString("wid"); if (openid == "" || shopid == 0) { return; } shopinfo = shopBll.GetModel(shopid); if (shopinfo == null) { return; } hotelName = shopinfo.hotelName; idf = MyCommFun.RequestInt("id"); member = menberbll.GetModel(shopid, openid); if (member != null) { name = member.memberName; phone = member.menberTel; } categories = "{"; DataSet category1 = categorybll.GetList(shopid); if (category1.Tables[0].Rows.Count > 0) { for (int i = 0; i < category1.Tables[0].Rows.Count; i++) { categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ","; } } categories = categories.Substring(0, categories.Length - 1); categories += "}"; }
/// <summary> /// The process member info. /// </summary> /// <returns> /// The <see cref="ProcessResult"/>. /// </returns> private ProcessResult ProcessMemberInfo() { var menberbll = new BLL.wx_diancai_member(); var member = menberbll.GetModel(shopid, openid); if (member == null) { member = new Model.wx_diancai_member { shopid = this.shopid, openid = this.openid, Name = MyCommFun.QueryString("name"), memberName = MyCommFun.QueryString("name"), menberTel = MyCommFun.QueryString("phone"), memberAddress = string.Empty, successDingdan = 0, failDingdan = 0, cancelDingdan = 0, zongjifen = 0, zongcje = 0, status = 1, createDate = DateTime.Now }; menberbll.Add(member); } else { if (member.status.Value == 0) { return(new ProcessResult() { IsSuccess = false, Message = "您处于黑名单里,不能下单!" }); } member.Name = MyCommFun.QueryString("name"); member.memberName = MyCommFun.QueryString("name"); member.menberTel = MyCommFun.QueryString("phone"); menberbll.Update(member); } return(new ProcessResult() { IsSuccess = true, Message = string.Empty }); }
public void ProcessRequest(HttpContext context) { Dictionary <string, string> jsonDict = new Dictionary <string, string>(); context.Response.ContentType = "text/json"; string _action = MyCommFun.QueryString("myact"); string username = MyCommFun.QueryString("username"); string parssword = MyCommFun.QueryString("parssword"); string id = MyCommFun.QueryString("id"); string openid = MyCommFun.QueryString("openid"); string state = MyCommFun.QueryString("state"); string goodsData = QueryString("goodsData"); int shopid = MyCommFun.RequestInt("shopid"); BLL.wx_diancai_dianyuan dianyuanbll = new BLL.wx_diancai_dianyuan(); Model.wx_diancai_dianyuan dianyuan = new Model.wx_diancai_dianyuan(); BLL.wx_diancai_caipin_category categorybll = new BLL.wx_diancai_caipin_category(); BLL.wx_diancai_member menberbll = new BLL.wx_diancai_member(); Model.wx_diancai_member member = new Model.wx_diancai_member(); BLL.wx_diancai_dingdan_manage manage = new BLL.wx_diancai_dingdan_manage(); Model.wx_diancai_dingdan_manage managemodel = new Model.wx_diancai_dingdan_manage(); BLL.wx_diancai_dingdan_caiping caipinbll = new BLL.wx_diancai_dingdan_caiping(); Model.wx_diancai_dingdan_caiping caipin = new Model.wx_diancai_dingdan_caiping(); if (_action == "login") { if (dianyuanbll.Exists(username, parssword)) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "登录成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } else { jsonDict.Add("ret", "fail"); jsonDict.Add("content", "密码错误!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } } else if (_action == "setstatus") { //id if (manage.Updatestatus(id, state)) { managemodel = manage.GetModel(MyCommFun.Str2Int(id)); BLL.wx_diancai_member menbll = new BLL.wx_diancai_member(); if (state == "1") { menbll.Update(managemodel.openid); } if (state == "2") { menbll.Updatefail(managemodel.openid); } jsonDict.Add("ret", "ok"); jsonDict.Add("content", "提交成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } } else if (_action == "addmember") { #region 用户基本信息管理 member = menberbll.GetModel(shopid, openid); bool isAdd = false; if (member == null) { isAdd = true; } else { if (member.status.Value == 0) { //处于黑名单里 jsonDict.Add("ret", "fail"); jsonDict.Add("content", "您处于黑名单里!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } } member.shopid = shopid; member.openid = openid; member.weixinName = MyCommFun.QueryString("weixinName"); member.Name = MyCommFun.QueryString("username"); member.memberName = MyCommFun.QueryString("username"); member.menberTel = MyCommFun.QueryString("customerTel"); member.memberAddress = MyCommFun.QueryString("address"); member.successDingdan = 0; member.failDingdan = 0; member.cancelDingdan = 0; member.zongjifen = 0; member.zongcje = 0; member.status = 0; member.createDate = DateTime.Now; if (isAdd) { menberbll.Add(member); } else { menberbll.Update(member); } jsonDict.Add("ret", "ok"); jsonDict.Add("content", "提交成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); #endregion } else if (_action == "addcaidan") { string deskNumber = MyCommFun.QueryString("deskNumber");//桌号 //用户点菜完,提交订单 #region 判断参数是否合法,判断用户是否处于黑名单里 if (goodsData == "" || openid == "") { jsonDict.Add("ret", "err"); jsonDict.Add("content", "订单提交失败,参数为空值!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } member = menberbll.GetModel(shopid, openid); bool isAdd = false; if (member == null) { isAdd = true; member = new Model.wx_diancai_member(); } else { if (member.status.Value == 0) { //处于黑名单里 jsonDict.Add("ret", "fail"); jsonDict.Add("content", "您处于黑名单里,不能下单!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } } #endregion //获得商家信息 BLL.wx_diancai_shopinfo shopbll = new BLL.wx_diancai_shopinfo(); Model.wx_diancai_shopinfo shopinfoEntity = new Model.wx_diancai_shopinfo(); shopinfoEntity = shopbll.GetModel(shopid); #region 计算商品总价格 decimal payAmount = 0; string[] sArray = goodsData.Split(';'); for (int i = 0; i < sArray.Length - 1; i++) { string[] sAr = sArray[i].Split(','); payAmount += Convert.ToInt32(sAr[1]) * Convert.ToDecimal(sAr[2]);//总价 } #endregion member.shopid = shopid; member.openid = openid; member.Name = MyCommFun.QueryString("name"); member.memberName = MyCommFun.QueryString("name"); member.menberTel = MyCommFun.QueryString("phone"); member.memberAddress = MyCommFun.QueryString("address"); member.successDingdan = 0; member.failDingdan = 0; member.cancelDingdan = 0; member.zongjifen = 0; member.zongcje = 0; member.status = 0; member.createDate = DateTime.Now; if (isAdd) { menberbll.Add(member); } else { menberbll.Update(member); } #region //订单信息 managemodel.shopinfoid = shopid; managemodel.openid = openid; managemodel.orderNumber = Utils.Number(13); //订单号 managemodel.deskNumber = deskNumber; //桌号deskNumber managemodel.customerName = MyCommFun.QueryString("name"); managemodel.customerTel = MyCommFun.QueryString("phone"); managemodel.address = MyCommFun.QueryString("address"); managemodel.oderRemark = MyCommFun.QueryString("oderRemark"); managemodel.payStatus = 0; managemodel.oderRemark = ""; managemodel.oderTime = DateTime.Now; managemodel.createDate = DateTime.Now; int idf = manage.Add(managemodel); #endregion #region //form表单提交 BLL.wx_diancai_form_control cBll = new BLL.wx_diancai_form_control(); IList <Model.wx_diancai_form_control> controlList = cBll.GetModelList("shopinfoId=" + shopid); if (controlList != null) { BLL.wx_diancai_form_result retBll = new BLL.wx_diancai_form_result(); Model.wx_diancai_form_result result = new Model.wx_diancai_form_result(); result.shopinfoId = shopid; result.openid = openid; result.createDate = DateTime.Now; Model.wx_diancai_form_control control = new Model.wx_diancai_form_control(); for (int i = 0; i < controlList.Count; i++) { control = controlList[i]; string reqControlIdValue = MyCommFun.QueryString("control_" + control.seq); result.cId = control.seq; result.cName = control.cName; result.userResult = reqControlIdValue; retBll.Add(result); } } #endregion //菜品 for (int i = 0; i < sArray.Length - 1; i++) { string[] sAr = sArray[i].Split(','); caipin.dingId = idf; caipin.caiId = Convert.ToInt32(sAr[0]); //菜品ID caipin.num = Convert.ToInt32(sAr[1]); //菜品件数 caipin.price = Convert.ToDecimal(sAr[2]); //菜品单价 caipin.totpric = Convert.ToInt32(sAr[1]) * Convert.ToDecimal(sAr[2]); //总价 // payAmount += Convert.ToInt32(sAr[1]) * Convert.ToDecimal(sAr[2]);//客户购买总价 caipinbll.Add(caipin); } //订单满多少免配送费 if (payAmount < shopinfoEntity.freeSendcost) { payAmount += Convert.ToDecimal(shopinfoEntity.sendCost); } bool isOk = manage.Update(idf, payAmount); if (isOk) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "订单提交成功!请到订单查看!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } else { jsonDict.Add("ret", "err"); jsonDict.Add("content", "订单提交失败!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } context.Response.End(); } }
public void ProcessRequest(HttpContext context) { Dictionary<string, string> jsonDict = new Dictionary<string, string>(); context.Response.ContentType = "text/json"; string _action = MyCommFun.QueryString("myact"); string username = MyCommFun.QueryString("username"); string parssword = MyCommFun.QueryString("parssword"); string id = MyCommFun.QueryString("id"); string openid = MyCommFun.QueryString("openid"); string state = MyCommFun.QueryString("state"); string goodsData = QueryString("goodsData"); int shopid = MyCommFun.RequestInt("shopid"); BLL.wx_diancai_dianyuan dianyuanbll = new BLL.wx_diancai_dianyuan(); Model.wx_diancai_dianyuan dianyuan = new Model.wx_diancai_dianyuan(); BLL.wx_diancai_caipin_category categorybll = new BLL.wx_diancai_caipin_category(); BLL.wx_diancai_member menberbll = new BLL.wx_diancai_member(); Model.wx_diancai_member member = new Model.wx_diancai_member(); BLL.wx_diancai_dingdan_manage manage = new BLL.wx_diancai_dingdan_manage(); Model.wx_diancai_dingdan_manage managemodel = new Model.wx_diancai_dingdan_manage(); BLL.wx_diancai_dingdan_caiping caipinbll = new BLL.wx_diancai_dingdan_caiping(); Model.wx_diancai_dingdan_caiping caipin = new Model.wx_diancai_dingdan_caiping(); if (_action == "login") { if (dianyuanbll.Exists(username, parssword)) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "登录成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } else { jsonDict.Add("ret", "fail"); jsonDict.Add("content", "密码错误!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } } else if (_action == "setstatus") { //id if (manage.Updatestatus(id, state)) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "提交成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } } else if (_action =="addmember") { member.shopid = shopid; openid = Utils.Number(18); member.openid = openid; member.weixinName = MyCommFun.QueryString("weixinName"); member.memberName = MyCommFun.QueryString("username"); member.menberTel = MyCommFun.QueryString("customerTel"); member.memberAddress = MyCommFun.QueryString("address"); member.successDingdan = 0; member.failDingdan = 0; member.cancelDingdan = 0; member.zongjifen = 0; member.zongcje = 0; member.status = 1; member.createDate = DateTime.Now; menberbll.Add(member); jsonDict.Add("ret", "ok"); jsonDict.Add("content", "提交成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } else if (_action == "addcaidan") { if (goodsData == "") { jsonDict.Add("ret", "err"); jsonDict.Add("content", "goodsData为空值!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } if (openid == "") { jsonDict.Add("ret", "fail"); jsonDict.Add("content", "订单提交失败!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } //用户信息 managemodel.shopinfoid = shopid; managemodel.openid = openid; managemodel.orderNumber = Utils.Number(13);//订单号 managemodel.deskNumber = "";//桌号 // manage.customerName = this.name.Value; //manage.customerTel = this.phone.Value; managemodel.payStatus = 0; managemodel.oderRemark = ""; managemodel.oderTime = DateTime.Now; managemodel.createDate = DateTime.Now; int idf = manage.Add(managemodel); decimal payAmount = 0; //菜品 string[] sArray = goodsData.Split(';'); for (int i = 0; i < sArray.Length - 1; i++) { string[] sAr = sArray[i].Split(','); caipin.dingId = idf; caipin.caiId = Convert.ToInt32(sAr[0]);//菜品ID caipin.num = Convert.ToInt32(sAr[1]);//菜品件数 caipin.price = Convert.ToDecimal(sAr[2]);//菜品单价 caipin.totpric = Convert.ToInt32(sAr[1]) * Convert.ToDecimal(sAr[2]);//总价 payAmount += Convert.ToInt32(sAr[1]) * Convert.ToDecimal(sAr[2]);//客户购买总价 caipinbll.Add(caipin); } bool isOk= manage.Update(idf, payAmount); if (isOk) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "订单提交成功!请到订单查看!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } else { jsonDict.Add("ret", "err"); jsonDict.Add("content", "订单提交失败!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } context.Response.End(); } }
public void ProcessRequest(HttpContext context) { Dictionary <string, string> jsonDict = new Dictionary <string, string>(); context.Response.ContentType = "text/json"; string _action = MyCommFun.QueryString("myact"); string username = MyCommFun.QueryString("username"); string parssword = MyCommFun.QueryString("parssword"); string id = MyCommFun.QueryString("id"); string openid = MyCommFun.QueryString("openid"); string state = MyCommFun.QueryString("state"); string goodsData = QueryString("goodsData"); int shopid = MyCommFun.RequestInt("shopid"); BLL.wx_diancai_dianyuan dianyuanbll = new BLL.wx_diancai_dianyuan(); Model.wx_diancai_dianyuan dianyuan = new Model.wx_diancai_dianyuan(); BLL.wx_diancai_caipin_category categorybll = new BLL.wx_diancai_caipin_category(); BLL.wx_diancai_member menberbll = new BLL.wx_diancai_member(); Model.wx_diancai_member member = new Model.wx_diancai_member(); BLL.wx_diancai_dingdan_manage manage = new BLL.wx_diancai_dingdan_manage(); Model.wx_diancai_dingdan_manage managemodel = new Model.wx_diancai_dingdan_manage(); BLL.wx_diancai_dingdan_caiping caipinbll = new BLL.wx_diancai_dingdan_caiping(); Model.wx_diancai_dingdan_caiping caipin = new Model.wx_diancai_dingdan_caiping(); if (_action == "login") { if (dianyuanbll.Exists(username, parssword)) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "登录成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } else { jsonDict.Add("ret", "fail"); jsonDict.Add("content", "密码错误!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } } else if (_action == "setstatus") { //id if (manage.Updatestatus(id, state)) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "提交成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } } else if (_action == "addmember") { member.shopid = shopid; openid = Utils.Number(18); member.openid = openid; member.weixinName = MyCommFun.QueryString("weixinName"); member.memberName = MyCommFun.QueryString("username"); member.menberTel = MyCommFun.QueryString("customerTel"); member.memberAddress = MyCommFun.QueryString("address"); member.successDingdan = 0; member.failDingdan = 0; member.cancelDingdan = 0; member.zongjifen = 0; member.zongcje = 0; member.status = 1; member.createDate = DateTime.Now; menberbll.Add(member); jsonDict.Add("ret", "ok"); jsonDict.Add("content", "提交成功!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } else if (_action == "addcaidan") { if (goodsData == "") { jsonDict.Add("ret", "err"); jsonDict.Add("content", "goodsData为空值!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } if (openid == "") { jsonDict.Add("ret", "fail"); jsonDict.Add("content", "订单提交失败!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); return; } //用户信息 managemodel.shopinfoid = shopid; managemodel.openid = openid; managemodel.orderNumber = Utils.Number(13); //订单号 managemodel.deskNumber = ""; //桌号 // manage.customerName = this.name.Value; //manage.customerTel = this.phone.Value; managemodel.payStatus = 0; managemodel.oderRemark = ""; managemodel.oderTime = DateTime.Now; managemodel.createDate = DateTime.Now; int idf = manage.Add(managemodel); decimal payAmount = 0; //菜品 string[] sArray = goodsData.Split(';'); for (int i = 0; i < sArray.Length - 1; i++) { string[] sAr = sArray[i].Split(','); caipin.dingId = idf; caipin.caiId = Convert.ToInt32(sAr[0]); //菜品ID caipin.num = Convert.ToInt32(sAr[1]); //菜品件数 caipin.price = Convert.ToDecimal(sAr[2]); //菜品单价 caipin.totpric = Convert.ToInt32(sAr[1]) * Convert.ToDecimal(sAr[2]); //总价 payAmount += Convert.ToInt32(sAr[1]) * Convert.ToDecimal(sAr[2]); //客户购买总价 caipinbll.Add(caipin); } bool isOk = manage.Update(idf, payAmount); if (isOk) { jsonDict.Add("ret", "ok"); jsonDict.Add("content", "订单提交成功!请到订单查看!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } else { jsonDict.Add("ret", "err"); jsonDict.Add("content", "订单提交失败!"); context.Response.Write(MyCommFun.getJsonStr(jsonDict)); } context.Response.End(); } }
protected void BindFormControl() { BLL.wx_diancai_caipin_category categorybll = new BLL.wx_diancai_caipin_category(); BLL.wx_diancai_dingdan_caiping caipinbll = new BLL.wx_diancai_dingdan_caiping(); BLL.wx_diancai_member menberbll = new BLL.wx_diancai_member(); Model.wx_diancai_member member = new Model.wx_diancai_member(); BLL.wx_diancai_shopinfo shopBll = new BLL.wx_diancai_shopinfo(); Model.wx_diancai_shopinfo shopinfo = new Model.wx_diancai_shopinfo(); BLL.wx_diancai_form_control controlbll = new BLL.wx_diancai_form_control(); openid = MyCommFun.QueryString("openid"); shopid = MyCommFun.RequestInt("shopid"); zhuohao(shopid); if (openid == "" || shopid == 0) { return; } shopinfo = shopBll.GetModel(shopid); rename = shopinfo.dcRename; hotelName = shopinfo.hotelName; idf = MyCommFun.RequestInt("id"); member = menberbll.GetModel(shopid, openid); if (member != null) { name = member.memberName; phone = member.menberTel; this.address.InnerText = member.memberAddress; } if (shopinfo.limiteOrder && (!isOpen(shopinfo))) { contact_info.Style.Add("display", "none"); showcard.Style.Add("display", "none"); // MessageBox.ResponseScript(this, "$(\"#showcard2\").show();"); showcard2.Style.Add("display", ""); // contact_info.InnerHtml = ""; } //获取控件 DataSet ZH = controlbll.GetListZH(shopid); if (ZH.Tables[0].Rows.Count > 0) { for (int i = 0; i < ZH.Tables[0].Rows.Count; i++) { if (ZH.Tables[0].Rows[i]["cType"].ToString() == "0") { kongjian += "<tr><td width=\"80px\"><label for=\"txt" + i + "\" class=\"ui-input-text\" >" + ZH.Tables[0].Rows[i]["cName"] + ":</label></td>"; kongjian += "<td><div class=\"ui-input-text\">"; kongjian += " <input type=\"text\" id=\"txt" + i + "\" name=\"txt" + i + "\" value=\"\" class=\"ui-input-text\" placeholder=\"" + ZH.Tables[0].Rows[i]["defaultValue"] + "\">"; kongjian += "</div></td></tr>"; javascriptStr += "control_" + ZH.Tables[0].Rows[i]["seq"] + ":$(\"#txt" + i + "\").val(),"; } else if (ZH.Tables[0].Rows[i]["cType"].ToString() == "1") { kongjian += "<tr><td width=\"80px\"><label for=\"select" + i + "\" class=\"ui-input-text\" >" + ZH.Tables[0].Rows[i]["cName"] + ":</label></td>"; kongjian += "<td>"; kongjian += "<select name=\"select" + i + "\" class=\"selectstyle\" id=\"select" + i + "\" >"; if (ZH.Tables[0].Rows[i]["defaultValue"].ToString() != "") { string strzh = ZH.Tables[0].Rows[i]["defaultValue"].ToString().Replace(",", ","); string[] sArray = strzh.Split(','); for (int j = 0; j < sArray.Length; j++) { kongjian += "<option value=" + sArray[j] + ">" + sArray[j] + "</option>"; } } kongjian += "</select>"; kongjian += "</td></tr>"; javascriptStr += "control_" + ZH.Tables[0].Rows[i]["seq"] + ":$(\"#select" + i + "\").val(),"; } } } categories = "{"; DataSet category1 = categorybll.GetList(shopid); if (category1.Tables[0].Rows.Count > 0) { for (int i = 0; i < category1.Tables[0].Rows.Count; i++) { categories += "\"" + category1.Tables[0].Rows[i]["id"].ToString() + "\"" + ":" + "\"" + category1.Tables[0].Rows[i]["categoryName"].ToString() + "\"" + ","; } } categories = categories.Substring(0, categories.Length - 1); categories += "}"; }