protected void Page_Load(object sender, EventArgs e) { if (Com.Session.userid == null) { Response.Redirect("../../Login.aspx"); Response.End(); } else { SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd(); SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd(); BusId = Request.Params["BusId"].ToString(); servbusmodel = servbusbll.GetModel(int.Parse(BusId)); string FuncStr = ""; if (servbusmodel != null && servbusmodel.BusId > 0) { umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(servbusmodel); } else { Response.Write("无该套餐!"); Response.End(); } //获取下拉列表 StringBuilder sbarea = new StringBuilder(); //获取省份 sbarea.Append(" <div class=\"row\">"); sbarea.Append("<div class=\"col-xs-3 text-right\">默认归属地(省):</div>"); sbarea.Append("<div class=\"col-xs-2 text-left\">"); sbarea.Append("<select id=\"aprov\">"); string sareacode = ""; if (servbusmodel != null && servbusmodel.BusId > 0 && servbusmodel.BusArea.Length == 6) { sareacode = servbusmodel.BusArea.Substring(0, 2) + "0000"; } sbarea.Append(Com.Public.GetDrpArea("0", "", ref sareacode, false, "0")); sbarea.Append("</select> "); sbarea.Append(" </div>"); //获取城市 sbarea.Append("<div class=\"col-xs-3 text-right\">默认归属地(市):</div>"); sbarea.Append("<div class=\"col-xs-3 text-left\">"); sbarea.Append("<select id=\"acity\">"); string sareacitycode = ""; if (servbusmodel != null && servbusmodel.BusId > 0 && servbusmodel.BusArea.Length == 6) { sareacitycode = servbusmodel.BusArea.Substring(0, 4) + "00"; } sbarea.Append(Com.Public.GetDrpArea("1", sareacode, ref sareacitycode, false, "0")); sbarea.Append("</select> "); sbarea.Append(" </div>"); sbarea.Append(" </div>"); areastr = sbarea.ToString(); //对应套餐 SchSystem.BLL.ServBus stBll = new SchSystem.BLL.ServBus(); DataTable stdt = stBll.GetList("BusId,CnName", "").Tables[0]; servbus = Newtonsoft.Json.JsonConvert.SerializeObject(stdt); } }
public static Com.DataPack.DataRsp <string> page(string PageIndex, string PageSize) { Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>(); if (Com.Session.userid == null) { rsp.code = "expire"; rsp.msg = "你现在登录已过期,请重新登录!"; } else { SchSystem.BLL.ServBusThd servbusthdbll = new SchSystem.BLL.ServBusThd(); string strwhere = "1=1 "; Com.Public.PageModelResp pages = new Com.Public.PageModelResp(); pages.PageIndex = int.Parse(PageIndex); pages.PageSize = int.Parse(PageSize); int rowc = 0; int pc = 0; string dbcols = "BusId,ThdName,ServiceId,FeeCode,CnName,BusMonth,BusNote,BusArea,BusUtype,Mbusid,BusType,BusUrl,Note,ThdMonth"; DataTable dt = servbusthdbll.GetListCols(dbcols, strwhere, "BusId", "DESC", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; pages.PageCount = pc; pages.RowCount = rowc; if (dt.Rows.Count > 0) { dt.Columns.Add("SHENG"); dt.Columns.Add("SHI"); dt.Columns.Add("TUserType"); dt.Columns.Add("TBusMonth"); dt.Columns.Add("TThdMonth"); dt.Columns.Add("TMbusidName"); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["SHENG"] = Com.Public.GetSSQ("0", dt.Rows[i]["BusArea"].ToString()); dt.Rows[i]["SHI"] = Com.Public.GetSSQ("1", dt.Rows[i]["BusArea"].ToString()); dt.Rows[i]["TUserType"] = dt.Rows[i]["BusUtype"].ToString() == "1" ? " 老师" : dt.Rows[i]["BusUtype"].ToString() == "2" ? " 家长" : "学生"; dt.Rows[i]["TBusMonth"] = Com.Public.InttoMonth(Convert.ToInt32(dt.Rows[i]["BusMonth"])); dt.Rows[i]["TThdMonth"] = Com.Public.InttoMonth(Convert.ToInt32(dt.Rows[i]["ThdMonth"])); dt.Rows[i]["TMbusidName"] = servbusthdbll.GetServBusNames(" BusId=" + Convert.ToInt32(dt.Rows[i]["Mbusid"])); } pages.list = dt; } rsp.RspData = Newtonsoft.Json.JsonConvert.SerializeObject(pages); } return(rsp); }
public static string ServBusThdAddSave(List <string> arr) { string ret = ""; if (Com.Session.userid == null) { ret = "expire"; } else { SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd(); SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd(); foreach (string str in arr) { string[] strarr = str.Split('#'); if (strarr[0] == "ThdName") { servbusmodel.ThdName = strarr[1]; } if (strarr[0] == "ServiceId") { servbusmodel.ServiceId = strarr[1]; } if (strarr[0] == "CnName") { servbusmodel.CnName = strarr[1]; } if (strarr[0] == "FeeCode") { servbusmodel.FeeCode = strarr[1]; } if (strarr[0] == "BusMonth") { servbusmodel.BusMonth = Convert.ToInt32(strarr[1]); } if (strarr[0] == "BusNote") { servbusmodel.BusNote = strarr[1]; } if (strarr[0] == "BusArea") { servbusmodel.BusArea = strarr[1]; } if (strarr[0] == "BusUtype") { servbusmodel.BusUtype = Convert.ToInt32(strarr[1]); } if (strarr[0] == "Mbusid") { servbusmodel.Mbusid = Convert.ToInt32(strarr[1]); } if (strarr[0] == "ThdMonth") { servbusmodel.ThdMonth = Convert.ToInt32(strarr[1]); } if (strarr[0] == "Note") { servbusmodel.Note = strarr[1]; } } try { int result = servbusbll.Add(servbusmodel); if (result > 0) { ret = "success"; } else { ret = "error"; } } catch (Exception ex) { ret = ex.Message; } } return(ret); }
public static Com.DataPack.DataRsp <string> ServBusEditSave(List <string> arr) { Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>(); if (Com.Session.userid == null) { rsp.code = "expire"; rsp.msg = "你现在登录已过期,请重新登录!"; } else { string currentCnName = ""; string currentCode = ""; try { SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd(); SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd(); foreach (string str in arr) { string[] strarr = str.Split('#'); if (strarr[0] == "BusId") { servbusmodel.BusId = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "ThdName") { servbusmodel.ThdName = strarr[1].Trim(); } else if (strarr[0] == "ServiceId") { servbusmodel.ServiceId = strarr[1].Trim(); } else if (strarr[0] == "CnName") { servbusmodel.CnName = strarr[1].Trim(); } else if (strarr[0] == "FeeCode") { servbusmodel.FeeCode = strarr[1].Trim(); } else if (strarr[0] == "BusMonth") { servbusmodel.BusMonth = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "BusNote") { servbusmodel.BusNote = strarr[1].Trim(); } else if (strarr[0] == "BusArea") { servbusmodel.BusArea = strarr[1].Trim(); } else if (strarr[0] == "BusUtype") { servbusmodel.BusUtype = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "Mbusid") { servbusmodel.Mbusid = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "ThdMonth") { servbusmodel.ThdMonth = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "Note") { servbusmodel.Note = strarr[1].Trim(); } else if (strarr[0] == "currentCnName") { currentCnName = strarr[1].Trim(); } else if (strarr[0] == "currentCode") { currentCode = strarr[1].Trim(); } } DataTable cnnamedt = servbusbll.ExistsCnNameUpdate(servbusmodel.CnName, 0, currentCnName).Tables[0]; DataTable codedt = servbusbll.ExistsCodeUpdate(servbusmodel.ServiceId, 0, currentCode).Tables[0]; if (servbusmodel.ThdName == "" || servbusmodel.CnName == "") { rsp.code = "error"; rsp.msg = "操作失败!不允许输入空格"; } else if (cnnamedt.Rows.Count > 0) { rsp.code = "nameRepeat"; rsp.msg = "套餐名称不允许重复"; } else if (codedt.Rows.Count > 0) { rsp.code = "codeRepeat"; rsp.msg = "套餐代码不允许重复"; } else { if (servbusbll.Update(servbusmodel)) { rsp.code = "success"; rsp.msg = "操作成功"; } else { rsp.code = "error"; rsp.msg = "操作失败"; } } } catch (Exception ex) { rsp.code = "excepError"; rsp.msg = ex.Message; } } return(rsp); }
public static Com.DataPack.DataRsp <string> ServBusThdAddSave(List <string> arr) { Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>(); if (Com.Session.userid == null) { rsp.code = "expire"; rsp.msg = "你现在登录已过期,请重新登录!"; } else { try { SchSystem.BLL.ServBusThd servbusbll = new SchSystem.BLL.ServBusThd(); SchSystem.Model.ServBusThd servbusmodel = new SchSystem.Model.ServBusThd(); foreach (string str in arr) { string[] strarr = str.Split('#'); if (strarr[0] == "ThdName") { servbusmodel.ThdName = strarr[1].Trim(); } else if (strarr[0] == "ServiceId") { servbusmodel.ServiceId = strarr[1].Trim(); } else if (strarr[0] == "CnName") { servbusmodel.CnName = strarr[1].Trim(); } else if (strarr[0] == "FeeCode") { servbusmodel.FeeCode = strarr[1].Trim(); } else if (strarr[0] == "BusMonth") { servbusmodel.BusMonth = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "BusNote") { servbusmodel.BusNote = strarr[1].Trim(); } else if (strarr[0] == "BusArea") { servbusmodel.BusArea = strarr[1].Trim(); } else if (strarr[0] == "BusUtype") { servbusmodel.BusUtype = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "Mbusid") { servbusmodel.Mbusid = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "ThdMonth") { servbusmodel.ThdMonth = Convert.ToInt32(strarr[1]); } else if (strarr[0] == "Note") { servbusmodel.Note = strarr[1].Trim(); } } if (servbusmodel.ThdName == "" || servbusmodel.CnName == "") { rsp.code = "error"; rsp.msg = "操作失败!不允许输入空格"; } else if (servbusbll.ExistsServiceId(0, servbusmodel.ServiceId)) { rsp.code = "code"; rsp.msg = "套餐代码不允许重复!"; } else if (servbusbll.ExistsCnName(0, servbusmodel.CnName)) { rsp.code = "zhcf"; rsp.msg = "套餐名称不允许重复!"; } else { int result = servbusbll.Add(servbusmodel); if (result > 0) { rsp.code = "success"; rsp.msg = "操作成功"; } else { rsp.code = "error"; rsp.msg = "操作失败"; } } } catch (Exception ex) { rsp.code = "ExcepError"; rsp.msg = ex.Message; } } return(rsp); }