public ContentResult SearchSingle() { string locationId = GetParam("ID"); BLocation loc = lService.GetLocationById(Convert.ToInt32(locationId)); return(ReturnResult(loc)); }
public IHttpActionResult Put(int id, BLocation bLocation) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != bLocation.location_id) { return(BadRequest()); } db.Entry(bLocation).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!BLocationExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// 添加存储单元 /// </summary> /// <param name="location"></param> /// <returns></returns> public int AddLocation(BLocation location) { //添加存储单元 object id = lRepository.Insert(location); return(Convert.ToInt32(id)); }
public IHttpActionResult Get(int id) { BLocation bLocation = db.BLocations.Find(id); if (bLocation == null) { return(NotFound()); } return(Ok(bLocation)); }
public IHttpActionResult Post(BLocation bLocation) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.BLocations.Add(bLocation); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = bLocation.location_id }, bLocation)); }
/// <summary> /// 递归 /// </summary> /// <param name="parent"></param> /// <param name="orgs"></param> /// <returns></returns> private void GetLocationChild(BLocation parent, List <BLocation> orgs) { List <BLocation> children = orgs.Select(t => t).Where(o => o.ParentID == parent.ID).ToList(); if (children.Count > 0) { parent.Children.AddRange(children); foreach (BLocation child in children) { GetLocationChild(child, orgs); } } }
public string CheckLocation(string location, string title) { if (location == null || "".Equals(location)) { return(title + ERROR_NULL); } BLocation bLocation = new BLocation(); if (bLocation.Exists(location)) { return(""); } return(title + ERROR_EXIST); }
public IHttpActionResult Delete(int id) { BLocation bLocation = db.BLocations.Find(id); if (bLocation == null) { return(NotFound()); } db.BLocations.Remove(bLocation); db.SaveChanges(); return(Ok(bLocation)); }
/// <summary> /// 构建子节点 /// </summary> /// <param name="location"></param> /// <param name="parentTn"></param> public void BuildChildTree(BLocation location, TreeNode parentTn) { foreach (BLocation loc in location.Children) { TreeNode tn = new TreeNode(); tn.id = loc.ID.ToString(); tn.text = loc.LocationDesc; tn.name = loc.LocationCode; if (loc.Children.Count > 0) { BuildChildTree(loc, tn); } parentTn.children.Add(tn); } }
/// <summary> /// /// </summary> private void initLocation() { if (!string.IsNullOrEmpty(txtWarehouseCode.Text.Trim()) && !string.IsNullOrEmpty(txtProductCode.Text.Trim())) { BLocation bLocation = new BLocation(); DataSet ds = bLocation.GetList(" WAREHOUSE_CODE='" + txtWarehouseCode.Text.Trim() + "' and PRODUCT_CODE='" + txtProductCode.Text.Trim() + "'"); if (ds.Tables[0].Rows.Count > 0) { txtProduct_Group_Code.Text = CConvert.ToString(ds.Tables[0].Rows[0]["CODE"]); txtProduct_Group_Name.Text = CConvert.ToString(ds.Tables[0].Rows[0]["NAME"]); } } else { txtProduct_Group_Code.Text = ""; txtProduct_Group_Name.Text = ""; } }
/// <summary> /// 非空验证 /// </summary> /// <param name="location"></param> /// <returns></returns> public string CheckLocation(BLocation location) { if (string.IsNullOrWhiteSpace(location.LocationCode)) { return("存储单元编码不能为空."); } //if (location.OrgID < 1) //{ // return "组织机构不能为空."; //} if (location.ID > 0) { if (location.ID == location.ParentID) { return("上级存储单元不能选择自身."); } } return(string.Empty); }
public ContentResult Update() { ResultData <string> rt = new ResultData <string>(); BLocation locaiton = GetUpdate <BLocation>(); //非空验证和属性格式验证 string msg = lService.CheckLocation(locaiton); if (!string.IsNullOrEmpty(msg)) { rt.message = msg; rt.status = -1; return(ReturnResult(rt)); } locaiton.UpdateDate = DateTime.Now; locaiton.UpdateBy = this.CurrentUser.ID; //更新顶级仓库 BLocation pLocation = lService.GetLocationById(locaiton.ParentID); if (pLocation != null) { locaiton.TopLocationID = pLocation.TopLocationID; } //是否存在 if (lService.IsNotExits(locaiton, false)) { lService.UpdateLocation(locaiton); } else { rt.status = -1; rt.message = "存储单元已经存在."; } return(ReturnResult(rt)); }
/// <summary> /// 编辑存储单元 /// </summary> /// <param name="location"></param> /// <returns></returns> public bool UpdateLocation(BLocation location) { var oldEntity = lRepository.GetLocationById(location.ID); int oldOrgId = oldEntity.OrgID; DatabaseContext db = lRepository.DbCondext; try { db.BeginTransaction(); bool result = lRepository.Update(location); //如果修改了组织,下属的货区货位的组织也要跟着变 if (oldOrgId != location.OrgID) { db.Connection.Execute(string.Format("Update BLocation set OrgId={0} where ID<>{1} and TopLocationID={1}", location.OrgID, location.ID)); } db.CompleteTransaction(); return(result); } catch (Exception ex) { db.AbortTransaction(); throw ex; } }
public ContentResult Add() { ResultData <string> rt = new ResultData <string>(); BLocation location = GetAdd <BLocation>(); //非空验证和属性格式验证 string msg = lService.CheckLocation(location); if (!string.IsNullOrEmpty(msg)) { rt.message = msg; rt.status = -1; return(ReturnResult(rt)); } //判断是否子存储单元,添加顶级存储单元 if (location.ParentID > 0) { BLocation parent = lService.GetLocationById(location.ParentID); location.TopLocationID = parent.TopLocationID; location.LocationLevel = parent.LocationLevel + 1; ////如果是货位,默认货区的类型 //if (location.LocationLevel == 3) //{ // location.LocationClass = parent.LocationClass; //} } else { location.LocationLevel = 1; } //判断是否存在其他货位也是默认货位 //if (location.LocationLevel == 2) //{ // if (location.IsDefault > 0) // { // BLocation dftLocation = lService.GetDefaultLocation(location.ParentID, location.LocationClass); // if (dftLocation != null) // { // rt.status = -1; // rt.message = "当前仓库已经存在默认货区(" + dftLocation.LocationCode + ")"; // return ReturnResult(rt); // } // } //} //是否存在 if (lService.IsNotExits(location, false)) { location.CreateBy = this.CurrentUser.ID; location.CreateDate = DateTime.Now; location.UpdateDate = DateTime.Now; int locId = lService.AddLocation(location); //如果添加为仓库,则跟新顶级存储单元ID if (location.ParentID < 1) { location.ID = locId; location.TopLocationID = locId; lService.UpdateLocation(location); } } else { rt.status = -1; rt.message = "存储单元已经存在."; } return(ReturnResult(rt)); }
public override string[] doUpdateDB() { BaseLocationTable LocationTable = null; BLocation bLocation = new BLocation(); StringBuilder strError = new StringBuilder(); int successData = 0; int failureData = 0; string errorFilePath = ""; string backupFilePath = ""; //数据导入处理 foreach (DataRow dr in _csvDataTable.Rows) { StringBuilder str = new StringBuilder(); //编号 if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "CODE")))) { str.Append(CheckString(GetValue(dr, "CODE"), 20, "编号")); } else { str.Append("编号不能为空!"); } //名称 str.Append(CheckLenght(GetValue(dr, "NAME"), 100, "名称")); //状态 str.Append(CheckInt(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL_STATUS), 9, "状态")); if (str.ToString().Trim().Length > 0) { strError.Append(GetStringBuilder(dr, str.ToString().Trim())); failureData++; continue; } try { LocationTable = new BaseLocationTable(); LocationTable.CODE = CConvert.ToString(GetValue(dr, "CODE")); LocationTable.NAME = CConvert.ToString(GetValue(dr, "NAME")); LocationTable.STATUS_FLAG = CConvert.ToInt32(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL_STATUS)); LocationTable.CREATE_USER = _userInfo.CODE; LocationTable.LAST_UPDATE_USER = _userInfo.CODE; if (!bLocation.Exists(LocationTable.CODE)) { LocationTable.CREATE_DATE_TIME = DateTime.Now; LocationTable.LAST_UPDATE_TIME = DateTime.Now; bLocation.Add(LocationTable); } else { LocationTable.LAST_UPDATE_TIME = DateTime.Now; bLocation.Update(LocationTable); } successData++; } catch { strError.Append(GetStringBuilder(dr, " 数据导入失败,请与系统管理员联系!").ToString()); failureData++; } } //错误记录处理 if (strError.Length > 0) { errorFilePath = WriteFile(strError.ToString()); } //备份处理 backupFilePath = BackupFile(); return(new string[] { successData.ToString(), failureData.ToString(), errorFilePath, backupFilePath }); }
/// <summary> /// 判断是否存在 /// </summary> /// <param name="location"></param> /// <returns></returns> public bool IsNotExits(BLocation location, bool isAdd) { return(lRepository.IsNotExits(location, isAdd)); }