private void BtnSave_Click(object sender, EventArgs e)
{
try
{
bs.EndEdit();
if (_bill.单据类型 != (int)BillType.StockMove)
{
MessageHelper.ShowError("请输入有效的单据类型！移库单据类型为：" + (int)BillType.StockMove);
return;
}
var detailList = (List <TB_STOCK_MOVE>)bs.DataSource;
if (detailList.Count == 0)
{
MessageHelper.ShowError("请维护移动明细！");
return;
}
SpareEntities db = EntitiesFactory.CreateSpareInstance();
BillHandler.AddStockMove(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList);
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("保存成功！");
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
OpenFileDialog dlg = new OpenFileDialog();
dlg.Filter = "文件(*.*)|*.*";
if (dlg.ShowDialog() == DialogResult.OK)
{
var attach = new TA_Attach()
{
TableName = TableName,
TablePKID = TablePKID,
CreateDate = DateTime.Now,
CreatorName = GlobalVar.Oper.OperName,
FileName = Path.GetFileName(dlg.FileName)
};
FileStream fs = File.OpenRead(dlg.FileName);
fs.Position = 0;
byte[] blobdata = new Byte[fs.Length];
fs.Read(blobdata, 0, (int)fs.Length);
attach.FileData = blobdata;
fs.Close();
SpareEntities db = EntitiesFactory.CreateSpareInstance();
AttachController.AddOrUpdate(db, attach, GlobalVar.Oper);
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("保存成功！");
RefreshData();
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
bs.EndEdit();
if (_bill.单据类型 != (int)BillType.OtherInOut)
{
MessageHelper.ShowError("请输入有效的单据类型！其他出入库单据类型为：" + (int)BillType.OtherInOut);
return;
}
if (_bill.子单据类型 != (int)SubBillType.OtherIn)
{
MessageHelper.ShowError("维护的子单据类型无效！其他入库类型为：" + (int)SubBillType.OtherIn);
return;
}
var detailList = (List <TB_OTHER_IN>)bs.DataSource;
if (detailList.Count == 0)
{
MessageHelper.ShowError("请维护其他入库明细！");
return;
}
SpareEntities db = EntitiesFactory.CreateSpareInstance();
BillHandler.AddOtherIn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList);
EntitiesFactory.SaveDb(db);
NotifyController.AddStockSafeQty(db, GlobalVar.Oper.OperName);
MessageHelper.ShowInfo("保存成功！");
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
private void ItemBtnReturn_Click(object sender, EventArgs e)
{
if (_bill == null || _bill.单据编号 == null)
{
MessageHelper.ShowInfo("请选择单据");
return;
}
if (_bill.状态 != (int)BillState.Finished)
{
MessageHelper.ShowInfo("选中单据状态错误，无法执行");
return;
}
var details = SpareOutController.GetList(_db, _bill.单据编号);
try
{
string strInfo = BillHandler.HandleMaterialReturn(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode), details);
if (strInfo != "OK")
{
MessageHelper.ShowError(strInfo);
}
else
{
MessageHelper.ShowInfo("生成领用还回单成功");
EntitiesFactory.SaveDb(_db);
}
}
catch (Exception ex)
{
MessageHelper.ShowError(ex.ToString());
throw;
}
}
private void BtnDeliver_Click(object sender, EventArgs e)
{
if (_bill == null || _bill.单据编号 == null)
{
MessageHelper.ShowInfo("请选择单据");
return;
}
if (MessageHelper.ShowQuestion("确定要执行选定的领用单？") == DialogResult.Yes)
{
SpareEntities db = EntitiesFactory.CreateSpareInstance();
var outlist = SpareOutController.GetList(db, _bill.单据编号);
foreach (var spout in outlist)
{
if (string.IsNullOrEmpty(spout.TakeUser))
{
MessageHelper.ShowError("领用详细中的领用人信息不能为空！");
return;
}
}
BillHandler.FinishMaterialOut(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), outlist);
EntitiesFactory.SaveDb(db);
NotifyController.AddStockSafeQty(db, GlobalVar.Oper.OperName);
MessageHelper.ShowInfo("保存成功！");
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
if (_bill == null || _bill.单据编号 == null)
{
MessageHelper.ShowInfo("请选择单据！");
return;
}
if (_bill.状态 != (int)BillState.New)
{
MessageHelper.ShowError("非新建单据，禁止取消！");
return;
}
if (MessageHelper.ShowQuestion("是否要取消盘点计划单？") == DialogResult.Yes)
{
BillController.UpdateState(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode), BillState.Cancelled);
NotifyController.AddNotify(_db, _bill.操作者, NotifyType.InventoryPlanCancel, _bill.单据编号, "");
var InventoryLocs = InventoryController.GetLocList(_db, _bill.单据编号);
foreach (var inventoryLoc in InventoryLocs)
{
InventoryController.LocCancel(_db, inventoryLoc);
}
EntitiesFactory.SaveDb(_db);
MessageHelper.ShowInfo("取消盘点计划成功！");
SetMasterDataSource(grid.PageSize);
}
}
/// <summary>
/// 创建【拣料单】
/// </summary>
/// <param name="db"></param>
/// <param name="billPickFact">拣料单</param>
/// <param name="details">拣料明细</param>
/// <returns></returns>
public static void AddMaterialOut(SpareEntities db, TB_BILL billPickFact, List <TB_OUT> details)
{
{
//校验单据状态是否为新建
if (billPickFact.State != (int)BillState.New)
{
throw new WmsException(ResultCode.DataStateError,
billPickFact.BillNum, "状态错误,不应为：" + billPickFact.State);
}
if (string.IsNullOrEmpty(billPickFact.BillNum))
{
SetBillNum(billPickFact); //设置单据编号
details.ForEach(p => p.BillNum = billPickFact.BillNum); //设置明细编号
NotifyController.AddNotify(db, billPickFact.OperName, NotifyType.MaterialOut, billPickFact.BillNum, "");
}
else
{
var dbOutList = db.TB_OUT.Where(p => p.BillNum == billPickFact.BillNum).ToList();
foreach (var det in dbOutList)
{
if (details.FirstOrDefault(p => p.UID == det.UID) == null)
{
SpareOutController.RemaveDetail(db, det);
}
}
NotifyController.AddNotify(db, billPickFact.OperName, NotifyType.MaterialOutUpdate, billPickFact.BillNum, "");
}
BillController.AddOrUpdate(db, billPickFact); //添加【原料拣料单】单据
SpareOutController.AddOrUpdateList(db, details); //更新【实际拣料单】明细
EntitiesFactory.SaveDb(db);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
bs.EndEdit();
if (_bill.单据类型 != (int)BillType.MaterialAsk)
{
MessageHelper.ShowError("请输入有效的单据类型！申请单单据类型为：" + (int)BillType.MaterialAsk);
return;
}
if (_bill.子单据类型 != (int)SubBillType.SpareLoan && _bill.子单据类型 != (int)SubBillType.SpareOut)
{
MessageHelper.ShowError("维护的子单据类型无效！领用出库类型为：" + (int)SubBillType.SpareOut + "借用出库类型为：" + (int)SubBillType.SpareLoan);
return;
}
var detailList = (List <TB_ASK>)bs.DataSource;
if (detailList.Count == 0)
{
MessageHelper.ShowError("请维护领用申请明细！");
return;
}
var bill = _bill.VWToBill(GlobalVar.Oper.DeptCode);
//List<TB_ASK> detailList = (from TB_ASK d in _list select d).ToList();
SpareEntities db = EntitiesFactory.CreateSpareInstance();
BillHandler.AddMaterialAsk(db, bill, detailList);
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("保存成功！");
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
public void ModifyPassword(TS_OPERATOR oper)
{
PowerEntities db = EntitiesFactory.CreatePowerInstance();
OperController.AddOrModify(db, oper);
EntitiesFactory.SaveDb(db);
}
private void SaveData()
{
int iFind = -1;
SpareEntities db = EntitiesFactory.CreateSpareInstance();
for (int i = 0; i < gr.Length; i++)
{
if (gr[i].Check)
{
FileStream fs = new FileStream(gr[i].FullName, FileMode.Open, FileAccess.Read);
UpdateControl.SaveFile2DB(db,"Update", gr[i].FileName, fs);
iFind = servers.Find(gr[i].FileName);
if (iFind >= 0)
{
if (servers[iFind].ModifyDate < DateTime.Parse(gr[i].lModifyDate))
{
servers[iFind].ModifyDate = DateTime.Parse(gr[i].lModifyDate);
servers[iFind].FileSize = long.Parse(gr[i].lFileSize);
}
}
else
{
UpdateItem item = new UpdateItem();
item.FileName = gr[i].FileName;
item.FileSize = long.Parse(gr[i].lFileSize);
item.ModifyDate = DateTime.Parse(gr[i].lModifyDate);
servers.Add(item);
}
}
}
UpdateControl.SaveObj(db,"Updates", "Updates", servers);
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("保存成功!");
RefreshData();
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
bs.EndEdit();
if (_bill.单据类型 != (int)BillType.SpareReturn)
{
MessageHelper.ShowError("请输入有效的单据类型！领用归还单据类型为：" + (int)BillType.SpareReturn);
return;
}
var detailList = (List <TB_RETURN>)bs.DataSource;
if (detailList.Count == 0)
{
MessageHelper.ShowError("请维护领用还回明细！");
return;
}
//List<TB_RETURN> detailList = (from TB_RETURN d in _list select d).ToList();
SpareEntities db = EntitiesFactory.CreateSpareInstance();
BillHandler.AddMaterialReturn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList);
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("保存成功！");
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
public TS_OPERATOR Login(string operCode, string password)
{
PowerEntities db = EntitiesFactory.CreatePowerInstance();
var oper = OperController.Login(db, operCode, password);
// if (oper != null) oper.State = LoginState.Online.ToString();
EntitiesFactory.SaveDb(db);
return(oper);
}
private void CloseNotify()
{
if (_selectedData == null || _selectedData.UID == 0)
{
return;
}
NotifyController.CloseNotify(_db, GlobalVar.Oper.OperName, _selectedData);
EntitiesFactory.SaveDb(_db);
Init();
}
private void BgwFromErpDoWork(object sender, DoWorkEventArgs e)
{
SpareEntities db = EntitiesFactory.CreateSpareInstance();
InterfaceEntities OAdb = EntitiesFactory.CreateInterfaceInstance();
ReadErpFiles(db);
GetOAData(OAdb, db);
EntitiesFactory.SaveDb(db);
EntitiesFactory.SaveDb(OAdb);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (MessageHelper.ShowQuestion("确定要关闭所有提示吗?") != DialogResult.Yes)
{
return;
}
NotifyController.CloseNotifyList(_db, GlobalVar.Oper.OperName, _dataList);
EntitiesFactory.SaveDb(_db);
Init();
}
private void ItemBtnApprove_Click(object sender, EventArgs e)
{
if (_bill == null || _bill.单据编号 == null)
{
MessageHelper.ShowInfo("请选择单据！");
return;
}
BillController.UpdateState(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode), BillState.Approve);
EntitiesFactory.SaveDb(_db);
NotifyController.AddNotify(_db, _bill.操作者, NotifyType.MaterialAskApprove, _bill.单据编号, "");
MessageHelper.ShowInfo("审核通过！");
SetMasterDataSource(1, grid.PageSize);
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
SpareEntities db = EntitiesFactory.CreateSpareInstance();
// BillHandler.AddMaterialAsk(db,_bill, tList);
EntitiesFactory.SaveDb(db);
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
public static void CloseNotify(int id, Form form)
{
var notify = NotifyList.SingleOrDefault(p => p.UID == id);
if (notify == null)
{
return;
}
if (notify.State == (int)BillState.Finished)
{
return;
}
using (SpareEntities db = EntitiesFactory.CreateSpareInstance())
{
try
{
NotifyController.CloseNotify(db, GlobalVar.Oper.OperName, notify);
EntitiesFactory.SaveDb(db);
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
NotifyType notifyType = (NotifyType)notify.NotifyType;
var formMain = (FormMain)form;
if (formMain == null)
{
return;
}
/* switch (notifyType)
* {
* case NotifyType.Ask:
* formMain.SetMdiForm("仓库申请单", typeof(FormWhseAskView));
* break;
* case NotifyType.Stock:
* formMain.SetMdiForm("仓库库存", typeof(FormStockProduct));
* break;
* case NotifyType.TransferSend:
* formMain.SetMdiForm("中转发运单", typeof(FormFactoryTransferSend));
* break;
* case NotifyType.DirectSend:
* formMain.SetMdiForm("直送发运单", typeof(FormFactoryDirectSend));
* break;
* case NotifyType.WhseSend:
* formMain.SetMdiForm("仓库发运单", typeof(FormWhseSend));
* break;
* }*/
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (txtOperCode.Text == "")
{
MessageHelper.ShowError("请输入人员编号！");
txtOperCode.Focus();
return;
}
TS_OPERATOR oper = new TS_OPERATOR();
string operCode = txtOperCode.Text;
string password = EncryptHelper.Encrypt(txtPassword.Text);
using (PowerEntities powerdb = EntitiesFactory.CreatePowerInstance())
{
oper = OperController.Login(powerdb, operCode, password);
if (oper == null)
{
MessageHelper.ShowError("错误的用户名或密码，登录失败！");
txtOperCode.Focus();
txtOperCode.SelectAll();
return;
}
this.DialogResult = DialogResult.OK;
//EntitiesFactory.SaveDb(powerdb);
GlobalVar.Oper = oper;
GlobalVar.PowerMenuList = PowerController.GetPowerMenuList(powerdb, GlobalVar.PortalCode,
oper.OperCode);
GlobalVar.NotifytypeList = PowerController.GetNotiFyTypeList(powerdb, GlobalVar.PortalCode,
oper.OperCode);
GlobalBuffer.FactoryCode = GlobalVar.Oper.DeptCode;
}
using (SpareEntities wmsdb = EntitiesFactory.CreateSpareInstance())
{
OperLogController.AddLog(wmsdb, LogType.Login, oper.OperName, operCode, "登录成功");
EntitiesFactory.SaveDb(wmsdb);
GlobalVar.InitGlobalVar(wmsdb, GlobalVar.Oper);
}
}
catch (WmsException ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
catch (Exception ex)
{
var inner = ex.InnerException;
MessageHelper.ShowError((string.IsNullOrEmpty(inner?.Message)) ? ex : inner);
}
}
private void btnModify_Click(object sender, EventArgs e)
{
if (txtOldPwd.Text.Trim() == string.Empty)
{
MessageHelper.ShowInfo("原密码不能为空");
return;
}
if (txtNewPwd.Text.Trim() == string.Empty)
{
MessageHelper.ShowInfo("新密码不能为空");
return;
}
if (txtNewPwd.Text.Length < 6 || txtNewPwd.Text.Length > 20)
{
MessageHelper.ShowInfo("新密码长度应该在6到20位之间");
return;
}
if (txtNewPwd.Text != txtNewPwd2.Text)
{
MessageHelper.ShowInfo("两次输入的新密码不一致，请重新输入");
return;
}
string enOldPwd = EncryptHelper.Encrypt(txtOldPwd.Text);
if (enOldPwd != GlobalVar.Oper.OperPassword)
{
MessageHelper.ShowInfo("原密码输入错误");
return;
}
if (enOldPwd == txtNewPwd.Text)
{
MessageHelper.ShowInfo("新密码不能与原密码相同");
return;
}
string enNewPwd = EncryptHelper.Encrypt(txtNewPwd.Text);
GlobalVar.Oper.OperPassword = enNewPwd;
using (PowerEntities db = EntitiesFactory.CreatePowerInstance())
{
var oper_B = new TS_OPERATOR();
oper_B.OperCode = GlobalVar.Oper.OperCode;
oper_B.OperName = GlobalVar.Oper.OperName;
oper_B.OperPassword = GlobalVar.Oper.OperPassword;
OperController.AddOrModify(db, oper_B);
MessageHelper.ShowInfo("密码修改成功");
EntitiesFactory.SaveDb(db);
}
Close();
}
private void btnCancel_Click(object sender, EventArgs e)
{
try
{
BillHandler.CancelMaterialAsk(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode));
NotifyController.AddNotify(_db, _bill.操作者, NotifyType.MaterialOutCancel, _bill.单据编号, "");
EntitiesFactory.SaveDb(_db);
SetMasterDataSource(grid.PageIndex, grid.PageSize);
}
catch (Exception ex)
{
MessageHelper.ShowError(ex.ToString());
}
}
public static string GetBillNum(BillType billType)
{
using (var db = EntitiesFactory.CreateSpareInstance())
{
var bt = db.TA_BILLTYPE.SingleOrDefault(p => p.BillType == (int)billType);
var rules = bt.BillNumRule.Split('|');
var sb = CreateNewBillNum(rules, bt);
var strBillNum = sb.TrimEnd(Separator);
bt.LastNumber += 1;
bt.LastBillNum = strBillNum;
bt.LastBillTime = DateTime.Now;
EntitiesFactory.SaveDb(db);
return(strBillNum);
}
}
private void btnExecute_Click(object sender, EventArgs e)
{
if (_bill == null || _bill.单据编号 == null)
{
MessageHelper.ShowInfo("请选择单据！");
return;
}
if (MessageHelper.ShowQuestion("确定要执行选定的领用还回单？") == DialogResult.Yes)
{
SpareEntities db = EntitiesFactory.CreateSpareInstance();
BillHandler.ExecuteSpareReturn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), (List <TB_RETURN>)(grid.Detail1DataSource));
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("保存成功！");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
bs.EndEdit();
var detailList = (List <TB_INVENTORY_DETAIL>)bs.DataSource;
SpareEntities db = EntitiesFactory.CreateSpareInstance();
BillHandler.AddOrUpdateInventoryDetail(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), detailList);
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("保存成功！");
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
private void buttonItem1_Click(object sender, EventArgs e)
{
var tList = (BindingList <TS_ROLE_NOTIFYTYPE>)gridNotifyType.PrimaryGrid.DataSource;
_db.TS_ROLE_NOTIFYTYPE.AddOrUpdate(p => new { p.RoleCode, p.PortalCode, p.NotifyType }, tList.ToArray());
try
{
EntitiesFactory.SaveDb(_db);
MessageHelper.ShowInfo("角色权限保存成功:" + _selectedData.RoleName);
gridNotifyType.PrimaryGrid.ClearDirtyRowMarkers();
}
catch (Exception ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
}
private void btnDel_Click(object sender, EventArgs e)
{
if (_selectrow == null)
{
MessageHelper.ShowError("请选择要删除的附件！");
return;
}
if (MessageHelper.ShowQuestion("确认要删除选中的附件吗？") == DialogResult.Yes)
{
SpareEntities db = EntitiesFactory.CreateSpareInstance();
var attach = AttachController.GetList(_db).FirstOrDefault(p => p.UID == (int)_selectrow[gcUID].Value);
AttachController.Delete(db, attach, GlobalVar.Oper);
EntitiesFactory.SaveDb(db);
MessageHelper.ShowInfo("删除成功！");
RefreshData();
}
}
private void btnExecute_Click(object sender, EventArgs e)
{
if (_bill == null || _bill.单据编号 == null)
{
MessageHelper.ShowInfo("请选择单据！");
return;
}
if (MessageHelper.ShowQuestion("确定要执行选定的领用还回单？") == DialogResult.Yes)
{
SpareEntities db = EntitiesFactory.CreateSpareInstance();
var returnlist = db.TB_RETURN.Where(p => p.BillNum == _bill.单据编号).ToList();
BillHandler.ExecuteSpareReturn(db, _bill.VWToBill(GlobalVar.Oper.DeptCode), returnlist);
EntitiesFactory.SaveDb(db);
NotifyController.AddStockSafeQty(db, GlobalVar.Oper.OperName);
MessageHelper.ShowInfo("保存成功！");
}
}
/// <summary>
/// 添加【原料收货单】
/// </summary>
/// <param name="db"></param>
/// <param name="billList">原料收货单列表</param>
/// <param name="detailList">原料收货明细列表</param>
/// <returns></returns>
public static void AddMaterialIn(SpareEntities db, List <TB_BILL> billList,
List <TB_IN> detailList)
{
{
foreach (var bill in billList)
{
SetBillNum(bill); //设置单据编号
detailList.ForEach(p => p.BillNum = bill.BillNum); //设置明细编号
BillController.AddOrUpdate(db, bill); //添加【原料收货单】单据
SpareInController.AddList(db, detailList); //添加【原料收货单】明细
var stockDetails = detailList.Select(detail => detail.ToStockDetailIn(bill)).ToList();
StockDetailController.ListIn(db, bill, stockDetails); //更新【库存主表】【库存明细】
}
EntitiesFactory.SaveDb(db);
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
try
{
if (_bill == null || _bill.单据编号 == null)
{
MessageHelper.ShowInfo("请选择单据！");
return;
}
BillController.UpdateState(_db, _bill.VWToBill(GlobalVar.Oper.DeptCode), BillState.Cancelled);
EntitiesFactory.SaveDb(_db);
SetMasterDataSource(grid.PageIndex, grid.PageSize);
}
catch (Exception ex)
{
MessageHelper.ShowError(ex.ToString());
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
try
{
if (_bill.State != (int)BillState.New)
{
throw new WmsException(ResultCode.DataStateError, _bill.BillNum, "状态错误,不应为：" + _bill.State);
}
PoController.UpdateState(_db, _bill, BillState.Cancelled); //更新状态为：取消
EntitiesFactory.SaveDb(_db);
SetMasterDataSource(grid.PageSize);
}
catch (Exception ex)
{
MessageHelper.ShowError(ex.ToString());
}
}
