protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj)
{
BenQGuru.eMES.Domain.MOModel.Item item = (BenQGuru.eMES.Domain.MOModel.Item)obj;
Infragistics.WebUI.UltraWebGrid.UltraGridRow row = new Infragistics.WebUI.UltraWebGrid.UltraGridRow(
new object[] { "false",
item.ItemCode,
item.ItemName, });
item = null;
return(row);
}
// private void ReadFileData()
// {
// System.IO.FileStream fs = null;
// System.IO.StreamReader sr = null;
// try
// {
// this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
//
// ClearDataRow();
//
// fs = new System.IO.FileStream(txtFileName.InnerTextBox.Text.Trim(),
// System.IO.FileMode.Open,System.IO.FileAccess.Read);
//
// sr = new System.IO.StreamReader(fs,System.Text.Encoding.Default);
//
// string line = sr.ReadLine();
// while(line != null && line != string.Empty)
// {
// string[] arr = line.Split(',');
// if(arr.Length != 9)
// {
// this.ErrorMsg("文件中内容格式错误");
// return;
// }
//
// arr[4] = DateStringConv(arr[4]);
// arr[8] = DateStringConv(arr[8]);
//
// this._tmpTable.Rows.Add(arr);
// line = sr.ReadLine();
// }
// this.SucessMsg("文件读取结束");
// }
// catch(System.IO.IOException ex)
// {
// this.ErrorMsg("读取文件出错 "+ex.Message);
// return;
// }
// finally
// {
// if(sr != null)
// sr.Close();
// if(fs != null)
// fs.Close();
//
// this.Cursor = System.Windows.Forms.Cursors.Default;
// }
// }
// private string DateStringConv(string datefrom)
// {
// string[] strList = datefrom.Split(new char[]{'.','-','/'});
// if(strList.Length != 3)
// throw new Exception("日期格式错误");
//
// return strList[0] + "-" + strList[1] + "-" + strList[2];
// }
#endregion
#endregion
#region 将出货单写到数据库中
private void btnSave_Click(object sender, System.EventArgs e)
{
try
{
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
this.DataProvider.BeginTransaction();
BenQGuru.eMES.Material.InventoryFacade facade = new InventoryFacade(this.DataProvider);
BenQGuru.eMES.MOModel.ItemFacade itemFacade = new ItemFacade(this.DataProvider);
BenQGuru.eMES.MOModel.ModelFacade modelFacade = new ModelFacade(this.DataProvider);
//一行行的写入
foreach (DataRow dr in this._tmpTable.Rows)
{
//判断是否已经做过采集
string shipNo = dr[0].ToString().ToUpper();
int shipSeq = int.Parse(dr[1].ToString());
string itemcode = dr["ItemCode"].ToString().ToUpper();
string partnercode = dr["PartnerCode"].ToString().ToUpper();
//判断此出货单是否存在(根据单号，产品代码，经销商代码）
object[] objs = facade.QueryInvShip(shipNo, itemcode, partnercode);
if (objs != null && objs.Length > 0)
{
InvShip shipt = objs[0] as InvShip;
if (shipt != null)
{
if (shipt.ShipStatus == ShipStatus.Shipped)
{
throw new Exception(shipNo + " $CS_Inv_Ship_has_Shiped"); //已经完成出货了，不能重新导入
}
if (shipt.ActQty > 0)
{
throw new Exception(shipNo + " $CS_Inv_Ship_has_Collected"); //已经做过出货采集，请先将采集的序列号删除
}
facade.DeleteInvShip(shipNo, itemcode, partnercode);
}
}
//int count = this.DataProvider.GetCount(new SQLCondition(string.Format("select count(*) from TBLINVRCARD where 1=1 and shipNo ='{0}' and shipSeq={1}" , shipNo,shipSeq)));
//if(count > 0)
// throw new Exception(shipNo + "这个出货单已经做过出货采集，不能重新导入");
//判断此出货单是否存在
//count = this.DataProvider.GetCount(new SQLCondition(string.Format("select count(*) from TBLINVSHIP where 1=1 and shipNo = '{0}' " , shipNo)));
//if(count > 0)
//{
// this.DataProvider.CustomExecute(new SQLCondition(string.Format("delete from tblinvship where shipNo='{0}'",shipNo)));
//}
//将这行数据写入到数据库
InvShip ship = facade.CreateNewInvShip();
ship.ActQty = 0;
ship.ItemCode = dr[8].ToString();
BenQGuru.eMES.Domain.MOModel.Item item = itemFacade.GetItem(ship.ItemCode, GlobalVariables.CurrentOrganizations.First().OrganizationID) as BenQGuru.eMES.Domain.MOModel.Item;
if (item != null)
{
ship.ItemDesc = item.ItemDescription;
BenQGuru.eMES.Domain.MOModel.Model model = modelFacade.GetModelByItemCode(item.ItemCode) as BenQGuru.eMES.Domain.MOModel.Model;
if (model != null)
{
ship.ModelCode = model.ModelCode;
}
else
{
ship.ModelCode = " ";
}
}
else
{
ship.ItemDesc = string.Empty;
}
ship.MainitainUser = ApplicationService.Current().UserCode;
//Laws Lu,2006/11/13 uniform system collect date
DBDateTime dbDateTime;
dbDateTime = FormatHelper.GetNowDBDateTime(DataProvider);
ship.MaintainDate = dbDateTime.DBDate;
ship.MaintainTime = dbDateTime.DBTime;
ship.PartnerCode = dr[3].ToString().ToUpper();
ship.PartnerDesc = dr[4].ToString();
ship.PlanQty = int.Parse(dr[9].ToString());
ship.ShipDate = FormatHelper.TODateInt(dr[7].ToString());
ship.ShipNo = dr[0].ToString().ToUpper();
ship.ShipStatus = ShipStatus.Shipping;
ship.ShipDesc = string.Empty;
ship.ShipInnerType = BenQGuru.eMES.Material.ReceiveInnerType.Normal;
ship.ShipType = dr[2].ToString();
ship.ShipUser = string.Empty;
ship.PrintDate = FormatHelper.TODateInt(dr[10].ToString());
ship.ShipSeq = shipSeq;
ship.CustomerOrderNo = dr[5].ToString().ToUpper();
ship.ShipMethod = dr[6].ToString().ToUpper();
facade.AddInvShip2(ship);
}
this.DataProvider.CommitTransaction();
this.SucessMsg("$CS_Save_Success");
}
catch (System.Exception ex)
{
this.DataProvider.RollbackTransaction();
this.ErrorMsg(ex.Message);
}
finally
{
this.Cursor = System.Windows.Forms.Cursors.Default;
}
}
/// <summary>
/// 补齐没有来源又必填的栏位
/// </summary>
/// <param name="obj"></param>
/// <param name="type"></param>
/// <returns></returns>
public object FillImportObject(object obj, string type)
{
if (obj == null)
{
return(null);
}
switch (type)
{
case "Item":
#region Item
ImpItem impitem = obj as ImpItem;
BenQGuru.eMES.Domain.MOModel.Item item = new BenQGuru.eMES.Domain.MOModel.Item();
item.ItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impitem.ItemCode));
item.ItemName = FormatHelper.CleanString(impitem.ItemName);
//item.ItemType = FormatHelper.CleanString(impitem.ItemType);
item.ItemDescription = FormatHelper.CleanString(impitem.ItemDescription);
item.ItemUOM = FormatHelper.CleanString(impitem.ItemUOM);
if (string.Compare(FormatHelper.CleanString(impitem.ItemType), "1", true) == 0)
{
item.ItemType = ItemType.ITEMTYPE_FINISHEDPRODUCT;
}
else
{
item.ItemType = ItemType.ITEMTYPE_SEMIMANUFACTURE;
}
item.MaintainUser = ImportUser;
item.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
item.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
item.ItemUser = ImportUser;
item.ItemDate = item.MaintainDate;
item.OrganizationID = GlobalVariables.CurrentOrganizations.First().OrganizationID;
return(item);
#endregion
case "Model2Item":
#region Model2Item
ImpModel2Item impmodel2item = obj as ImpModel2Item;
BenQGuru.eMES.Domain.MOModel.Model2Item model2Item = new BenQGuru.eMES.Domain.MOModel.Model2Item();
model2Item.ItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmodel2item.ItemCode));
model2Item.ModelCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmodel2item.ModelCode));
model2Item.MaintainUser = ImportUser;
model2Item.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
model2Item.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
model2Item.OrganizationID = GlobalVariables.CurrentOrganizations.First().OrganizationID;
return(model2Item);
#endregion
case "SBOM":
#region SBOM
ImpSBOM impsbom = obj as ImpSBOM;
BenQGuru.eMES.Domain.MOModel.SBOM sbom = new BenQGuru.eMES.Domain.MOModel.SBOM();
sbom.ItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impsbom.ItemCode));
sbom.SBOMItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impsbom.SBOMItemCode));
sbom.SBOMItemECN = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impsbom.SBOMItemECN));
sbom.SBOMItemEffectiveDate = impsbom.SBOMItemEffectiveDate;
sbom.SBOMItemInvalidDate = impsbom.SBOMItemInvalidDate;
sbom.SBOMItemLocation = FormatHelper.CleanString(impsbom.SBOMItemLocation);
sbom.SBOMItemName = FormatHelper.CleanString(impsbom.SBOMItemName);
sbom.SBOMItemQty = impsbom.SBOMItemQty;
sbom.SBOMItemUOM = FormatHelper.CleanString(impsbom.SBOMItemUOM);
sbom.SBOMSourceItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impsbom.SBOMSourceItemCode));
sbom.SBOMWH = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impsbom.SBOMWH));
sbom.SBOMParentItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impsbom.SBOMParentItemCode));
sbom.Sequence = 0;
sbom.SBOMItemControlType = ItemControlType.ITEMCONTROLTYPE_LOT;
sbom.SBOMItemStatus = "0";
sbom.MaintainUser = ImportUser;
sbom.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
sbom.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
sbom.OrganizationID = GlobalVariables.CurrentOrganizations.First().OrganizationID;
return(sbom);
#endregion
case "MO":
#region MO
ImpMO impmo = obj as ImpMO;
BenQGuru.eMES.Domain.MOModel.MO mo = new BenQGuru.eMES.Domain.MOModel.MO();
mo.MOCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmo.MOCode));
// switch( FormatHelper.PKCapitalFormat( FormatHelper.CleanString(impmo.MOType) ) )
// {
// case "N":
// case "F":
// mo.MOType = MOType.MOTYPE_NORMALMOTYPE;
// break;
// case "R":
// mo.MOType = MOType.MOTYPE_REWORKMOTYPE;
// break;
// default:
// mo.MOType = MOType.MOTYPE_NORMALMOTYPE;
// break;
// }
mo.MOType = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmo.MOType));
mo.ItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmo.ItemCode));
mo.MOMemo = FormatHelper.CleanString(impmo.MOMemo);
mo.MOPlanEndDate = impmo.MOPlanEndDate;
mo.MOPlanQty = impmo.MOPlanQty;
mo.MOPlanStartDate = impmo.MOPlanStartDate;
mo.Factory = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmo.Factory));
mo.CustomerCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmo.CustomerCode));
mo.CustomerOrderNO = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmo.CustomerOrderNO));
mo.MOStatus = MOManufactureStatus.MOSTATUS_INITIAL;
mo.MOVersion = "1.0";
mo.IDMergeRule = 1;
mo.IsControlInput = FormatHelper.TRUE_STRING;
mo.IsCompareSoft = 0;
mo.IsBOMPass = FormatHelper.FALSE_STRING;
mo.MOImportDate = FormatHelper.TODateInt(DateTime.Now);
mo.MOImportTime = FormatHelper.TOTimeInt(DateTime.Now);
mo.MODownloadDate = FormatHelper.TODateInt(DateTime.Now);
mo.MaintainUser = ImportUser;
mo.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
mo.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
mo.OrganizationID = GlobalVariables.CurrentOrganizations.First().OrganizationID;
return(mo);
#endregion
case "MOBOM":
#region MOBOM
ImpMOBOM impmobom = obj as ImpMOBOM;
BenQGuru.eMES.Domain.MOModel.MOBOM mobom = new BenQGuru.eMES.Domain.MOModel.MOBOM();
mobom.MOCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmobom.MOCode));
mobom.MOBOMItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmobom.MOBOMItemCode));
mobom.MOBOMItemName = impmobom.MOBOMItemName;
mobom.MOBOMItemQty = impmobom.MOBOMItemQty;
mobom.MOBOMItemUOM = FormatHelper.CleanString(impmobom.MOBOMItemUOM);
mobom.MOBOMSourceItemCode = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(impmobom.MOBOMSourceItemCode));
mobom.MOBOMItemEffectiveDate = FormatHelper.TODateInt(DateTime.Now);
mobom.MOBOMItemEffectiveTime = FormatHelper.TOTimeInt(DateTime.Now);
mobom.MOBOMItemInvalidDate = FormatHelper.TODateInt(DateTime.MaxValue);
mobom.MOBOMItemInvalidTime = FormatHelper.TOTimeInt(DateTime.MaxValue);
mobom.MOBOMItemStatus = "0";
mobom.Sequence = 1;
mobom.MaintainUser = ImportUser;
mobom.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
mobom.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
return(mobom);
#endregion
case "ERPBOM":
#region ERPBOM
ImpERPBOM imperpbom = obj as ImpERPBOM;
BenQGuru.eMES.Domain.MOModel.ERPBOM erpbom = new BenQGuru.eMES.Domain.MOModel.ERPBOM();
erpbom.MOCODE = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(imperpbom.MOCODE));
erpbom.BITEMCODE = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(imperpbom.BITEMCODE));
erpbom.BQTY = imperpbom.BQTY;
erpbom.LOTNO = imperpbom.LOTNO;
erpbom.SEQUENCE = imperpbom.SEQUENCE;
erpbom.MaintainUser = ImportUser;
erpbom.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
erpbom.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);
return(erpbom);
#endregion
default:
return(null);
}
}
