/// <summary>
///物料 供应商 批次/SN 数量 工位 生产线
/// </summary>
/// <returns>int</returns>
public static bool OutOfStorage(string itemCode, string vendorCode, string SN, string locationCode, string plineCode, float itemQTY)
{
try
{
LineSideStockEntity temp = new LineSideStockEntity();
LineSideStockDal lsDal = new LineSideStockDal();
temp = lsDal.GetByItem(locationCode, plineCode, itemCode);
if (temp == null)
{
Rmes.Public.ErrorHandle.EH.LASTMSG = "没有物料" + itemCode + "的相关记录，无法进行出库操作！\n";
lsDal.DataBase.AbortTransaction();
return(false);
}
else
{
temp.ITEM_QTY = temp.ITEM_QTY - itemQTY;
if (temp.ITEM_QTY < 0)
{
Rmes.Public.ErrorHandle.EH.LASTMSG = itemCode + "库存不足，无法进行出库操作！\n";
lsDal.DataBase.AbortTransaction();
return(false);
}
lsDal.Update(temp);
return(true);
}
}
catch (Exception e)
{
Rmes.Public.ErrorHandle.EH.LASTMSG = e.Message;
return(false);
}
}
/// <summary>
/// 函数说明：入库操作，返回影响的行数
/// </summary>
///
/// <returns>int</returns>
public static bool Storage(string itemCode, string vendorCode, string SN, string locationCode, string plineCode, float itemQTY)
{
LineSideStockEntity item = new LineSideStockEntity()
{
COMPANY_CODE = LoginInfo.UserInfo.COMPANY_CODE,
LOCATION_CODE = locationCode,
ITEM_CODE = itemCode,
VENDOR_CODE = vendorCode,
PLINE_CODE = plineCode,
ITEM_QTY = itemQTY
};
LineSideStockEntity temp = new LineSideStockEntity();
LineSideStockDal lsDal = new LineSideStockDal();
temp = lsDal.GetByItem(locationCode, plineCode, itemCode);
if (temp == null)
{
lsDal.Insert(item);
return(true);
}
else
{
temp.ITEM_QTY += item.ITEM_QTY;
lsDal.Update(temp);
return(true);
}
}
private void setCondition()
{
if (PlanCode.SelectedIndex < 0)
{
return;
}
List <string> stores = new System.Collections.Generic.List <string>();
string planCode = PlanCode.SelectedItem.Value.ToString();
List <PlanBomEntity> allEntities = PlanBOMFactory.GetByOrderCode(planCode);
List <LineSideStockEntity> dataSource = new List <LineSideStockEntity>();
foreach (var a in allEntities)
{
LineSideStockEntity ls = LineSideStockFactory.GetStoreItem(a.LINESIDE_STOCK_CODE, a.ITEM_CODE);
if (ls != null)
{
dataSource.Add(ls);
if (!stores.Contains(a.RESOURCE_STORE))
{
stores.Add(a.RESOURCE_STORE);//添加采购虚拟区
}
}
}
ASPxGridView1.DataSource = dataSource;
ASPxGridView1.DataBind();
DestinationStore.Items.Clear();
DestinationStore.Items.Add("CGXN", "CGXN");
foreach (var s in stores)
{
DestinationStore.Items.Add(s, s);
}
}
private void btnReceive_Click(object sender, EventArgs e)
{
LineSideStockEntity ent = new LineSideStockEntity()
{
COMPANY_CODE = CompanyCode,
PLINE_CODE = PlineCode,
STORE_CODE = LinesideStockCode,
STORE_NAME = LinesideStockName,
LOCATION_CODE = WorkunitCode,
WORKSHOP_CODE = WorkshopCode
};
FrmIssueReceived frmIssue = new FrmIssueReceived(ent);
frmIssue.ShowDialog();
InitLinesideStock();
}
public static string TransToWMSStore(string planCode, string resourceStore, string itemCode, string destinationStore, int transQTY)
{
DB.GetInstance().BeginTransaction();
try
{
List <PlanBomEntity> planBOMs = PlanBOMFactory.GetByOrderCode(planCode);
planBOMs = (from p in planBOMs where p.ITEM_CODE == itemCode && p.LINESIDE_STOCK_CODE == resourceStore select p).ToList <PlanBomEntity>();
List <LineSideStockEntity> all = DB.GetInstance().Fetch <LineSideStockEntity>("");
PlanBomEntity resouece = planBOMs[0];
LineSideStockEntity rsourceStore = LineSideStockFactory.GetStoreItem(resourceStore, itemCode);
LineSideStockEntity destination = LineSideStockFactory.GetStoreItem(destinationStore, itemCode);
rsourceStore.ITEM_QTY = rsourceStore.ITEM_QTY - transQTY;
DB.GetInstance().Update(rsourceStore);
IMESLine2LineEntity line2lineEntity = new IMESLine2LineEntity
{
AUFNR = resouece.ORDER_CODE,
WERKS = resouece.FACTORY,
VORNR = resouece.PROCESS_CODE,
SUBMAT = resouece.ITEM_CODE,
MENGE = transQTY.ToString(),
TLGORT = destinationStore,
SLGORT = resourceStore,
PRIND = "0",
};
DB.GetInstance().Insert(line2lineEntity);
SAPMessageTransEntity msgEntity = new SAPMessageTransEntity
{
MESSAGE_CODE = "0047",
WORK_DATE = DateTime.Now,
HANDLE_FLAG = "0",
};
DB.GetInstance().Insert(msgEntity);
DB.GetInstance().CompleteTransaction();
return("true");
}
catch (Exception e)
{
DB.GetInstance().AbortTransaction();
return(e.Message);
}
}
private void setCondition()
{
if (PlanCode.SelectedIndex < 0)
{
return;
}
string planCode = PlanCode.SelectedItem.Value.ToString();
List <PlanBomEntity> allEntities = PlanBOMFactory.GetByOrderCode(planCode);
List <LineSideStockEntity> dataSource = new List <LineSideStockEntity>();
foreach (var a in allEntities)
{
LineSideStockEntity ls = LineSideStockFactory.GetStoreItem(a.LINESIDE_STOCK_CODE, a.ITEM_CODE);
if (ls != null)
{
dataSource.Add(ls);
}
}
ASPxGridView1.DataSource = dataSource;
ASPxGridView1.DataBind();
}
/// <summary>
/// 函数说明：入库操作，返回影响的行数
/// </summary>
///
/// <returns>int</returns>
public static int Storage(LineSideStockEntity item)
{
int result;
LineSideStockEntity temp = new LineSideStockEntity();
LineSideStockDal lsDal = new LineSideStockDal();
temp = lsDal.GetByItem(item.LOCATION_CODE, item.PLINE_CODE, item.ITEM_CODE);
if (temp == null)
{
lsDal.Insert(item);
result = 1;
}
else
{
temp.ITEM_QTY += item.ITEM_QTY;
result = lsDal.Update(temp);
}
//插入收料流水
IssueReceivedEntity ent = new IssueReceivedEntity()
{
COMPANY_CODE = item.COMPANY_CODE,
WORKSHOP_CODE = item.WORKSHOP_CODE,
PLINE_CODE = item.PLINE_CODE,
LOCATION_CODE = item.LOCATION_CODE,
LINESIDE_STOCK_CODE = item.STORE_CODE,
ITEM_CODE = item.ITEM_CODE,
ITEM_NAME = item.ITEM_NAME,
ITEM_QTY = item.ITEM_QTY,
WORK_TIME = DateTime.Now,
USER_ID = LoginInfo.UserInfo.USER_ID
};
new IssueReceivedDal().Insert(ent);
return(result);
}
/// <summary>
/// 函数说明：批量入库操作，返回影响的行数
/// </summary>
///
/// <returns>int</returns>
public static int Storage(List <LineSideStockEntity> itemList)
{
int result = 0;
LineSideStockDal lsDal = new LineSideStockDal();
lsDal.DataBase.BeginTransaction();
foreach (LineSideStockEntity lsEntity in itemList)
{
LineSideStockEntity temp = new LineSideStockEntity();
temp = lsDal.GetByItem(lsEntity.LOCATION_CODE, lsEntity.PLINE_CODE, lsEntity.ITEM_CODE);
if (temp == null)
{
lsDal.Insert(lsEntity);
result += 1;
}
else
{
temp.ITEM_QTY += lsEntity.ITEM_QTY;
result += lsDal.Update(temp);
}
}
lsDal.DataBase.CompleteTransaction();
return(result);
}
public frmBomEmerg(LineSideStockEntity entity)
{
InitializeComponent();
ent = entity;
}
public int Update(LineSideStockEntity item)
{
return(db.Update(item));
}
public void Insert(LineSideStockEntity item)
{
db.Insert("DATA_LINESIDE_STOCK", "RMES_ID", item);
}
public FrmIssueReceived(LineSideStockEntity entity)
{
InitializeComponent();
ent = entity;
}
