public NewsfeedEditorController(IOptions <StorageSettings> options, ITextAssetsRepository textRepository, INewsfeedRepository repo) { _repo = repo; _textRepo = textRepository; _storageFacade = new StorageFacade(options); }
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e) { DataGridItem item = this.DataGrid1.SelectedItem; string strAssID = item.Cells[0].Text.Trim(); OperLog operLog = new OperLog(); operLog.cnvcOperType = "添加关联分货单"; operLog.cnvcOperID = this.oper.strLoginID; operLog.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.AddDeptStorageEnterDetail(operLog, this.txtRdID.Text.Trim(), strAssID, this.ddlDept.SelectedValue); if (ret > 0) { this.Popup("添加关联分货单成功!"); } else { this.Popup("添加关联分货单失败!"); } this.DataGrid1.DataSource = null; this.DataGrid1.DataBind(); this.DBBind(); }
private void btnCheckOk_Click(object sender, System.EventArgs e) { if (this.txtCheckNo.Text.Trim() == "" || this.txtCheckNo.Text.Trim().Length != 8) { this.Popup("盘点序号不正确,请重试!"); return; } if (this.Datagrid2.Items.Count <= 0) { this.Popup("无任何盘点存货记录!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "仓库库存清零盘点"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.StorageCheckClearConfirm(ol, this.txtCheckNo.Text.Trim(), this.ddlWhouse.SelectedValue, this.ddlDept.SelectedValue, this.oper.strOperName); if (ret > 0) { this.Popup("仓库库存盘点确认更新库存成功!"); this.DBBind(); } else { this.Popup("仓库库存盘点确认更新库存失败!"); } }
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e) { DataGridItem item = this.DataGrid1.SelectedItem; string strselsql = "select " + this.txtRdID.Text.Trim() + ",'" + item.Cells[1].Text.Trim() + "'," + item.Cells[0].Text.Trim() + ",cnvcProviderID,cnvcInvCode,0,cnnPrice,0,0,cnvcGroupCode,cnvcComunitCode,cnvcBatch,'0','',cndMdate,cnnMassDate,cnvcMassUnit,cndExpDate"; strselsql += " from tbRdRecordDetail where cnnAutoID=" + item.Cells[0].Text.Trim() + " and cnvcPoID='" + item.Cells[1].Text.Trim() + "' and cnvcProviderID='" + item.Cells[4].Text.Trim() + "' and cnvcInvCode='" + item.Cells[6].Text.Trim() + "'"; OperLog operLog = new OperLog(); operLog.cnvcOperType = "添加采购退货品"; operLog.cnvcOperID = this.oper.strLoginID; operLog.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.AddPoStockReturnDetail(operLog, strselsql); if (ret > 0) { this.Popup("添加退货品成功!"); } else { this.Popup("添加退货品失败!"); } this.DataGrid1.DataSource = null; this.DataGrid1.DataBind(); this.DBBind(); }
private void Awake() { DontDestroyOnLoad(gameObject); game = GetComponent <Game>(); level = GetComponent <Level>(); levelFiles = GetComponent <LevelFiles>(); IStorage storage = new StorageFacade(); game.Init(storage); level.Init(storage); levelFiles.Init(storage); eventsCentre = EventsCentre.GetInstance(); eventsCentre.Subscribe(new Topic("GameStart"), this, NewGame); eventsCentre.Subscribe(new Topic("GameRestart"), this, RestartGame); eventsCentre.Subscribe(new Topic("GameExit"), this, ExitGame); eventsCentre.Subscribe(new Topic("LevelSave"), this, SaveLevel); eventsCentre.Subscribe(new Topic("LevelEnd"), this, NextLevel); eventsCentre.Subscribe(new Topic("FileDelete"), this); eventsCentre.Subscribe(new Topic("FileOverride"), this); eventsCentre.Subscribe(new Topic("FileLoad"), this); eventsCentre.Subscribe(new Topic("UnlockedLevelsCountRequest"), this); }
private static IStorageFacade CreateStorageFacade(StorageAccountConfiguration description) { if (!string.IsNullOrWhiteSpace(description.Token)) { return(StorageFacade.FromToken( description.Name, description.Container, description.Folder, description.Token)); } else if (!string.IsNullOrWhiteSpace(description.TokenPath)) { throw new NotImplementedException(); } else if (!string.IsNullOrWhiteSpace(description.Key)) { return(StorageFacade.FromKey( description.Name, description.Container, description.Folder, description.Key)); } else if (!string.IsNullOrWhiteSpace(description.KeyPath)) { throw new NotImplementedException(); } else { throw new NotSupportedException(); } }
public bool Delete(int id) { var technique = _context.Techniques.Where(t => t.ID == id).Include(t => t.Name).FirstOrDefault(); if (technique != null) { try { var storageFacade = new StorageFacade(_storageSettings); var imageUris = _context.ArtPieces.Where(ap => ap.Technique.ID == technique.ID).Select(ap => ap.ImageUri).ToList(); var asset = _context.TextAssets.Where(ta => ta.Id == technique.Name.Id).FirstOrDefault(); _context.Techniques.Remove(technique); if (asset != null) { _context.TextAssets.Remove(asset); } foreach (var imageUri in imageUris) { storageFacade.DeleteImageBlob(imageUri); } _context.SaveChanges(); return(true); } catch (Exception ex) { if (ex is DbUpdateException || ex is DbUpdateConcurrencyException) { return(false); } throw; } } return(false); }
private void Datagrid2_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "ReStop") { string strAutoID = e.Item.Cells[0].Text.Trim(); if (strAutoID == "") { this.Popup("库存记录标识错误,请重试!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "库存解冻"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.UpdateCurrentStockReStop(ol, strAutoID); if (ret > 0) { this.Popup("库存解冻成功!"); this.DBBind(); } else { this.Popup("库存解冻失败!"); } } }
public GalleryEditorController(IOptions <StorageSettings> storageSettings, IGalleryRepository repo, ITextAssetsRepository textRepo, ITechniqueRepository techniqueRepo) { _galleryRepo = repo; _techniqueRepo = techniqueRepo; _storageSettings = storageSettings; _textRepo = textRepo; _storageFacade = new StorageFacade(storageSettings); _factory = new ArtPieceFactory(_galleryRepo, _textRepo, _techniqueRepo); }
private void btAdd_Click(object sender, System.EventArgs e) { strArriveDate = Request.Form["txtArvDate"].ToString(); if (strArriveDate == "" || strArriveDate == null) { this.Popup("到货时间不能为空,请重新选择时间!"); return; } Entity.RdRecord rd = new RdRecord(); rd.cnvcCode = this.txtEnterCode.Text.Trim(); rd.cnvcRdCode = "RD001"; rd.cnvcRdFlag = "0"; rd.cnvcIsLsQuery = this.ddlIsLsQuery.SelectedValue; rd.cnvcWhCode = this.ddlWhouse.SelectedValue; rd.cnvcDepID = this.ddlDeptID.SelectedValue; rd.cnvcOperName = this.oper.strOperName; rd.cnvcCusCode = ""; //rd.cnvcProBatch=""; rd.cnvcComments = this.txtComments.Text.Trim(); rd.cnvcMaker = this.oper.strOperName; //rd.cnvcMPoCode=""; rd.cnvcShipAddress = this.txtShipAddress.Text.Trim(); rd.cndARVDate = DateTime.Parse(strArriveDate); rd.cnvcARVAddress = this.txtArvAddress.Text.Trim(); rd.cnvcState = "0"; if (rd.cnvcCode == "" || rd.cnvcCode.Length != 13) { this.Popup("采购入库单号不正确!"); return; } if (rd.cnvcWhCode == "") { this.Popup("仓库不能为空!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "添加采购入库主单"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.AddRdRecordCom("RD001", ol, rd); if (ret > 0) { this.Popup("添加采购入库单内容成功!"); } else { this.Popup("添加采购入库单内容失败!"); } }
private void btMod_Click(object sender, System.EventArgs e) { strLostDate = Request.Form["txtLostDate"].ToString(); if (strLostDate == "" || strLostDate == null) { this.Popup("损耗时间不能为空,请重新选择时间!"); return; } if (this.txtAddCount.Text.Trim() == "" || this.txtReduceCount.Text.Trim() == "") { this.Popup("调增量和调减量不能为空!"); return; } Entity.LostSerial ls = new LostSerial(); ls.cnnLostSerialNo = int.Parse(this.txtSerialNo.Text.Trim()); ls.cnnAddCount = Math.Round(decimal.Parse(this.txtAddCount.Text.Trim()), 2); ls.cnnReduceCount = Math.Round(decimal.Parse(this.txtReduceCount.Text.Trim()), 2); ls.cndLostDate = DateTime.Parse(strLostDate); ls.cnvcComments = this.txtComments.Text.Trim(); ls.cnvcOperID = this.oper.strLoginID; if (ls.cnnLostSerialNo.ToString() == "") { this.Popup("损耗流水不正确!"); return; } string strsql = "select count(*) from tbLostSerial a,tbCurrentStock b,tbComputationUnit c where a.cnnLostSerialNo=" + ls.cnnLostSerialNo.ToString() + " and a.cnvcInvCode=b.cnvcInvCode and a.cnvcWhCode=b.cnvcWhCode"; strsql += " and convert(char(8),a.cndMdate,112)=convert(char(8),b.cndMdate,112) and convert(char(8),a.cndExpDate,112)=convert(char(8),b.cndExpDate,112)"; strsql += " and a.cnvcComunitCode=c.cnvcComunitCode and a.cnnLostCount+a.cnnAddCount-a.cnnReduceCount>(b.cnnQuantity*c.cniChangRate)"; DataTable dterrcount = Helper.Query(strsql); if (dterrcount.Rows.Count > 0) { this.Popup("损耗数量不能大于库存数量!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "修改过期损耗"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.UpdateLostSerial(ol, ls); if (ret > 0) { this.Popup("修改过期损耗成功!"); } else { this.Popup("修改过期损耗失败!"); } }
private void Datagrid2_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "SelectEnter") { if (e.Item.Cells[15].Text.Trim() == "" || e.Item.Cells[15].Text.Trim() == " ") { this.Popup("请填写生产日期!"); return; } if (e.Item.Cells[17].Text.Trim() == "" || e.Item.Cells[17].Text.Trim() == " ") { this.Popup("请填写过期日期!"); return; } string strWhcode = this.ddlWhouse.SelectedValue; Entity.RdRecordDetail rrd = new RdRecordDetail(); rrd.cnnAutoID = int.Parse(e.Item.Cells[0].Text.Trim()); rrd.cnvcPOID = e.Item.Cells[2].Text.Trim(); rrd.cnnRdID = int.Parse(this.txtRdID.Text.Trim()); rrd.cndMdate = DateTime.Parse(e.Item.Cells[15].Text.Trim()); rrd.cndExpDate = DateTime.Parse(e.Item.Cells[17].Text.Trim()); rrd.cnvcInvCode = e.Item.Cells[4].Text.Trim(); if (strWhcode == "") { this.Popup("仓库不能为空!"); return; } // DataTable dtsum=(DataTable)Session["sumenter"]; // if(dtsum==null||dtsum.Rows.Count<=0) // { // this.Popup("该采购入库单无任何货品记录,请先关联采购订单!"); // return; // } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "采购入库单入库"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.PoStockEnterExecEntering(ol, strWhcode, rrd); if (ret > 0) { this.Popup("采购入库单入库成功!"); this.DBBind(); } else { this.Popup("采购入库单入库失败!"); } } }
private void btAdd_Click(object sender, System.EventArgs e) { strArriveDate = Request.Form["txtArvDate"].ToString(); if (strArriveDate == "" || strArriveDate == null) { this.Popup("到货时间不能为空,请重新选择时间!"); this.ClientScript.RegisterStartupScript(this.GetType(), "hide", "<script lanaguage=javascript>ShowHide('1','none');</script>"); return; } Entity.RdRecord rd = new RdRecord(); rd.cnvcCode = this.txtEnterCode.Text.Trim(); rd.cnvcRdCode = "RD002"; rd.cnvcRdFlag = "1"; rd.cnvcWhCode = this.ddlWhouse.SelectedValue; rd.cnvcDepID = this.ddlDeptID.SelectedValue; rd.cnvcOperName = this.oper.strOperName; rd.cnvcComments = this.txtComments.Text.Trim(); rd.cnvcMaker = this.oper.strOperName; rd.cnvcShipAddress = this.txtShipAddress.Text.Trim(); rd.cndARVDate = DateTime.Parse(strArriveDate); rd.cnvcARVAddress = this.txtArvAddress.Text.Trim(); rd.cnvcState = "0"; if (rd.cnvcCode == "" || rd.cnvcCode.Length != 13) { this.Popup("采购退货单号不正确!"); return; } if (rd.cnvcWhCode == "") { this.Popup("仓库不能为空!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "添加采购退货主单"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.AddRdRecordCom("RD002", ol, rd); if (ret > 0) { this.Popup("添加采购退货单内容成功!"); } else { this.Popup("添加采购退货单内容失败!"); } }
private void btnRefreshSTBA_Click(object sender, System.EventArgs e) { StorageFacade sto = new StorageFacade(); int ret = sto.CreateStorageBalance(); if (ret > 0) { this.Popup("重新刷新库存平衡关系成功!"); } else { this.Popup("重新刷新库存平衡关系失败!"); } }
private void Datagrid2_UpdateCommand(object source, DataGridCommandEventArgs e) { if (((TextBox)e.Item.Cells[11].Controls[0]).Text.Trim() == "" || !this.JudgeIsNum(((TextBox)e.Item.Cells[11].Controls[0]).Text.Trim())) { this.Popup("入库数量不能为空且必须是数字!"); return; } if (((TextBox)e.Item.Cells[10].Controls[0]).Text.Trim() == "" || !this.JudgeIsNum(((TextBox)e.Item.Cells[10].Controls[0]).Text.Trim())) { this.Popup("损耗数量不能为空且必须是数字!"); return; } Entity.RdRecordDetail rrd = new RdRecordDetail(); rrd.cnnAutoID = int.Parse(e.Item.Cells[0].Text.Trim()); rrd.cnnQuantity = Math.Round(decimal.Parse(((TextBox)e.Item.Cells[11].Controls[0]).Text.Trim()), 2); decimal dlostcount = Math.Round(decimal.Parse(((TextBox)e.Item.Cells[10].Controls[0]).Text.Trim()), 2); decimal doutcount = Math.Round(decimal.Parse(e.Item.Cells[9].Text.Trim()), 2); if (rrd.cnnAutoID.ToString() == "" || rrd.cnnAutoID == 0) { this.Popup("分货入库单子表标识不正确!"); return; } if (doutcount != rrd.cnnQuantity + dlostcount) { this.Popup("损耗数量+入库数量不等于分货数量"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "修改分货入库子表"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.UpdateDeptStorageEnterDetail(ol, rrd, dlostcount); if (ret > 0) { this.Popup("修改分货入库单子表明细成功!"); this.DBBind(); } else { this.Popup("修改分货入库单子表明细失败!"); } }
private void btConfirm_Click(object sender, System.EventArgs e) { if (this.txtSerialNo.Text.Trim() == "" || this.txtInvCode.Text.Trim() == "") { this.Popup("损耗流水不正确!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "确认过期损耗"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; string strsql = "select a.cnnLostSerialNo from tbLostSerial a,tbCurrentStock b,tbComputationUnit c where a.cnnLostSerialNo=" + this.txtSerialNo.Text.Trim() + " and a.cnvcInvCode=b.cnvcInvCode and a.cnvcWhCode=b.cnvcWhCode"; strsql += " and convert(char(8),a.cndMdate,112)=convert(char(8),b.cndMdate,112) and convert(char(8),a.cndExpDate,112)=convert(char(8),b.cndExpDate,112)"; strsql += " and a.cnvcComunitCode=c.cnvcComunitCode and a.cnnLostCount+a.cnnAddCount-a.cnnReduceCount>(b.cnnQuantity*c.cniChangRate)"; DataTable dterrcount = Helper.Query(strsql); if (dterrcount.Rows.Count > 0) { this.Popup("损耗数量大于当前库存量,可能是库存已经有变动,请检查修改损耗数量!"); return; } StorageFacade sto = new StorageFacade(); int ret = sto.ConfirmLostSerial(ol, this.txtSerialNo.Text.Trim()); if (ret > 0) { this.Popup("确认过期损耗成功!"); this.txtAddCount.Enabled = false; this.txtReduceCount.Enabled = false; this.txtComments.Enabled = false; this.Button1.Enabled = false; this.btMod.Enabled = false; this.btConfirm.Visible = false; } else { this.Popup("确认过期损耗失败!"); } }
private void btnInvAccount_Click(object sender, System.EventArgs e) { Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "原材料成本核算"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.InventoryCostAccount(ol, "mate"); if (ret > 0) { this.Popup("原材料成本核算成功!"); } else { this.Popup("原材料成本核算失败!"); } }
public async Task <ActionResult> Edit(EditSquareSetPieceViewModel squareSetPieceViewModel) { if (ModelState.IsValid) { // upload the new image var storage = new StorageFacade(); var image = squareSetPieceViewModel.UpdatedImage; var url = storage.Store(image.FileName, image.InputStream, User.Identity.GetUserId()); // update the db var setPiece = await _db.SquareSetPieces.FirstAsync(o => o.Id == squareSetPieceViewModel.Id); setPiece.ImageUrl = url; await _db.SaveChangesAsync(); return(RedirectToAction("Details", new { id = squareSetPieceViewModel.Id })); } return(View(squareSetPieceViewModel)); }
private void UploadImages(ISquareSetViewModel squareSetViewModel) { if (squareSetViewModel.Images != null && squareSetViewModel.Images.Any()) { var storage = new StorageFacade(); foreach (var image in squareSetViewModel.Images) { if (image != null && image.ContentLength > 0) { var url = storage.Store(image.FileName, image.InputStream, User.Identity.GetUserId()); var squareSetPiece = new SquareSetPiece { SquareSetId = squareSetViewModel.Id, ImageUrl = url }; _db.SquareSetPieces.Add(squareSetPiece); } } } }
private void btMod_Click(object sender, System.EventArgs e) { strArriveDate = Request.Form["txtArvDate"].ToString(); if (strArriveDate == "" || strArriveDate == null) { this.Popup("到货时间不能为空,请重新选择时间!"); return; } Entity.RdRecord rdrm = new RdRecord(); rdrm.cnnRdID = int.Parse(this.txtRdID.Text.Trim()); rdrm.cnvcIsLsQuery = this.ddlIsLsQuery.SelectedValue; rdrm.cndARVDate = DateTime.Parse(strArriveDate); rdrm.cnvcShipAddress = this.txtShipAddress.Text.Trim(); rdrm.cnvcARVAddress = this.txtArvAddress.Text.Trim(); rdrm.cnvcComments = this.txtComments.Text.Trim(); rdrm.cnvcModer = oper.strOperName; if (rdrm.cnnRdID.ToString() == "" || rdrm.cnnRdID == 0) { this.Popup("采购入库单主表标识不正确!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "修改采购入库主单"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.UpdateRdRecordCom("RD001", ol, rdrm); if (ret > 0) { this.Popup("修改采购入库单内容成功!"); } else { this.Popup("修改采购入库单内容失败!"); } }
private void btnCheckOk_Click(object sender, System.EventArgs e) { DataTable dt = (DataTable)Session["checktomod"]; if (this.ddlDayCheckNo.SelectedValue == "") { this.Popup("盘点序号不正确,可能盘点记录已经不是当日操作记录!"); return; } if (dt.Rows.Count <= 0) { this.Popup("无任何盘点存货记录!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "仓库库存盘点"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; DataTable dtre = Helper.Query("select count(*) from tbStorageCheckLog where cnvcCheckNo='" + this.ddlDayCheckNo.SelectedValue + "' and (cndMdate is null or cndExpDate is null)"); if (dtre.Rows[0][0].ToString() != "0") { this.Popup("盘点存货中存在生产日期或过期日期为空的记录,请先修改!"); return; } StorageFacade sto = new StorageFacade(); int ret = sto.StorageCheckLogConfirm(ol, this.ddlDayCheckNo.SelectedValue, this.ddlWhouse.SelectedValue, this.ddlDept.SelectedValue); if (ret > 0) { this.Popup("仓库库存盘点确认更新库存成功!"); this.DBBind(); } else { this.Popup("仓库库存盘点确认更新库存失败!"); } }
private void Datagrid2_DeleteCommand(object source, DataGridCommandEventArgs e) { string strRdID = e.Item.Cells[0].Text.Trim(); string strInvCode = e.Item.Cells[1].Text.Trim(); Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "删除调拨单子表"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.DeleteRdRecordMoveDetail(ol, strRdID, strInvCode); if (ret > 0) { this.Popup("删除调拨单子表明细成功!"); this.DBBind(); } else { this.Popup("删除调拨单子表明细失败!"); } }
private void Datagrid2_UpdateCommand(object source, DataGridCommandEventArgs e) { decimal EnterQuantity = Math.Round(decimal.Parse(e.Item.Cells[8].Text.Trim()), 2); Entity.RdRecordDetail rrd = new RdRecordDetail(); rrd.cnnAutoID = int.Parse(e.Item.Cells[0].Text.Trim()); rrd.cnnQuantity = Math.Round(decimal.Parse(((TextBox)e.Item.Cells[9].Controls[0]).Text.Trim()), 2); rrd.cnvcCommens = ((TextBox)e.Item.Cells[11].Controls[0]).Text.Trim(); if (rrd.cnnQuantity > EnterQuantity) { this.Popup("采购退货数量不能大于原入库数量!"); return; } if (rrd.cnnAutoID.ToString() == "" || rrd.cnnAutoID == 0) { this.Popup("采购退货单子表标识不正确!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "修改采购退货子表"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.UpdatePoStockReturnDetail(ol, rrd); if (ret > 0) { this.Popup("修改采购退货单子表明细成功!"); this.DBBind(); } else { this.Popup("修改采购退货单子表明细失败!"); } }
public async Task <ActionResult> Create(CreateSquareSetPieceViewModel squareSetPieceViewModel) { if (ModelState.IsValid) { var storage = new StorageFacade(); foreach (var image in squareSetPieceViewModel.Images) { var url = storage.Store(image.FileName, image.InputStream, User.Identity.GetUserId()); var squareSetPiece = new SquareSetPiece { SquareSetId = squareSetPieceViewModel.SquareSetId, ImageUrl = url }; _db.SquareSetPieces.Add(squareSetPiece); } await _db.SaveChangesAsync(); return(RedirectToAction("Edit", "SquareSets", new { id = squareSetPieceViewModel.SquareSetId })); } return(View(squareSetPieceViewModel)); }
private void btEnterComf_Click(object sender, System.EventArgs e) { string strWhcode = this.ddlWhouse.SelectedValue; string strRdid = this.txtRdID.Text.Trim(); if (strWhcode == "") { this.Popup("仓库不能为空!"); return; } DataTable dtdetail = (DataTable)Session["asdetailtomod"]; if (dtdetail == null || dtdetail.Rows.Count <= 0) { this.Popup("该分货入库单无任何货品记录,请先关联生产分货单!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "分货入库单入库"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.DeptStorageEnterExecEntering(ol, strWhcode, dtdetail, strRdid, this.ddlDept.SelectedValue); if (ret > 0) { this.Popup("分货入库单入库成功!"); this.DBBind(); } else { this.Popup("分货入库单入库失败!"); } }
private void btEnterComf_Click(object sender, System.EventArgs e) { string strWhcode = this.ddlWhouse.SelectedValue; string strRdid = this.txtRdID.Text.Trim(); if (strWhcode == "") { this.Popup("仓库不能为空!"); return; } DataTable dtsum = (DataTable)Session["sumenter"]; if (dtsum == null || dtsum.Rows.Count <= 0) { this.Popup("该采购退货单无任何货品记录,请先录入要退的货品!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "采购退货单出库"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.PoStockReturnExecReturning(ol, strWhcode, dtsum, strRdid); if (ret > 0) { this.Popup("采购退货单出库成功!"); this.DBBind(); } else { this.Popup("采购退货单出库失败!"); } }
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e) { DataGridItem item = this.DataGrid1.SelectedItem; if (this.txtCheckCount.Text.Trim() == "" || !this.JudgeIsNum(this.txtCheckCount.Text.Trim())) { this.Popup("盘点存量不能为空且必须是数字!"); return; } StorageCheckLog scl = new StorageCheckLog(); scl.cnvcDeptID = this.ddlDept.SelectedValue; scl.cnvcWhCode = this.ddlWhouse.SelectedValue; scl.cnvcInvCode = item.Cells[0].Text.Trim(); scl.cnnSysCount = Math.Round(decimal.Parse(item.Cells[5].Text.Trim()), 2); scl.cnnCheckCount = Math.Round(decimal.Parse(this.txtCheckCount.Text.Trim()), 2); scl.cnvcUnitCode = item.Cells[2].Text.Trim(); scl.cnvcOperName = this.oper.strOperName; scl.cnvcFlag = "0"; string strMdate = ""; string strExpdate = ""; if (item.Cells[6].Text.Trim() != "") { scl.cndMdate = DateTime.Parse(item.Cells[6].Text.Trim()); strMdate = scl.cndMdate.Year.ToString(); if (scl.cndMdate.Month < 10) { strMdate += "0" + scl.cndMdate.Month.ToString(); } else { strMdate += scl.cndMdate.Month.ToString(); } if (scl.cndMdate.Day < 10) { strMdate += "0" + scl.cndMdate.Day.ToString(); } else { strMdate += scl.cndMdate.Day.ToString(); } } if (item.Cells[7].Text.Trim() != "") { scl.cndExpDate = DateTime.Parse(item.Cells[7].Text.Trim()); strExpdate = scl.cndExpDate.Year.ToString(); if (scl.cndExpDate.Month < 10) { strExpdate += "0" + scl.cndExpDate.Month.ToString(); } else { strExpdate += scl.cndExpDate.Month.ToString(); } if (scl.cndExpDate.Day < 10) { strExpdate += "0" + scl.cndExpDate.Day.ToString(); } else { strExpdate += scl.cndExpDate.Day.ToString(); } } string strcheckno = ""; string strisexist = ""; if (strMdate == "" && strExpdate == "") { strisexist = Helper.Query("select count(*) from tbStorageCheckLog where cnvcWhCode='" + scl.cnvcWhCode + "' and cnvcInvCode='" + scl.cnvcInvCode + "' and cnvcFlag='0' and cnvcCheckNo like convert(char(8),getdate(),112)+'%'").Rows[0][0].ToString(); } else { strisexist = Helper.Query("select count(*) from tbStorageCheckLog where cnvcWhCode='" + scl.cnvcWhCode + "' and cnvcInvCode='" + scl.cnvcInvCode + "' and cnvcFlag='0' and cnvcCheckNo like convert(char(8),getdate(),112)+'%' and convert(char(8),cndMdate,112)='" + strMdate + "' and convert(char(8),cndExpDate,112)='" + strExpdate + "'").Rows[0][0].ToString(); } if (strisexist != "0") { this.Popup("本仓库的" + item.Cells[1].Text.Trim() + "在今日内还有未确认的盘点记录,不可添加!"); return; } else { StorageFacade sto = new StorageFacade(); int ret = sto.AddStorageCheckLog(scl, this.txtCheckNo.Text.Trim(), out strcheckno); if (ret > 0) { this.Popup("添加盘点存货成功!"); this.ddlState.SelectedIndex = this.ddlState.Items.IndexOf(this.ddlState.Items.FindByValue("0")); DataTable dtcheckno = Helper.Query("select distinct cnvcCheckNo as cnvcCode,cnvcCheckNo as cnvcName from tbStorageCheckLog where cnvcWhCode='" + this.ddlWhouse.SelectedValue + "' and cnvcCheckNo like '" + this.txtCheckNo.Text.Trim() + "%'"); this.FillDropDownList(dtcheckno, this.ddlDayCheckNo); this.ddlDayCheckNo.SelectedIndex = this.ddlDayCheckNo.Items.IndexOf(this.ddlDayCheckNo.Items.FindByValue(strcheckno)); this.ddlDept.Enabled = false; this.ddlWhouse.Enabled = false; this.ddlDayCheckNo.Enabled = false; this.ddlState.Enabled = false; this.btnCheckOk.Enabled = true; } else { if (ret < 0) { this.Popup("该仓库在盘点序号“" + strcheckno + "”中已经有此存货的盘点记录,请重试!"); } else { this.Popup("添加盘点存货失败!"); } } this.DataGrid1.DataSource = null; this.DataGrid1.DataBind(); this.DBBind(); } }
private void btAdd_Click(object sender, System.EventArgs e) { strLostDate = Request.Form["txtLostDate"].ToString(); if (strLostDate == "" || strLostDate == null) { this.Popup("损耗时间不能为空,请重新选择时间!"); return; } if (this.txtLostCount.Text.Trim() == "") { this.Popup("损耗数量不能为空!"); return; } if (this.txtMdate.Text.Trim() == "" || this.txtExpDate.Text.Trim() == "") { this.Popup("生产日期和过期日期不能为空!"); return; } Entity.LostSerial ls = new LostSerial(); ls.cnvcInvCode = this.txtInvCode.Text.Trim(); ls.cnnLostCount = Math.Round(decimal.Parse(this.txtLostCount.Text.Trim()), 2); ls.cnnAddCount = 0; ls.cnnReduceCount = 0; ls.cndLostDate = DateTime.Parse(strLostDate); ls.cnvcDeptID = this.ddlDeptID.SelectedValue; ls.cnvcWhCode = this.ddlWhouse.SelectedValue; ls.cnvcOperID = this.oper.strLoginID; ls.cnvcLostType = "1"; ls.cnvcComments = this.txtComments.Text.Trim(); ls.cnvcInvalidFlag = "0"; ls.cnvcComunitCode = this.txtUnitCode.Text.Trim(); ls.cndMdate = DateTime.Parse(this.txtMdate.Text.Trim()); ls.cndExpDate = DateTime.Parse(this.txtExpDate.Text.Trim()); if (ls.cnvcDeptID == "" || ls.cnvcWhCode == "") { this.Popup("部门和仓库不能为空!"); return; } if (ls.cnvcInvCode == "") { this.Popup("报损存货不能为空!"); return; } if (ls.cndExpDate.CompareTo(DateTime.Now) > 0) { this.Popup("此存货尚未过期,不能报废!"); return; } string strsql = "select cast(cnnQuantity/(select cniChangRate from tbComputationUnit where cnvcComunitCode='" + ls.cnvcComunitCode + "') as numeric(10,4)) as cnnQuantity from tbCurrentStock"; strsql += " where cnvcWhCode='" + ls.cnvcWhCode + "' and cnvcInvCode='" + ls.cnvcInvCode + "' and convert(char(10),cndMdate,121)='" + ls.cndMdate.ToString("yyyy-MM-dd") + "' and convert(char(10),cndExpDate,121)='" + ls.cndExpDate.ToString("yyyy-MM-dd") + "'"; string strQuantity = Helper.Query(strsql).Rows[0]["cnnQuantity"].ToString(); if (ls.cnnLostCount > Math.Round(decimal.Parse(strQuantity), 2)) { this.Popup("损耗数量不能大于库存数量!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "添加过期损耗"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.AddLostSerial(ol, ls); if (ret > 0) { this.Popup("添加过期损耗成功!"); } else { this.Popup("添加过期损耗失败!"); } }
private void Datagrid2_UpdateCommand(object source, DataGridCommandEventArgs e) { string checkcount = ((TextBox)e.Item.Cells[8].Controls[0]).Text.Trim(); string strmdate = ""; string strexpdate = ""; string strflag = ""; if (e.Item.Cells[9].Text.Trim() == "" || e.Item.Cells[9].Text.Trim() == " ") { strmdate = ((System.Web.UI.HtmlControls.HtmlInputText)e.Item.Cells[10].Controls[1]).Value; strexpdate = ((System.Web.UI.HtmlControls.HtmlInputText)e.Item.Cells[12].Controls[1]).Value; } else { strmdate = e.Item.Cells[9].Text.Trim(); strexpdate = e.Item.Cells[11].Text.Trim(); } string checkno = e.Item.Cells[0].Text.Trim(); if (checkcount == "" || !this.JudgeIsNum(checkcount)) { this.Popup("盘点存量不能为空且必须是数字!"); this.hidecontrol(); return; } if (strmdate == "") { this.Popup("生产日期不能为空!"); this.hidecontrol(); return; } if (strexpdate == "") { this.Popup("过期日期不能为空!"); this.hidecontrol(); return; } StorageCheckLog scl = new StorageCheckLog(); scl.cnnSerialNo = decimal.Parse(e.Item.Cells[1].Text.Trim()); scl.cnnCheckCount = Math.Round(decimal.Parse(checkcount), 2); scl.cnvcOperName = this.oper.strOperName; if (e.Item.Cells[9].Text.Trim() == "" || e.Item.Cells[9].Text.Trim() == " ") { scl.cndMdate = DateTime.Parse(strmdate); scl.cndExpDate = DateTime.Parse(strexpdate); strflag = "up_date"; if (scl.cndMdate.CompareTo(scl.cndExpDate) > 0) { this.Popup("生产日期不能大于过期日期!"); this.hidecontrol(); return; } } StorageFacade sto = new StorageFacade(); int ret = sto.UpdateStorageCheckLog(scl, strflag); if (ret > 0) { this.Popup("修改盘点存货库存量成功!"); } else { this.Popup("修改盘点存货库存量失败!"); } this.DBBind(); this.ddlDept.Enabled = false; this.ddlWhouse.Enabled = false; this.ddlDayCheckNo.Enabled = false; this.btnCheckOk.Enabled = true; }
private void btAdd_Click(object sender, System.EventArgs e) { strOutArriveDate = Request.Form["txtOutArvDate"].ToString(); if (strOutArriveDate == "" || strOutArriveDate == null) { this.Popup("出库时间不能为空,请重新选择时间!"); return; } strInArriveDate = Request.Form["txtInArvDate"].ToString(); if (strInArriveDate == "" || strInArriveDate == null) { this.Popup("入库时间不能为空,请重新选择时间!"); return; } Entity.RdRecord rdout = new RdRecord(); rdout.cnvcCode = this.txtMoveCode.Text.Trim(); rdout.cnvcRdCode = "RD005"; rdout.cnvcRdFlag = "1"; rdout.cnvcWhCode = this.ddlOutWhouse.SelectedValue; rdout.cnvcDepID = this.ddlOutDeptID.SelectedValue; rdout.cnvcWhpersonName = this.txtOutWHPerson.Text.Trim(); rdout.cnvcOperName = this.oper.strOperName; rdout.cnvcComments = this.txtComments.Text.Trim(); rdout.cnvcMaker = this.oper.strOperName; rdout.cnvcShipAddress = this.txtShipAddress.Text.Trim(); rdout.cndARVDate = DateTime.Parse(strOutArriveDate); rdout.cnvcARVAddress = this.txtArvAddress.Text.Trim(); rdout.cnvcState = "0"; Entity.RdRecord rdin = new RdRecord(); rdin.cnvcCode = this.txtMoveCode.Text.Trim(); rdin.cnvcRdCode = "RD006"; rdin.cnvcRdFlag = "0"; rdin.cnvcWhCode = this.ddlInWhouse.SelectedValue; rdin.cnvcDepID = this.ddlInDeptID.SelectedValue; rdin.cnvcWhpersonName = this.txtInWHPerson.Text.Trim(); rdin.cnvcOperName = this.oper.strOperName; rdin.cnvcComments = this.txtComments.Text.Trim(); rdin.cnvcMaker = this.oper.strOperName; rdin.cnvcShipAddress = this.txtShipAddress.Text.Trim(); rdin.cndARVDate = DateTime.Parse(strInArriveDate); rdin.cnvcARVAddress = this.txtArvAddress.Text.Trim(); rdin.cnvcState = "0"; if (rdout.cnvcCode == "" || rdout.cnvcCode.Length != 13 || rdin.cnvcCode == "" || rdin.cnvcCode.Length != 13) { this.Popup("调拨单号不正确!"); return; } if (rdout.cnvcDepID == "" || rdout.cnvcWhCode == "") { this.Popup("出库部门或仓库不能为空!"); return; } if (rdin.cnvcDepID == "" || rdin.cnvcWhCode == "") { this.Popup("出库部门或仓库不能为空!"); return; } if (rdout.cnvcWhCode == rdin.cnvcWhCode) { this.Popup("同一仓库不能调拨!"); return; } Entity.OperLog ol = new AMSApp.zhenghua.Entity.OperLog(); ol.cnvcOperType = "添加调拨主单"; ol.cnvcOperID = this.oper.strLoginID; ol.cnvcDeptID = this.oper.strDeptID; StorageFacade sto = new StorageFacade(); int ret = sto.AddRdRecordMove(ol, rdout, rdin); if (ret > 0) { this.Popup("添加调拨单内容成功!"); } else { this.Popup("添加调拨单内容失败!"); } }