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);
}
