public JsonResult GetSelectTreeID(StoreTreeNameRequests request, FormCollection collection)
{
bool isParent = bool.Parse(collection["isParent"]);
var dataString = collection["id"].ToString();
this.treeID = dataString;
request.treeID = new Guid(dataString);
request.PageSize = 100;
//Guid id = new Guid(dataString);
this.TempData["treeid"] = dataString;
if (!isParent)
{
ModelState.Clear();
var result = this.StoreService.GetNodeProperty(request);
ViewData.ModelState.Remove("userPwd");
ModelState.AddModelError("userPwd", "请输入密码aaaaaaaaaaaaaaa！");
List <DictionaryProperty> resultList = new List <DictionaryProperty>();
foreach (DictionaryProperty dp in result)
{
resultList.Add(dp);
}
return(Json(resultList, JsonRequestBehavior.AllowGet));
}
else
{
JsonResult json = new JsonResult
{
Data = "ParentNode"
};
return(Json(json));
}
}
public PartialViewResult Delete(string ids, FormCollection collection)
{
string[] strarr = ids.Split(',');
List <Guid> dellist = new List <Guid>();
foreach (var i in strarr)
{
if (i.Length == 36)
{
Guid delID = new Guid(i);
dellist.Add(delID);
}
}
this.StoreService.DeleteProperty(dellist);
string id = collection["treeItemID"].ToString();
Guid dpid = new Guid(id);
StoreTreeNameRequests request = new StoreTreeNameRequests();
request.treeID = dpid;
request.PageSize = 500;
var model = this.StoreService.GetNodeProperty(request);
return(PartialView("_DPropertyPartialPage", model));
}
public PartialViewResult AddProperty(StoreTreeNameRequests request, FormCollection collection)
{
var model = new DictionaryProperty();
this.TryUpdateModel <DictionaryProperty>(model);
string id = null;
if (this.TempData.ContainsKey("treeid"))
{
id = this.TempData["treeid"].ToString();
//TempData.Remove("treeid");
request.treeID = new Guid(id.ToString());
}
if (id != null)
{
Guid treeid = new Guid(id);
Guid keyid = Guid.NewGuid();
model.leaf_id = treeid;
model.dpid = keyid;
}
this.StoreService.SaveDictionaryProperty(model);
//Dictionary<string, string> dp = new Dictionary<string, string>();
//dp.Add("clmc", model.clmc);
//dp.Add("pm", model.pm);
//dp.Add("mf", model.mf);
//dp.Add("js", model.js);
request.PageSize = 500;
var result = this.StoreService.GetNodeProperty(request);
return(PartialView("_DPropertyPartialPage", result));
}
public ActionResult GetID(StoreTreeNameRequests request)
{
var dataString = "8b0bdde6-7f59-4dc2-acc5-6216dfdc973d";
request.treeID = new Guid(dataString);
//Guid id = new Guid(dataString);
this.TempData["treeid"] = dataString;
var result = this.StoreService.GetNodeProperty(request);
return(View(result));
}
/// <summary>
/// 获取节点属性
/// </summary>
/// <param name="id">节点ID</param>
/// <returns></returns>
public IEnumerable <DictionaryProperty> GetNodeProperty(StoreTreeNameRequests request)
{
request = request ?? new StoreTreeNameRequests();
using (var dbContext = new StoreDbContext())
{
IQueryable <DictionaryProperty> dps = dbContext.DictionaryProperty;
if (request.treeID != null)
{
dps = dps.Where(u => u.leaf_id == request.treeID);
}
return(dps.OrderBy(u => u.CreateTime).ToPagedList(request.PageIndex, request.PageSize));
}
}
public PartialViewResult EditProperty(StoreTreeNameRequests request, FormCollection collection)
{
string id = collection["dpid"].ToString();
Guid dpid = new Guid(id);
var model = this.StoreService.GetDictionaryProperty(dpid);
this.TryUpdateModel <DictionaryProperty>(model);
this.StoreService.SaveEditProperty(model);
string leafid = model.leaf_id.ToString();
request.treeID = new Guid(leafid);
request.PageSize = 500;
var result = this.StoreService.GetNodeProperty(request);
return(PartialView("_DPropertyPartialPage", result));
}
public PartialViewResult DPropertyPartialPage(StoreTreeNameRequests request, FormCollection collection)
{
bool isParent = bool.Parse(collection["isParent"]);
var dataString = collection["id"].ToString();
this.treeID = dataString;
request.treeID = new Guid(dataString);
request.PageSize = 500;
//Guid id = new Guid(dataString);
this.TempData["treeid"] = dataString;
if (!isParent)
{
var result = this.StoreService.GetNodeProperty(request);
return(PartialView("_DPropertyPartialPage", result));
}
else
{
return(PartialView("_DPropertyPartialPage"));
}
}
public ActionResult ReturnOrder(FormCollection collection)
{
if (collection.AllKeys.Contains("DictionaryProperty.dpid"))
{
StoreTableRequest request = new StoreTableRequest();
request.PageSize = 1000;
request.Gid = new Guid(collection["DictionaryProperty.dpid"]);
int OutProductNumber = int.Parse(collection["OutBoundCount"]); //出库订单件数
var result = this.StoreService.GetStoreList(request);
//获取订单下所有材料
StoreTreeNameRequests stnRequest = new StoreTreeNameRequests();
stnRequest.PageSize = 1000;
stnRequest.treeID = request.Gid;
var clResultList = this.StoreService.GetNodeProperty(stnRequest);
//循环材料列表，如果在StoreTable中存在更新其数量，如果不在插入数据
foreach (DictionaryProperty dp in clResultList)
{
StoreTable st = new StoreTable();
st.number = 0;
st.number = st.number + (dp.js.Value * Convert.ToDecimal(OutProductNumber));
st.store_item_id = dp.dpid;
InBoundRecord ibr = new InBoundRecord();
//插入数据到入库记录表
ibr.inbound_id = st.store_item_id;
ibr.rkid = Guid.NewGuid();
ibr.number = dp.js.Value * Convert.ToDecimal(OutProductNumber);
ibr.boundtype = "还库材料";
ibr.khmc = this.StoreService.GetParentNameByLeafID(dp.leaf_id.Value);
this.StoreService.InsertInboundRecord(ibr);
this.StoreService.InsertStoreItem(st);
}
}
return(this.RefreshParent());
}
public ActionResult Create(FormCollection collection)
{
if (collection.AllKeys.Contains("DictionaryProperty.dpid"))
{
StoreTableRequest request = new StoreTableRequest();
request.PageSize = 10000;
request.Gid = new Guid(collection["DictionaryProperty.dpid"]);
int OutProductNumber;
if (!int.TryParse(collection["OutBoundCount"], out OutProductNumber))
{
var model = new StoreTable();
return(View("OutBoundEdit", model));
}
var lydw = collection["employment"];
///
var result = this.StoreService.GetStoreList(request);
Guid tempid = new Guid();//订单ID，出库记录表用
//获取订单下所有材料
StoreTreeNameRequests stnRequest = new StoreTreeNameRequests();
stnRequest.PageSize = 1000;
stnRequest.treeID = request.Gid;
var dpLists = this.StoreService.GetNodeProperty(stnRequest);
foreach (DictionaryProperty dp in dpLists)
{
var storeItem = this.StoreService.ExistDPInStore(dp);
tempid = dp.leaf_id.Value;
//判断store里是否有dp
if (storeItem == null)
{
StoreTable st = new StoreTable();
st.number = 0;
st.number = st.number - (dp.js.Value * Convert.ToDecimal(OutProductNumber));
st.store_item_id = dp.dpid;
InBoundRecord ibr = new InBoundRecord();
//插入数据到入库记录表
ibr.inbound_id = st.store_item_id;
ibr.rkid = Guid.NewGuid();
ibr.number = dp.js.Value * Convert.ToDecimal(OutProductNumber);
ibr.boundtype = "出库材料";
ibr.employment = lydw;
ibr.khmc = this.StoreService.GetParentNameByLeafID(dp.leaf_id.Value);
this.StoreService.InsertInboundRecord(ibr);
//出库
this.StoreService.InsertStoreItem(st);
}
else//有StoreItem
{
storeItem.number = storeItem.number - (dp.js.Value * Convert.ToDecimal(OutProductNumber));
InBoundRecord ibr = new InBoundRecord();
//插入数据到入库记录表
ibr.inbound_id = storeItem.store_item_id;
ibr.rkid = Guid.NewGuid();
ibr.number = dp.js.Value * Convert.ToDecimal(OutProductNumber);
ibr.boundtype = "出库材料";
ibr.employment = lydw;
ibr.khmc = this.StoreService.GetParentNameByLeafID(storeItem.DictionaryProperty.leaf_id.Value);
this.StoreService.InsertInboundRecord(ibr);
//出库
this.StoreService.OutBoundItem(storeItem);
}
//
}
//插入到出库记录表
OutBoundRecord obr = new OutBoundRecord();
obr.ckid = Guid.NewGuid();
obr.node_id = tempid;
obr.employment = lydw;
obr.number = OutProductNumber;
this.StoreService.InsertOutBoundRecord(obr);
}
return(this.RefreshParent());
}
/// <summary>
/// EXCEL材料导入
/// </summary>
/// <param name="request"></param>
/// <param name="Filedata"></param>
/// <returns></returns>
public PartialViewResult UploadFile(StoreTreeNameRequests request, HttpPostedFileBase Filedata, string treeidt)
{
// 如果没有上传文件
if (Filedata == null ||
string.IsNullOrEmpty(Filedata.FileName) ||
Filedata.ContentLength == 0)
{
//return this.HttpNotFound();
}
// 保存到 ~/photos 文件夹中，名称不变
string filename = System.IO.Path.GetFileName(Filedata.FileName);
string virtualPath =
string.Format("~/UploadFiles/{0}", filename);
// 文件系统不能使用虚拟路径
string path = this.Server.MapPath(virtualPath);
Filedata.SaveAs(path);
var model = new DictionaryProperty();
string id = null;
if (this.TempData.ContainsKey("treeid"))
{
id = this.TempData["treeid"].ToString();
//TempData.Remove("treeid");
request.treeID = new Guid(id.ToString());
}
if (treeidt != null)
{
Guid treeid = new Guid(treeidt);
request.treeID = treeid;
model.leaf_id = treeid;
}
DataTable dt = this.StoreService.ReadExcel(path);
foreach (DataRow row in dt.Rows)
{//判断exel数据异常返回，不存数据
var clmc = row[0].ToString();
var pm = row[1].ToString();
var mf = row[2].ToString();
if (row[3].ToString() == "" || row[3].ToString() == null)
{
row[3] = 1;
}
var temp = decimal.Parse(row[3].ToString());
}
foreach (DataRow row in dt.Rows)
{
Guid keyid = Guid.NewGuid();
model.dpid = keyid;
model.clmc = row[0].ToString();
model.pm = row[1].ToString();
model.mf = row[2].ToString();
model.js = decimal.Parse(row[3].ToString());
this.StoreService.SaveDictionaryProperty(model);
}
//Dictionary<string, string> dp = new Dictionary<string, string>();
//dp.Add("clmc", model.clmc);
//dp.Add("pm", model.pm);
//dp.Add("mf", model.mf);
//dp.Add("js", model.js);
request.PageSize = 500;
var result = this.StoreService.GetNodeProperty(request);
return(PartialView("_DPropertyPartialPage", result));
}
public ActionResult Index(StoreTreeNameRequests request)
{
var result = this.StoreService.GetNodeProperty(request);
return(View(result));
}
