public JsonResult DeleteShops(string parameter) { var result = new JsonResult(); if (parameter == null || string.IsNullOrWhiteSpace(parameter)) { result.Data = "删除商品信息获取失败"; } else { try { JObject obj = JObject.Parse(parameter); string idStr = obj["IdStr"] == null ? "" : obj["IdStr"].ToString(); var shopsId = ""; if (!string.IsNullOrWhiteSpace(idStr) && idStr.Contains(",")) { shopsId = idStr.Remove(idStr.Length - 1, 1); } else { shopsId = idStr; } var listId = shopsId.Split(new char[] { ',' }).ToList(); result.Data = St_LogicHelper.DeleteShops(listId); } catch (Exception ex) { result.Data = false; } } return(result); }
public JsonResult SaveOutStorage(ST_OutStorage outStorage) { var result = new JsonResult(); if (outStorage == null) { result.Data = "获取出货信息失败"; } else { outStorage.O_ADDTIME = DateTime.Now; outStorage.O_ADDUSER = ((ST_SysAdmin)Session["sysAdmin"]).UserName; outStorage.O_SUMPRICE = outStorage.O_NUM * outStorage.O_PRICE; if (St_LogicHelper.SaveOutStorage(outStorage)) { result.Data = "success"; } else { result.Data = "出货信息保存失败"; } } return(result); }
public JsonResult SaveShops(ST_Shops shops) { var result = new JsonResult(); if (shops == null) { result.Data = "获取保存的商品信息失败"; } else { if (shops.ID == 0) { shops.S_INDATE = DateTime.Now; shops.S_SUMPRICE = shops.S_INPRICE * shops.S_SUMNUM; shops.EntityState = System.Data.EntityState.Added; } else { shops.EntityState = System.Data.EntityState.Modified; } if (St_LogicHelper.SaveStShops(shops)) { result.Data = "success"; } else { result.Data = "商品信息保存失败"; } } return(result); }
/// <summary> /// 添加进货 /// </summary> /// <param name="shopsId"></param> /// <returns></returns> public ActionResult AddInStorage(string shopsId) { var item = St_LogicHelper.GetShopsById(shopsId); if (item == null) { return(null); } var model = new ST_InStorage() { I_SHOPSID = item.ID, I_PRICE = item.S_INPRICE }; return(View(model)); }
public JsonResult Userlogin(string userName, string passWord, string validateCode, bool isRemember) { var result = new JsonResult(); var cookie = CookieService.GetCookie("Code"); //if (!validateCode.Equals(cookie)) //{ // result.Data = "验证码验证错误"; // return result; //} Session["sysAdmin"] = null; if (isRemember) { CookieService.SetCookie("uname", userName, 7); CookieService.SetCookie("upwd", passWord, 7); CookieService.SetCookie("isRemember", isRemember?"1":"0", 7); } else { CookieService.ClearCookie("uname"); CookieService.ClearCookie("upwd"); CookieService.ClearCookie("isRemember"); } ST_SysAdmin user = new ST_SysAdmin() { UserName = userName, UserPwd = PassWordService.MD5(passWord) }; var loginUser = St_LogicHelper.UserLogin(user); if (loginUser != null) { Session["sysAdmin"] = loginUser; result.Data = "success"; } else { result.Data = "用户名或密码错误"; } return(result); }
public JsonResult SaveInStorage(ST_InStorage inStorage) { var result = new JsonResult(); if (inStorage == null) { result.Data = "获取进货信息失败"; } else { inStorage.I_ADDTIME = DateTime.Now; inStorage.I_ADDUSER = ((ST_SysAdmin)Session["sysAdmin"]).UserName; inStorage.I_SUMPRICE = inStorage.I_NUM * inStorage.I_PRICE; if (St_LogicHelper.SaveInStorage(inStorage)) { result.Data = "success"; } else { result.Data = "进货信息保存失败"; } } return(result); }
public JsonResult GetOutStorageByPage() { var result = new JsonResult(); var start = Request.Form["start"]; //开始索引 var length = Request.Form["length"]; //页大小 var draw = Request.Form["draw"]; //原值返回 var search = Request.Form["search"]; //自定义查询条件 var shopsType = ""; //订单类型 var queryStr = ""; //搜索关键字 var querytime = ""; var pageIndex = (int)Math.Ceiling(Convert.ToInt32(start) * 1.0 / 10); if (!string.IsNullOrWhiteSpace(search)) { JObject obj = JObject.Parse(search); if (obj != null) { queryStr = obj["KeyWhere"] == null ? "" : obj["KeyWhere"].ToString(); shopsType = obj["shopsType"] == null ? "" : obj["shopsType"].ToString(); querytime = obj["querytime"] == null ? "" : obj["querytime"].ToString(); } } var SearchStr = new StringBuilder(); SearchStr.Append(" 1=1"); if (!string.IsNullOrWhiteSpace(querytime)) { var time = querytime.Split(new char[] { '至' }); if (time.Count() == 2) { SearchStr.Append(" and ST_OutStorage.O_AddTime>='" + DateTime.Parse(time[0] + " 00:00:00") + "'"); SearchStr.Append(" and ST_OutStorage.O_AddTime<='" + DateTime.Parse(time[1] + " 23:59:59") + "'"); } } if (!string.IsNullOrWhiteSpace(queryStr)) { SearchStr.Append(" and (ST_Shops.S_Code like '%" + queryStr + "%' or ST_Shops.S_Name like '%" + queryStr + "%')"); } if (!string.IsNullOrWhiteSpace(shopsType) && !shopsType.Equals("分类")) { SearchStr.Append(" and ST_Shops.S_Type='" + shopsType + "'"); } var pageCount = 0; var dt = St_LogicHelper.SelectByPages("ST_OutStorage,ST_Shops", "ST_Shops.S_TYPE,ST_Shops.S_CODE,ST_Shops.S_NAME,ST_Shops.S_BRAND,ST_Shops.S_UNIT,ST_OutStorage.O_Num,ST_OutStorage.O_Price,ST_OutStorage.O_SumPrice,ST_OutStorage.O_AddUser, ST_OutStorage.O_AddTime", "O_AddTime", true, Convert.ToInt32(length), pageIndex + 1, SearchStr.ToString(), "ID,O_ShopsId", "", out pageCount); List <ST_OutStorageView> list = new List <ST_OutStorageView>(); foreach (DataRow dr in dt.Rows) { list.Add(new ST_OutStorageView(dr)); } var resultObj = new { draw = Convert.ToInt32(draw), recordsTotal = pageCount, recordsFiltered = pageCount, data = list }; result.Data = resultObj; return(result); }
/// <summary> /// 分页获取商品数据 /// </summary> /// <returns></returns> public JsonResult GetShopsByPage() { var result = new JsonResult(); var start = Request.Form["start"]; //开始索引 var length = Request.Form["length"]; //页大小 var draw = Request.Form["draw"]; //原值返回 var search = Request.Form["search"]; //自定义查询条件 var shopsType = ""; //订单类型 var queryStr = ""; //搜索关键字 var querytime = ""; var pageIndex = (int)Math.Ceiling(Convert.ToInt32(start) * 1.0 / 10); if (!string.IsNullOrWhiteSpace(search)) { JObject obj = JObject.Parse(search); if (obj != null) { queryStr = obj["KeyWhere"] == null ? "" : obj["KeyWhere"].ToString(); shopsType = obj["shopsType"] == null ? "" : obj["shopsType"].ToString(); querytime = obj["querytime"] == null ? "" : obj["querytime"].ToString(); } } var SearchStr = new StringBuilder(); SearchStr.Append(" S_DelFlg=0 "); if (!string.IsNullOrWhiteSpace(querytime)) { var time = querytime.Split(new char[] { '至' }); if (time.Count() == 2) { SearchStr.Append(" and S_InDate>='" + DateTime.Parse(time[0] + " 00:00:00") + "'"); SearchStr.Append(" and S_InDate<='" + DateTime.Parse(time[1] + " 23:59:59") + "'"); } } if (!string.IsNullOrWhiteSpace(queryStr)) { SearchStr.Append(" and (S_Code like '%" + queryStr + "%' or S_Name like '%" + queryStr + "%')"); } if (!string.IsNullOrWhiteSpace(shopsType) && !shopsType.Equals("分类")) { SearchStr.Append(" and S_Type='" + shopsType + "'"); } var pageCount = 0; var list = new List <ST_Shops>(); list = St_LogicHelper.SelectByPagesShops(Convert.ToInt32(length), pageIndex + 1, SearchStr.ToString(), out pageCount); var resultObj = new { draw = Convert.ToInt32(draw), recordsTotal = pageCount, recordsFiltered = pageCount, data = list }; result.Data = resultObj; return(result); }