public JsonResult Order_TD(string str) { BLL.OrderInfoBLL _BLL = new OrderInfoBLL(); retValue ret = new retValue(); JObject o = null; PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel; int userid = userModel._ID; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string ids = o["ID"]._ToStrTrim(); int Month = o["Month"]._ToInt32(); int OrderNum = o["OrderNum"]._ToInt32(); int Group_Type = o["Group_Type"]._ToInt32(); //1全退,2部分退 if (Group_Type == 1) { Month = 0; OrderNum = 0; } ret = _BLL.TD(ids.Remove(ids.Length - 1), userid, Group_Type, Month, OrderNum); } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 用户登录 /// </summary> /// <param name="UserNo">用户编号</param> /// <param name="password">密码</param> /// <returns>返回验证结果</returns> public retValue Login(string UserNo, string password) { retValue ret = new retValue(); ret = dal.Login(UserNo, password); return(ret); }
public ActionResult OrgInfo_AddEdit() { string ID = Request["ID"]._ToStrTrim(); string ParentID = Request["ParentID"]._ToStrTrim(); List <retValue> resultList = new List <retValue>(); //如果修改则传ID,新增则传上级ID if (!string.IsNullOrEmpty(ID)) { retValue ret = new retValue(); ret.result = true; ret.data = "修改"; resultList.Add(ret); BLL.OrgInfoBLL _OrgInfoBLL = new OrgInfoBLL(); ret = _OrgInfoBLL.GetOrgByPK(ID._ToInt32()); resultList.Add(ret); ViewData.Model = resultList; } else if (!string.IsNullOrEmpty(ParentID)) { retValue ret = new retValue(); ret.result = false; ret.data = ParentID; resultList.Add(ret); ViewData.Model = resultList; } else { ViewData.Model = null; } return(View()); }
public retValue GetCostRecords(int id, string state, int orderid, string OrderNo, string unitname, int UserOrgID = 0) { retValue _retValue = new retValue(); try { _retValue.result = true; DataTable tj = dal.GetCount(id, state, orderid, OrderNo, unitname, UserOrgID); if (tj.Rows.Count > 0 && tj != null) { _retValue.data = "总订购月数:" + tj.Rows[0]["OrderMonths"]._ToInt32() + ",总订购份数:" + tj.Rows[0]["OrderNum"]._ToInt32() + ",总价:" + tj.Rows[0]["Money"]._ToDecimal() + ",已缴费用:" + tj.Rows[0]["MoneyPayed"]._ToDecimal(); } else { _retValue.data = "总订购数:0;总订购月:0;订购总价:0;已缴总额:0"; } } catch (Exception ex) { _retValue.result = false; _retValue.reason = ex.Message; } return(_retValue); }
public JsonResult Check_FF(string str) { retValue ret = new retValue(); BLL.DistributeBLL _BLL = new DistributeBLL(); JObject o = null; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string nianjuanqi = o["nianjuanqi"]._ToStrTrim(); string action = o["action"]._ToStrTrim(); //日志类型,0表示市,1表示县 int type = 0; if (action == "area") { type = 1; } string ids = o["ids"]._ToStrTrim(); if (_BLL.count(ids, type, nianjuanqi) > 0) { ret.result = false; ret.reason = "1000"; } else { ret.result = true; ret.data = ""; } } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public JsonResult DocInfos(string str) { retValue ret = new retValue(); BLL.DocBLL _DocBLL = new DocBLL(); JObject o = null; string content = string.Empty; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string test1 = o["test1"]._ToStrTrim(); string test2 = o["test2"]._ToStrTrim(); string Type = o["Type"]._ToStrTrim(); string Name = o["Name"]._ToStrTrim(); string ISSN = o["ISSN"]._ToStrTrim(); string BKDH = o["BKDH"]._ToStrTrim().ToUpper(); string PublishArea = o["PublishArea"]._ToStrTrim(); ret = _DocBLL.GetDoc("", Type, Name, ISSN, PublishArea, "", "", test1, test2, BKDH); } content = ret.toJson(); var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public JsonResult DistributeLog_FF(string str) { retValue ret = new retValue(); BLL.DistributeBLL _BLL = new DistributeBLL(); JObject o = null; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); UserModel userModel = Session["userModel"] as UserModel; string nianjuanqi = o["nianjuanqi"]._ToStrTrim(); string action = o["action"]._ToStrTrim(); //日志类型,0表示市,1表示县 int type = 0; if (action == "area") { type = 1; } string ids = o["ids"]._ToStrTrim(); ret = _BLL.insertLog(ids, nianjuanqi, userModel._ID, type); } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public JsonResult Order_Deletes(string str) { BLL.OrderInfoBLL _BLL = new OrderInfoBLL(); retValue ret = new retValue(); string content = string.Empty; DataTable dt = str.ToTable(); string ids = ""; string costs = ""; foreach (DataRow item in dt.Rows) { if (!string.IsNullOrEmpty(item["ID"]._ToStrTrim())) { ids += item["ID"]._ToStrTrim() + ","; costs += item["CostID"]._ToStrTrim() + ","; } } ret = _BLL.DeleteByPK(ids.Remove(ids.Length - 1)); if (ret.result) { CostBLL costBLL = new CostBLL(); costBLL.DeleteByPK(costs); } content = ret.toJson(); var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public retValue GetCount(string BKDH, string orgid, string userorg, string Group_Type, string dt1, bool area = false) { retValue pg = new retValue(); try { DataTable tj = _dal.GetCount(BKDH, orgid, userorg, Group_Type, dt1, area); if (tj.Rows.Count > 0 && tj != null) { pg.result = true; pg.data = "总份数:" + tj.Rows[0]["OrderNum"]._ToInt32(); } else { pg.result = true; pg.reason = "未能查询出数据,不能统计"; } } catch (Exception ex) { pg.result = false; pg.reason = ex.Message; } return(pg); }
/// <summary> /// 新增 /// </summary> /// <param name="OrderNo">公司编号</param> /// <param name="UnitName">单位名称</param> /// <param name="name">负责人名称</param> /// <param name="phone">联系方式</param> /// <param name="address">地址</param> /// <param name="OrgID">所属网点</param> /// <param name="InUser">录入人</param> /// <returns>成功返回空值,否则返回提示</returns> public retValue Insert(string OrderNo, string UnitName, string name, string phone, string address, string OrgID, int InUser) { retValue ret = new retValue(); ret = dal.Insert(OrderNo, UnitName, name, phone, address, OrgID, InUser); return(ret); }
public JsonResult GetAllDocInfo(string str) { retValue ret = new retValue(); BLL.DocBLL _BLL = new DocBLL(); ret = _BLL.GetDoc(str, "", "", "", "", "", "", "", "", ""); var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public JsonResult GetPosters() { retValue ret = new retValue(); UserModel user = Session["UserModel"] as UserModel; BLL.UserBLL _BLL = new UserBLL(); ret.result = true; ret.data = _BLL.GetPosters(user.OrgID._ToStr()); var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public JsonResult UserLoginOut(string str) { retValue ret = new retValue(); Session["UserModel"] = null; ret.result = true; ret.data = "NEEDLOGIN"; UserModel.needlogin = true; var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public JsonResult OrgInfos(string str) { retValue ret = new retValue(); BLL.OrgInfoBLL _BLL = new OrgInfoBLL(); UserModel user = Session["UserModel"] as UserModel; ret = _BLL.GetOrgByParentID(str._ToInt32(), user.OrgID, user.Level); var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增 /// </summary> /// <param name="OrderNo">公司编号</param> /// <param name="UnitName">单位名称</param> /// <param name="name">负责人名称</param> /// <param name="phone">联系方式</param> /// <param name="address">地址</param> /// <param name="OrgID">所属网点</param> /// <param name="InUser">录入人</param> /// <returns></returns> public retValue Insert(string OrderNo, string UnitName, string name, string phone, string address, string OrgID, int InUser) { retValue ret = new retValue(); string res = ""; try { res = check(OrderNo); if (!string.IsNullOrEmpty(res)) { ret.result = false; ret.reason = res; return(ret); } string sql = @" insert into OrderPeople(OrderNo,UnitName,name,phone,address,OrgID,InUser) values(@OrderNo,@UnitName,@name,@phone,@address,@OrgID,@InUser) "; SqlParameter Para = null; Para = new SqlParameter("OrderNo", OrderNo._ToStrTrim().ToUpper()); dbhelper.SqlParameterList.Add(Para); Para = new SqlParameter("UnitName", UnitName._ToStrTrim().ToUpper()); dbhelper.SqlParameterList.Add(Para); Para = new SqlParameter("name", name._ToStrTrim().ToUpper()); dbhelper.SqlParameterList.Add(Para); Para = new SqlParameter("phone", phone._ToStrTrim()); dbhelper.SqlParameterList.Add(Para); Para = new SqlParameter("address", address._ToStrTrim()); dbhelper.SqlParameterList.Add(Para); Para = new SqlParameter("OrgID", OrgID._ToInt32()); dbhelper.SqlParameterList.Add(Para); Para = new SqlParameter("InUser", InUser._ToInt32()); dbhelper.SqlParameterList.Add(Para); int num = dbhelper.ExecuteInsert(sql); if (num == 0) { ret.result = false; res = "操作失败"; } else { ret.result = true; ret.data = num; } } catch (Exception ex) { ret.result = false; res = ex.Message; } ret.reason = res; return(ret); }
public ActionResult Order_getCounts(string str) { retValue ret = new retValue(); PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel; int userid = userModel._ID; BLL.OrderInfoBLL _BLL = new OrderInfoBLL(); JObject o = null; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string test1 = o["test1"]._ToStrTrim(); string test2 = o["test2"]._ToStrTrim(); string Province = o["Province"]._ToStrTrim(); string CompanyCity = o["CompanyCity"]._ToStrTrim(); string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim(); string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim(); string OrderNo = o["OrderNo"]._ToStrTrim(); string UnitName = o["UnitName"]._ToStrTrim(); string BKDH = o["BKDH"]._ToStrTrim(); string OrderState = o["OrderState"]._ToStrTrim(); string CostState = o["CostState"]._ToStrTrim(); string OrgID = ""; if (Province._ToInt32() > 0) { OrgID = Province; } if (CompanyCity._ToInt32() > 0) { OrgID = CompanyCity; } if (CompanyUnderCity._ToInt32() > 0) { OrgID = CompanyUnderCity; } if (CompanyUnderArea._ToInt32() > 0) { OrgID = CompanyUnderArea; } PageModel pg = _BLL.GetCount(0, BKDH, OrderNo, UnitName, test1, test2, userModel.OrgID._ToStr(), OrgID, OrderState, CostState); ret.result = true; ret.data = pg.msg; } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public ActionResult Order_getCounts(string str) { retValue ret = new retValue(); PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel; int userid = userModel._ID; BLL.DistributeBLL _BLL = new DistributeBLL(); JObject o = null; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string test1 = o["test1"]._ToStrTrim(); string Group_Type = o["Group_Type"]._ToStrTrim(); string Province = o["Province"]._ToStrTrim(); string CompanyCity = o["CompanyCity"]._ToStrTrim(); string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim(); string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim(); string NewspaperName = o["NewspaperName"]._ToStrTrim(); string Roads = o["Roads"]._ToStrTrim(); string OrgID = ""; if (Province._ToInt32() > 0) { OrgID = Province; } if (CompanyCity._ToInt32() > 0) { OrgID = CompanyCity; } if (CompanyUnderCity._ToInt32() > 0) { OrgID = CompanyUnderCity; } if (CompanyUnderArea._ToInt32() > 0) { OrgID = CompanyUnderArea; } if (Roads._ToInt32() > 0) { OrgID = Roads; } ret = _BLL.GetCount(NewspaperName, OrgID, userModel.OrgID._ToStr(), Group_Type, test1); } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public JsonResult UserInfo_AddEdits(string str) { retValue ret = new retValue(); UserModel user = Session["UserModel"] as UserModel; BLL.UserBLL _UserBLL = new UserBLL(); JObject o = null; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string ID = o["ID"]._ToStrTrim(); string MGUID = o["MGUID"]._ToStrTrim(); string USERNO = o["USERNO"]._ToStrTrim(); string NAME = o["NAME"]._ToStrTrim(); string Sex = o["Sex"]._ToStrTrim(); string Role = o["Role"]._ToStrTrim(); string Password = o["Password"]._ToStrTrim(); string IDCard = o["IDCard"]._ToStrTrim(); string PhoneNumber = o["PhoneNumber"]._ToStrTrim(); string Email = o["Email"]._ToStrTrim(); string Address = o["Address"]._ToStrTrim(); string Province = o["Province"]._ToStrTrim(); string CompanyCity = o["CompanyCity"]._ToStrTrim(); string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim(); string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim(); string State = o["State"]._ToStrTrim(); string OrgID = CompanyUnderArea == "" ? (CompanyUnderCity == "" ? (CompanyCity == "" ? Province : CompanyCity) : CompanyUnderCity) : CompanyUnderArea; //新增 if (string.IsNullOrEmpty(ID)) { ret = _UserBLL.Insert(USERNO, NAME, Sex, Role, OrgID, IDCard, Password, PhoneNumber, Address, Email, user._ID._ToStr(), user.Level); } //更新 else { ret = _UserBLL.UpdateByPK(ID._ToInt32(), USERNO, NAME, Sex, Role, OrgID, IDCard, State, MGUID, Email, PhoneNumber, Password); } } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据报刊编号更新数据 /// </summary> /// <param name="ID">报刊编号</param> /// <param name="Name">名称</param> /// <param name="ISSN">ISSN</param> /// <param name="TypeID">类型ID</param> /// <param name="PublishArea">出版地</param> /// <param name="Publisher">出版社</param> /// <param name="PublishYear">出版年</param> /// <param name="C200F">责任者</param> /// <param name="Price">单价</param> /// <param name="PL">出版频率</param> /// <param name="BKDH">报刊代号</param> /// <param name="guid">唯一标识</param> /// <returns>成功返回空值,否则返回提示</returns> public retValue UpdateByPK(int ID, string Name, string ISSN, string TypeID, string PublishArea, string Publisher, string Price, string PL, string BKDH, string guid) { retValue ret = new retValue(); string res = dal.UpdateByPK(ID, Name, ISSN, TypeID, PublishArea, Publisher, Price, PL, BKDH, guid); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "保存成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
public JsonResult OrgInfo_Deletes(string str) { retValue ret = new retValue(); BLL.OrgInfoBLL _BLL = new OrgInfoBLL(); UserModel user = Session["UserModel"] as UserModel; if (!string.IsNullOrEmpty(str)) { ret = _BLL.DeleteByPK(str, user.Level); } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 根据主键删除数据 /// </summary> /// <param name="IDs">主键,多个用英文逗号分隔</param> /// <returns>成功返回空值,否则返回提示</returns> public retValue DeleteByPK(string IDs) { retValue ret = new retValue(); string res = dal.DeleteByPK(IDs); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "删除成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
public retValue UpdateByPK(int ID, int months, int ordernum, string bkdh, int PersonID, int ModifyUser, int PosterID, string OrderDate, string guid = "") { retValue ret = new retValue(); string res = dal.update(ID, ordernum, months, guid, bkdh, PersonID, ModifyUser, PosterID, OrderDate); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "保存成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
public retValue TD(string ID, int ModifyUser, int type = 0, int months = 0, int OrderNum = 0) { retValue ret = new retValue(); string res = dal.TD(ID, ModifyUser, type, months, OrderNum); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "退订成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
public retValue UpdateByPK(int id, decimal money, decimal moneypayed, int userid) { retValue ret = new retValue(); string res = dal.update(id, money, moneypayed, userid); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "保存成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
/// <summary> /// 更新 /// </summary> /// <param name="ID">主键</param> /// <param name="OrderNo">公司编号</param> /// <param name="UnitName">单位名称</param> /// <param name="name">负责人名称</param> /// <param name="phone">联系方式</param> /// <param name="address">地址</param> /// <param name="OrgID">所属网点</param> /// <param name="guid"></param> /// <returns></returns> public retValue UpdateByPK(int ID, string OrderNo, string UnitName, string name, string phone, string address, string OrgID, string guid = "") { retValue ret = new retValue(); string res = dal.UpdateByPK(ID, OrderNo, UnitName, name, phone, address, OrgID, guid); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "保存成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
/// <summary> /// 插入用户 /// </summary> /// <param name="userNo">用户编号</param> /// <param name="userName">名称</param> /// <param name="sex">性别,1男0女</param> /// <param name="userRole">角色</param> /// <param name="userOrg">用户所属机构</param> /// <param name="IDCard">证件号</param> /// <param name="Password">密码</param> /// <param name="PhoneNumber">电话</param> /// <param name="Address">地址</param> /// <param name="Email">邮箱</param> /// <param name="OPERATOR">操作者</param> /// <returns>成功返回空值,否则返回提示</returns> public retValue Insert(string userNo, string userName, string sex, string userRole, string chooseOrg, string IDCard, string Password, string PhoneNumber, string Address, string Email, string OPERATOR, int userlevel) { retValue ret = new retValue(); string res = dal.Insert(userNo, userName, sex, userRole, chooseOrg, IDCard, Password, PhoneNumber, Address, Email, OPERATOR, userlevel); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "保存成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
/// <summary> /// 根据主键获取用户信息 /// </summary> /// <param name="ID"></param> /// <returns>data为DataTable</returns> public retValue GetUserByPK(int ID) { retValue ret = new retValue(); DataTable dt = dal.GetUserByPK(ID); if (dt != null && dt.Rows.Count > 0) { ret.result = true; ret.data = dt; } else { ret.result = false; ret.reason = "未能查询到数据"; } return(ret); }
/// <summary> /// 根据用户编号更新数据 /// </summary> /// <param name="ID">流水号</param> /// <param name="userNo">用户编号</param> /// <param name="userName">名称</param> /// <param name="sex">性别,1男0女</param> /// <param name="userRole">角色</param> /// <param name="userOrg">用户所属机构</param> /// <param name="IDCard">证件号</param> /// <param name="userState">状态(0有效,1无效)</param> /// <param name="guid">唯一标识,每次修改数据会同时修改此列</param> /// <returns>成功返回空值,否则返回提示</returns> public retValue UpdateByPK(int ID, string userNo, string userName, string sex, string userRole, string userOrg, string IDCard, string userState, string guid, string Email, string PhoneNumber, string Password = "") { retValue ret = new retValue(); string res = dal.UpdateByPK(ID, userNo, userName, sex, userRole, userOrg, IDCard, userState, guid, Email, PhoneNumber, Password); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "保存成功"; } else { ret.result = false; ret.reason = res; } return(ret); }
/// <summary> /// 获取报刊信息 /// </summary> /// <param name="ID">编号</param> /// <param name="TYPEID">类型编号</param> /// <param name="NAME">名称</param> /// <param name="ISSN">ISSN</param> /// <param name="PUBLISHAREA">出版地</param> /// <param name="PUBLISHER">出版社</param> /// <param name="ADDPERSON">添加人</param> /// <param name="DocRegData_Begin">新增报刊时间范围,起始值</param> /// <param name="DocRegData_End">新增报刊时间范围,截止值</param> /// <returns></returns> public retValue GetDoc(string ID, string TYPEID, string NAME, string ISSN, string PUBLISHAREA, string PUBLISHER, string ADDPERSON, string DocRegData_Begin, string DocRegData_End, string BKDH) { retValue ret = new retValue(); DataTable dt = dal.GetDoc(ID, TYPEID, NAME, ISSN, PUBLISHAREA, PUBLISHER, ADDPERSON, DocRegData_Begin, DocRegData_End, BKDH); if (dt != null && dt.Rows.Count > 0) { ret.result = true; ret.data = dt; } else { ret.result = false; ret.reason = "未能查询到数据"; } return(ret); }
/// <summary> /// 插入报刊 /// </summary> /// <param name="Name">名称</param> /// <param name="ISSN">ISSN</param> /// <param name="TypeID">类型ID</param> /// <param name="PublishArea">出版地</param> /// <param name="Publisher">出版社</param> /// <param name="PublishYear">出版年</param> /// <param name="C200F">责任者</param> /// <param name="Price">单价,一个月的单价</param> /// <param name="PL">出版频率</param> /// <param name="BKDH">报刊代号</param> /// <param name="AddPerson">添加人</param> /// <returns>成功返回空值,否则返回提示</returns> public retValue Insert(string Name, string ISSN, string TypeID, string PublishArea, string Publisher, string Price, string PL, string BKDH, string AddPerson) { retValue ret = new retValue(); string res = dal.Insert(Name, ISSN, TypeID, PublishArea, Publisher, Price, PL, BKDH, AddPerson); if (string.IsNullOrEmpty(res)) { ret.result = true; ret.data = "操作成功"; } else { ret.result = false; ret.reason = res; } return(ret); }