/// <summary>
/// 获取仓库相信
/// </summary>
/// <returns></returns>
public StorageBinResult GetWh_nameList()
{
StorageBinResult result = new StorageBinResult();
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
try
{
var list = db.Queryable <base_wh_warehouse>().Where(a => a.del_flag).OrderBy("wh_id DESC").ToList();
if (list.Count <= 0)
{
result.success = false;
result.Msg = "暂无仓库信息!";
return(result);
}
var list1 = "<option value=\"0\">请选择...</option>";
foreach (var item in list)
{
list1 += "<option value=\"" + item.wh_id + "\">" + item.wh_name + "</option>";
}
result.success = true;
result.Msg = list1;
return(result);
}
catch (Exception ex)
{
result.success = false;
result.Msg = "获取仓库信息失败!";
return(result);
}
}
}
public ActionResult GetWh_nameList()
{
StorageBinResult com = new StorageBinResult();
try
{
com = _service.GetWh_nameList();
return Json(com);
}
catch (Exception ex)
{
com.Msg = ex.ToString();
com.success = false;
return Json(com);
}
}
public ActionResult SaveInOut(Guid? id, Decimal count, int type)
{
StorageBinResult com = new StorageBinResult();
try
{
com = _service.StockInOut(id, count, type);
return Json(com);
}
catch (Exception ex)
{
com.Msg = ex.ToString();
com.success = false;
return Json(com);
}
}
public ActionResult Save_sku(Int64 wh_id, Int64 locat_id, string sku, int skucount)
{
StorageBinResult com = new StorageBinResult();
try
{
com = _service.Save_sku(wh_id, locat_id, sku, skucount);
return Json(com);
}
catch (Exception ex)
{
com.Msg = ex.ToString();
com.success = false;
return Json(com);
}
}
public ActionResult Save(base_location model)
{
StorageBinResult com = new StorageBinResult();
try
{
com = _service.Save(model);
return Json(com);
}
catch (Exception ex)
{
com.Msg = ex.ToString();
com.success = false;
return Json(com);
}
}
public ActionResult Getpage(string pagenum, string onepagecount, long? wh_id, string locat_code, string sku_code, int ty_pe)
{
StorageBinResult com = new StorageBinResult();
if (!Regex.IsMatch(pagenum, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(pagenum))
{
com.Msg = "页数不正确";
com.success = false;
return Json(com);
}
if (!Regex.IsMatch(onepagecount, @"(?i)^[0-9a-z\u4e00-\u9fa5]+$") && !string.IsNullOrEmpty(onepagecount))
{
com.Msg = "每页数量不正确";
com.success = false;
return Json(com);
}
int totil = 0;
int totilpage = 0;
string exmsg = string.Empty;
List<StorageBinModel> mylist = new List<StorageBinModel>();
if (ty_pe == 1)
{
mylist = _service.GetStorageBinList(Convert.ToInt32(pagenum), Convert.ToInt32(onepagecount), out totil, out totilpage, out exmsg, wh_id, locat_code);
}
else if (ty_pe == 2)
{
mylist = _service.GetStorageBinInOutList(Convert.ToInt32(pagenum), Convert.ToInt32(onepagecount), out totil, out totilpage, out exmsg, wh_id, locat_code, sku_code);
}
if (!string.IsNullOrEmpty(exmsg))
{
com.Msg = exmsg;
com.success = false;
return Json(com);
}
else
{
StorageBinViewModel mylistview = new StorageBinViewModel();
mylistview.supplist = mylist;
mylistview.totil = totil.ToString();
mylistview.totilcount = totilpage.ToString();
com.DataResult = mylistview;
com.success = true;
com.ty_pe = ty_pe;
return Json(com);
}
}
public ActionResult GetStorageBinEList(long? wh_id, long? locat_id)
{
StorageBinResult com = new StorageBinResult();
string exmsg = string.Empty;
List<StorageBinModel> mylist = _service.GetStorageBinEList(out exmsg, wh_id, locat_id);
if (!string.IsNullOrEmpty(exmsg))
{
com.Msg = exmsg;
com.success = false;
return Json(com);
}
else
{
StorageBinViewModel mylistview = new StorageBinViewModel();
mylistview.supplist = mylist;
com.DataResult = mylistview;
com.success = true;
return Json(com);
}
}
/// <summary>
/// 修改 添加的方法
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public StorageBinResult Save(base_location model)
{
bool rstNum = false;
StorageBinResult result = new StorageBinResult();
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
#region 判断
if (model == null)
{
result.success = false;
result.Msg = "请填写信息!";
return(result);
}
if (model.wh_id == 0)
{
result.success = false;
result.Msg = "请选择仓库!";
return(result);
}
if (string.IsNullOrWhiteSpace(model.locat_code))
{
result.success = false;
result.Msg = "请填写库位号!";
return(result);
}
#endregion
if (model.locat_id > 0)
{
}
else
{
var base_shop = db.Queryable <base_location>().Where(c => c.del_flag && c.locat_code == model.locat_code).ToList();
if (base_shop.Count > 0)
{
result.success = false;
result.Msg = "该仓库已存在的库位号，操作失败!";
return(result);
}
model.remark = model.locat_code;
model.locat_status = true;
model.locat_type = 2;
model.create_time = DateTime.Now;
model.create_user_id = LoginUser.Current.user_id;
model.del_flag = true;
model.del_user_id = 0;
model.del_time = DateTime.Now;
model.edit_time = DateTime.Now;
model.edit_user_id = 0;
var id = db.Insert <base_location>(model);
if (id.ObjToInt() > 0)
{
rstNum = true;
}
}
if (rstNum)
{
result.success = true;
result.URL = "/StorageBin/Index";
result.Msg = "操作成功";
return(result);
}
else
{
result.success = false;
result.Msg = "操作失败";
return(result);
}
}
}
public StorageBinResult Save_sku(Int64 wh_id, Int64 locat_id, string sku, int skucount)
{
bool rstNum = false;
bool rstNums = false;
StorageBinResult result = new StorageBinResult();
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
db.BeginTran();
if (wh_id == 0 || locat_id == 0)
{
db.RollbackTran();
result.success = false;
result.Msg = "参数错误!";
return(result);
}
if (skucount <= 0)
{
db.RollbackTran();
result.success = false;
result.Msg = "请填写正确的数量!";
return(result);
}
if (string.IsNullOrEmpty(sku))
{
db.RollbackTran();
result.success = false;
result.Msg = "请填写sku!";
return(result);
}
var list = db.Queryable <base_prod_code>().Where(a => a.del_flag && a.sku_code == sku).FirstOrDefault();
if (list == null)
{
db.RollbackTran();
result.success = false;
result.Msg = "系统中不存在的sku!";
return(result);
}
var wh_stock = db.Queryable <base_wh_stock>().Where(a => a.del_flag && a.wh_id == wh_id && a.location_id == locat_id && a.code_id == list.code_id).FirstOrDefault();
if (wh_stock == null)
{
var _supp_rel = db.Queryable <base_prod_supp_rel>().Where(a => a.del_flag && a.prod_id == list.prod_id).ToList();
long suppid = _supp_rel.Find(b => b.lev_purch == _supp_rel.Min(s => s.lev_purch)).supp_id;
base_wh_stock _stock = new base_wh_stock();
_stock.prod_id = list.prod_id;
_stock.occupied_qty = 0;
_stock.pallet_id = 0;
_stock.purchase_price = 0;
_stock.remark = "库存采购";
_stock.reserve_qty = 0;
_stock.service_life = "";
_stock.stock_barcode = "";
_stock.stock_class = 3;
_stock.stock_code = "1";
_stock.stock_qty = skucount;
_stock.stock_status = true;
_stock.retrieval_time = DateTime.Now;
_stock.storage_time = DateTime.Now;
_stock.supplier_id = suppid;
_stock.using_state = 1;
_stock.wh_id = 1;
_stock.location_id = locat_id;
_stock.locking_qty = 0;
_stock.area_id = 0;
_stock.asset_class_id = 0;
_stock.code_id = list.code_id;
_stock.consignor_id = 0;
_stock.create_time = DateTime.Now;
_stock.create_user_id = LoginUser.Current.user_id;
_stock.del_flag = true;
_stock.del_user_id = 0;
_stock.edit_user_id = 0;
_stock.del_time = DateTime.Now;
_stock.edit_time = DateTime.Now;
_stock.stock_id = Guid.NewGuid();
var id = db.Insert <base_wh_stock>(_stock);
if (id.ObjToBool())
{
rstNums = true;
}
}
else
{
rstNums = db.Update <base_wh_stock>(new { stock_qty = wh_stock.stock_qty + skucount }, s => s.stock_id == wh_stock.stock_id);
}
if (rstNums)
{
db.CommitTran();
result.success = true;
result.Msg = "操作成功";
return(result);
}
else
{
db.RollbackTran();
result.success = false;
result.Msg = "操作失败";
return(result);
}
}
}
/// <summary>
/// 上下架
/// </summary>
/// <param name="id"></param>
/// <param name="count"></param>
/// <param name="state"></param>
/// <returns></returns>
public StorageBinResult StockInOut(Guid?id, Decimal count, int state)
{
bool rstNum = false;
bool rstNums = false;
StorageBinResult result = new StorageBinResult();
using (var db = SugarDao.GetInstance(LoginUser.GetConstr()))
{
db.BeginTran();
if (string.IsNullOrWhiteSpace(id.ToString()) || state == 0)
{
db.RollbackTran();
result.success = false;
result.Msg = "参数错误!";
return(result);
}
if (count <= 0)
{
db.RollbackTran();
result.success = false;
result.Msg = "请填写正确的数量!";
return(result);
}
var list = db.Queryable <base_wh_stock>().InSingle(id.Value);
if (list == null)
{
db.RollbackTran();
result.success = false;
result.Msg = "不存在的库存信息,操作失败!";
return(result);
}
if (!list.del_flag)
{
db.RollbackTran();
result.success = false;
result.Msg = "已删除的库存信息,操作失败!";
return(result);
}
Decimal stock_qty = list.stock_qty;
if (state == 1)
{
list.stock_qty = list.stock_qty + count;
rstNum = db.Update <base_wh_stock>(list);
if (rstNum)
{
db.Update <base_wh_stock>(new { stock_qty = list.stock_qty }, s => s.stock_id == id);
base_wh_stock_inout model = new base_wh_stock_inout();
model.add_time = DateTime.Now;
model.last_count = list.stock_qty;
model.oper_count = count;
model.oper_type = state;
model.pre_count = stock_qty;
model.user_id = LoginUser.Current.user_id;
model.user_name = LoginUser.Current.real_name;
model.stock_id = id.Value;
var issuc = db.Insert <base_wh_stock_inout>(model);
if (issuc.ObjToInt() > 0)
{
rstNums = true;
}
}
}
else if (state == 2)
{
if (stock_qty < count)
{
db.RollbackTran();
result.success = false;
result.Msg = "下架数量不得大于商品数量,操作失败!";
return(result);
}
list.stock_qty = list.stock_qty - count;
rstNum = db.Update <base_wh_stock>(list);
if (rstNum)
{
db.Update <base_wh_stock>(new { stock_qty = list.stock_qty }, s => s.stock_id == id);
base_wh_stock_inout model = new base_wh_stock_inout();
model.add_time = DateTime.Now;
model.last_count = list.stock_qty;
model.oper_count = count;
model.oper_type = state;
model.pre_count = stock_qty;
model.user_id = LoginUser.Current.user_id;
model.user_name = LoginUser.Current.real_name;
model.stock_id = id.Value;
var issuc = db.Insert <base_wh_stock_inout>(model);
if (issuc.ObjToInt() > 0)
{
rstNums = true;
}
}
}
if (rstNums && rstNum)
{
db.CommitTran();
result.success = true;
result.Msg = "操作成功";
return(result);
}
else
{
db.RollbackTran();
result.success = false;
result.Msg = "操作失败";
return(result);
}
}
}
