protected void cmdDelete_ServerClick(object sender, EventArgs e)
{
if (_WarehouseFacade == null)
{
_WarehouseFacade = new BenQGuru.eMES.Material.WarehouseFacade(base.DataProvider);
}
if (inventoryFacade == null)
{
inventoryFacade = new BenQGuru.eMES.Material.InventoryFacade(base.DataProvider);
}
ArrayList array = this.gridHelper.GetCheckedRows();
if (array == null)
{
return;
}
List <BenQGuru.eMES.Domain.Warehouse.PickDetail> ll = new List <BenQGuru.eMES.Domain.Warehouse.PickDetail>();
foreach (GridRecord row in array)
{
BenQGuru.eMES.Domain.Warehouse.PickDetail obj = (BenQGuru.eMES.Domain.Warehouse.PickDetail)_WarehouseFacade.GetPickdetail(txtPickNoQuery.Text, row.Items.FindItemByKey("PICKLINE").Text);
if (obj.Status != "Release")
{
WebInfoPublish.Publish(this, obj.PickNo + "状态不为初始化！", this.languageComponent1); return;
}
if (inventoryFacade.GetPickDetailMaterialsCount(obj.PickNo, obj.PickLine) > 0)
{
WebInfoPublish.Publish(this, obj.PickNo + ":" + obj.PickLine + "正在拣料中，不能删除！", this.languageComponent1);
return;
}
ll.Add(obj);
}
try
{
this.DataProvider.BeginTransaction();
foreach (BenQGuru.eMES.Domain.Warehouse.PickDetail p in ll)
{
_WarehouseFacade.DeletePickToPo(p.PickNo, p.PickLine); //add by sam
_WarehouseFacade.DeletePickdetail(p);
}
this.DataProvider.CommitTransaction();
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
throw ex;
}
}
//Bind产品别下拉列表
private void BindModel(BenQGuru.eMES.Common.Domain.IDomainDataProvider provider, UserControl.UCLabelCombox cbx)
{
cbx.ComboBoxData.Items.Clear();
this.cbxItemCode.ComboBoxData.Items.Clear();
this.txtItemDesc.InnerTextBox.Text = string.Empty;
//只列出可入库的产品别
object[] objs = new BenQGuru.eMES.Material.InventoryFacade(this.DataProvider).GetInventoryModel();
if (objs != null)
{
foreach (object obj in objs)
{
BenQGuru.eMES.Domain.MOModel.Model model = obj as BenQGuru.eMES.Domain.MOModel.Model;
if (model != null)
{
cbx.AddItem(model.ModelCode, model.ModelCode);
}
}
}
}
protected override object GetEditObject(GridRecord row)
{
if (_InventoryFacade == null)
{
_InventoryFacade = new InventoryFacade(this.DataProvider);
}
if (_WarehouseFacade == null)
{
_WarehouseFacade = new WarehouseFacade(base.DataProvider);
}
string checkNo = row.Items.FindItemByKey("CheckNo").Text;
StockCheck check = (StockCheck)_WarehouseFacade.GetStockCheck(checkNo);
if (check != null)
{
return(check);
}
return(null);
}
protected override void DeleteDomainObjects(ArrayList domainObjects)
{
if (_WarehouseFacade == null)
{
_WarehouseFacade = new WarehouseFacade(base.DataProvider);
}
if (_InventoryFacade == null)
{
_InventoryFacade = new InventoryFacade(this.DataProvider);
}
StockCheck[] stockChecks = ((StockCheck[])domainObjects.ToArray(typeof(StockCheck)));
foreach (StockCheck s in stockChecks)
{
if (s.STATUS != "WaitCheck")
{
WebInfoPublish.Publish(this, s.CheckNo + "状态必须是待盘点才能删除！", this.languageComponent1); return;
}
}
try
{
this.DataProvider.BeginTransaction();
foreach (StockCheck s in stockChecks)
{
_WarehouseFacade.DeleteStockCheck(s);
}
this.DataProvider.CommitTransaction();
WebInfoPublish.Publish(this, "删除成功！", this.languageComponent1);
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
throw ex;
}
}
private void GetAllItem()
{
try
{
string fileName = string.Empty;
#region new
#region File
if (_facade == null)
{
_facade = new MOModel.ItemFacade(base.DataProvider);
}
if (inventoryFacade == null)
{
inventoryFacade = new BenQGuru.eMES.Material.InventoryFacade(base.DataProvider);
}
string upfileName = "";
BenQGuru.eMES.Domain.Warehouse.InvDoc doc = new BenQGuru.eMES.Domain.Warehouse.InvDoc();
if (this.DownLoadPathBom.PostedFile != null)
{
string stno = "MaterialImport";// FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtASNSTNOQuery.Text));
HttpPostedFile postedFile = this.DownLoadPathBom.PostedFile;
string path = Server.MapPath(this.VirtualHostRoot + "InvDoc/" + "物料维护/");
DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(base.DataProvider);
//string CARINVNO = row.Items.FindItemByKey("CARINVNO").Text;
doc.InvDocNo = stno;
doc.InvDocType = "MaterialImport";//FMaterialMP
string[] part = postedFile.FileName.Split(new char[] { '/', '\\' });
doc.DocType = Path.GetExtension(postedFile.FileName);
doc.DocName = Path.GetFileNameWithoutExtension(postedFile.FileName);
doc.DocSize = postedFile.ContentLength / 1024;
doc.UpUser = GetUserCode();
doc.UpfileDate = FormatHelper.TODateInt(DateTime.Now);
doc.Dirname = "物料维护";
doc.MaintainUser = this.GetUserCode();
doc.MaintainDate = dbDateTime.DBDate;
doc.MaintainTime = dbDateTime.DBTime;
doc.ServerFileName = doc.DocName + "_" + stno + DateTime.Now.ToString("yyyyMMddhhmmss") + doc.DocType;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
fileName = doc.ServerFileName;
upfileName = path + fileName;
this.DownLoadPathBom.PostedFile.SaveAs(upfileName);
}
else
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.PublishInfo(this, "导入文件不能为空", this.languageComponent1);
return;
}
#endregion
this.UploadedFileName = upfileName;
#endregion
DBDateTime dbTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
if (this.ViewState["UploadedFileName"] == null)
{
WebInfoPublish.Publish(this, "$Error_UploadFileIsEmpty", this.languageComponent1);
//BenQGuru.eMES.Common.ExceptionManager.Raise(this.GetType().BaseType, "$Error_UploadFileIsEmpty");
}
fileName = this.ViewState["UploadedFileName"].ToString();
//读取EXCEL格式文件
System.Data.DataTable dt = GetExcelData(fileName);
if ((dt != null) && (dt.Rows.Count > 0))
{
for (int t = 0; t < dt.Rows.Count; t++)
{
string dqmcode = dt.Rows[t][0].ToString().Trim(); //物料号
string validity = dt.Rows[t][1].ToString().Trim(); //有效期
if (validity.Length > 10)
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.Publish(this, "$Error_VALID_DAY_NOT_MORE_THREE", this.languageComponent1);
return;
}
if (!IsInt(validity))
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.Publish(this, "鼎桥物料号" + dqmcode + "有效期必须是数值型", this.languageComponent1);
return;
}
BenQGuru.eMES.Domain.MOModel.Material material =
_facade.GetMaterialByDQMCode(dqmcode) as BenQGuru.eMES.Domain.MOModel.Material;
if (material != null)
{
material.Validity = Convert.ToInt32(FormatHelper.CleanString(validity, 100));
material.MaintainDate = dbTime.DBDate;
material.MaintainTime = dbTime.DBTime;
material.MaintainUser = this.GetUserCode();
this._facade.UpdateMaterial(material);
}
else
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.Publish(this, dqmcode + "EXCEL表中鼎桥物料号不存在", this.languageComponent1);
return;
}
}
this.DataProvider.CommitTransaction();
WebInfoPublish.Publish(this, "导入成功！", this.languageComponent1);
}
else
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.Publish(this, "导入内容不能为空", this.languageComponent1);//add by sam
}
}
catch (Exception ex)
{
this.DataProvider.RollbackTransaction();
WebInfoPublish.PublishInfo(this, ex.Message, this.languageComponent1);
}
}
