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 ActionResult OrgInfos2(int limit, int page, string Province, string CompanyCity, string CompanyUnderCity, string CompanyUnderArea) { PageModel ret = new PageModel(); BLL.OrgInfoBLL _BLL = new OrgInfoBLL(); UserModel user = Session["UserModel"] as UserModel; 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; } ret = _BLL.GetOrgByParentID(OrgID._ToInt32(), limit, page, user.OrgID, user.Level); var js = JsonConvert.SerializeObject(ret); return(Content(js)); }
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)); }
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)); }
public ActionResult OrgInfo_AddEdits(string str) { retValue ret = new retValue(); BLL.OrgInfoBLL _BLL = new OrgInfoBLL(); JObject o = null; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string ID = o["ID"]._ToStrTrim(); string NAME = o["Name"]._ToStrTrim(); string OrgCode = o["OrgCode"]._ToStrTrim(); string Address = o["Address"]._ToStrTrim(); UserModel user = Session["UserModel"] as UserModel; //新增 if (string.IsNullOrEmpty(ID)) { string Province = o["Province"]._ToStrTrim(); string CompanyCity = o["CompanyCity"]._ToStrTrim(); string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim(); string CompanyUnderArea = o["CompanyUnderArea"]._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; } int level = 0; ret = _BLL.GetOrgByPK(OrgID._ToInt32()); if (ret.result) { level = ((DataTable)ret.data).Rows[0]["Level"]._ToInt32() + 1; } if (user.Level > level) { ret.result = false; ret.reason = "您不能添加当前级别的机构"; } else { ret = _BLL.insert(NAME, Address, OrgCode, OrgID._ToInt32(), level); } } //更新 else { int level = 0; ret = _BLL.GetOrgByPK(ID._ToInt32()); if (ret.result) { level = ((DataTable)ret.data).Rows[0]["Level"]._ToInt32(); if (user.Level > level) { ret.result = false; ret.reason = "您不能更新当前级别的机构"; } else { ret = _BLL.update(ID._ToInt32(), NAME, OrgCode, Address); } } } } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
//// <summary> /// 这里保存上传的文件到服务器上面 /// </summary> /// <param name="file">上传文件实例,名称应该和前台页面上的上传控件name属性一致</param> /// <returns></returns> public ActionResult Order_PL(HttpPostedFileBase file) { retValue ret = new retValue(); ret.result = true; if (file == null) { ret.result = false; ret.reason = "请选择上传文件!"; } else { PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel; int userid = userModel._ID; Random r = new Random(); var fileExt = System.IO.Path.GetExtension(file.FileName).Substring(1); var filename = DateTime.Now.ToString("yyyyMMddHHmmss") + r.Next(10000) + "." + fileExt; var filepath = System.IO.Path.Combine(Server.MapPath("~/Images"), filename); var savepath = "/Images/" + filename; file.SaveAs(filepath); BLL.OrderInfoBLL _bll = new OrderInfoBLL(); BLL.OrgInfoBLL _Org = new OrgInfoBLL(); DataTable dt = OpenFile(filepath); //删除文件 FileInfo fileInfo = new FileInfo(filepath); fileInfo.Delete(); if (dt == null || dt.Rows.Count == 0) { ret.result = false; ret.reason = "Excel中没有数据"; } else { int count = 0; SqlHelp dbhelper = new SqlHelp(); SqlConnection conn = new SqlConnection(dbhelper.SqlConnectionString); conn.Open(); using (SqlTransaction tran = conn.BeginTransaction()) { try { foreach (DataRow item in dt.Rows) { int orgid = _Org.GetIDByName(item["OrgName"]._ToStrTrim()); if (orgid == 0) { ret.result = false; ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据机构填写不正确"; break; } else if (string.IsNullOrEmpty(item["BKDH"]._ToStrTrim())) { ret.result = false; ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据报刊代号不能为空"; break; } else if (item["OrderNum"]._ToInt32() <= 0) { ret.result = false; ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订购数必须大于0"; break; } else if (item["OrderMonths"]._ToInt32() <= 0) { ret.result = false; ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订购月数必须大于0"; break; } else if (string.IsNullOrEmpty(item["Indate"]._ToStrTrim())) { ret.result = false; ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订购起始日期不能为空"; break; } else if (string.IsNullOrEmpty(item["OrderNo"]._ToStrTrim())) { ret.result = false; ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订户单位编号不能为空"; break; } else { ret = _bll.Insert(item["BKDH"]._ToStrTrim(), item["OrderNum"]._ToInt32(), item["OrderMonths"]._ToInt32(), item["Indate"]._ToStrTrim(), userid._ToStr(), 0, item["OrderNo"]._ToStrTrim(), item["UnitName"]._ToStrTrim(), item["Address"]._ToStrTrim(), item["Name"]._ToStrTrim(), item["Phone"]._ToStrTrim(), orgid._ToStr(), tran, userid._ToStr()); count++; if (!ret.result) { tran.Rollback(); return(Json(JsonConvert.SerializeObject(ret), JsonRequestBehavior.AllowGet)); } } } if (!ret.result) { tran.Rollback(); } else { tran.Commit(); ret.result = true; ret.data = "导入成功"; } } catch (Exception ex) { ret.result = false; ret.reason = ex.Message; tran.Rollback(); } } conn.Close(); } } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }