protected void bt1_Click(object sender, EventArgs e)
{
db.Execute("call SAP_HANDLE_EXPORT_BOM()");//43
SAPMessageTransEntity msgEntity = new SAPMessageTransEntity
{
MESSAGE_CODE = "0043",
WORK_DATE = DateTime.Now,
HANDLE_FLAG = "0",
};
DB.GetInstance().Insert(msgEntity);
}
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);
}
}
public static void Insert(IMESPlanChangeEntity changes)
{
IMESPlanChangeDal dal = new IMESPlanChangeDal();
List <SAPMessageTransEntity> temp = DB.GetInstance().Fetch <SAPMessageTransEntity>("where MESSAGE_CODE = '0048' and HANDLE_FLAG!='0'");
if (temp != null || temp.Count > 0)
{
return;
}
dal.Insert(changes);
SAPMessageTransEntity msgEntity = new SAPMessageTransEntity
{
MESSAGE_CODE = "0048",
WORK_DATE = DateTime.Now,
HANDLE_FLAG = "0",
};
DB.GetInstance().Insert(msgEntity);
}
//public static bool SendOrder(string[] planCodes)
//{
// Database db=DB.GetInstance();
// //db.BeginTransaction();
// try
// {
// db.BeginTransaction();
// string batch_temp = "'B'||TO_CHAR(SYSDATE,'yyyymmdd')||to_char(SEQ_BATCHID.NEXTVAL,'fm0000')";
// string sql = "select " + batch_temp + " from dual";
// string batch_id = db.ExecuteScalar<string>(sql);
// DateTime time = DateTime.Now;
// int num = 0;
// List<ItemLineSideEntity> lineSideItem = ItemLineSideFactory.GetAll();
// foreach (var p in planCodes)
// {
// List<PlanBomEntity> boms = PlanBOMFactory.GetByPlanCode(p);
// if (lineSideItem != null)
// {
// boms = (from b in boms where !(lineSideItem.Select(m => m.ITEM_CODE).Contains(b.ITEM_CODE)) select b).ToList<PlanBomEntity>();
// }
// foreach (var b in boms)
// {
// PlanEntity plan = PlanFactory.GetByKey(b.PLAN_CODE);
// if (b.VIRTUAL_ITEM_CODE == "X") continue;
// IMESStore2LineEntity storeEntity = new IMESStore2LineEntity
// {
// AUFNR = plan.ORDER_CODE,
// WERKS = b.FACTORY,
// VORNR = b.PROCESS_CODE,
// SUBMAT = b.ITEM_CODE,
// MATKT = b.ITEM_NAME,
// MENGE = b.ITEM_QTY.ToString(),
// SLGORT = b.RESOURCE_STORE,
// TLGORT = b.LINESIDE_STOCK_CODE,
// PROJN=plan.PROJECT_CODE,
// SERIAL = time.ToString("yyyyMMddhhmmss"),
// WKDT = time,
// BATCH=batch_id,
// CHARG1=batch_id,
// CHARG2=batch_id,
// PRIND = "0"
// };
// db.Insert(storeEntity);
// num++;
// }
// string sql1="update IMES_DATA_STORE2LINE set KUNNR="+num+" where BATCH='"+batch_id+"'";
// db.Execute(sql1);
// List<PlanEntity> plans = PlanFactory.GetByPlanCodes(new string[]{p});
// foreach (var plan in plans)
// {
// plan.ITEM_FLAG = "B";
// db.Update(plan);
// }
// }
// SAPMessageTransEntity msgEntity = new SAPMessageTransEntity
// {
// MESSAGE_CODE = "0046",
// WORK_DATE = DateTime.Now,
// HANDLE_FLAG = "0",
// };
// db.Insert(msgEntity);
// db.CompleteTransaction();
// return true;
// }
// catch (Exception e)
// {
// db.AbortTransaction();
// return false;
// }
//}
public static bool SendOrder(List <PlanStandardBOMEntity> items, string userid)
{
Database db = DB.GetInstance();
try
{
db.BeginTransaction();
string batch_temp = "'B'||TO_CHAR(SYSDATE,'yyyymmdd')||to_char(SEQ_BATCHID.NEXTVAL,'fm0000')";
string sql = "select " + batch_temp + " from dual";
string batch_id = db.ExecuteScalar <string>(sql);
DateTime time = DateTime.Now;
int num = 0;
foreach (var i in items)
{
if (i.VIRTUAL_ITEM_CODE == "X")
{
continue;
}
EmergencyStore2LineEntity eEntity = new EmergencyStore2LineEntity
{
AUFNR = i.ORDER_CODE,
WERKS = i.WORKSHOP_CODE,
VORNR = i.PROCESS_CODE,
SUBMAT = i.ITEM_CODE,
MENGE = i.ITEM_QTY.ToString(),
SLGORT = i.STORE_ID,
TLGORT = i.LINESIDE_STOCK_CODE,
MATKT = i.ITEM_NAME,
SERIAL = DateTime.Now.ToString("yyyyMMddhhmmss"),
WKDT = DateTime.Now,
PRIND = "0",
BATCH = batch_id,
CREATE_USER_ID = userid
};
db.Insert(eEntity);
IMESStore2LineEntity storeEntity = new IMESStore2LineEntity
{
AUFNR = i.ORDER_CODE,
WERKS = i.WORKSHOP_CODE,
VORNR = i.PROCESS_CODE,
SUBMAT = i.ITEM_CODE,
MENGE = i.ITEM_QTY.ToString(),
SLGORT = i.STORE_ID,
TLGORT = i.LINESIDE_STOCK_CODE,
MATKT = i.ITEM_NAME,
SERIAL = DateTime.Now.ToString("yyyyMMddhhmmss"),
WKDT = DateTime.Now,
BATCH = batch_id,
CHARG1 = batch_id,
CHARG2 = batch_id,
PRIND = "0"
};
db.Insert(storeEntity);
num++;
}
string sql1 = "update IMES_DATA_STORE2LINE set KUNNR=" + num + " where BATCH='" + batch_id + "'";
db.Execute(sql1);
SAPMessageTransEntity msgEntity = new SAPMessageTransEntity
{
MESSAGE_CODE = "0046",
WORK_DATE = DateTime.Now,
HANDLE_FLAG = "0",
};
db.Insert(msgEntity);
db.CompleteTransaction();
return(true);
}
catch (Exception e)
{
db.AbortTransaction();
return(false);
}
}
public void ASPxGridView1_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
string _ids = e.Parameters;
string[] ids = _ids.Split(',');
//int index = Convert.ToInt32(e.Parameters);
//string rmesID = ASPxGridView1.GetRowValues(index, "RMES_ID").ToString();
DB.GetInstance().BeginTransaction();
try
{
string batch_temp = "'B'||TO_CHAR(SYSDATE,'yyyymmdd')||to_char(SEQ_BATCHID.NEXTVAL,'fm0000')";
string sql = "select " + batch_temp + " from dual";
string batch_id = DB.GetInstance().ExecuteScalar <string>(sql);
DateTime time = DateTime.Now;
int num = 0;
foreach (var id in ids)
{
ItemLineSideEntity entity = ItemLineSideFactory.GetByID(id);
ItemLineSideStore2LineEntity tempStoreEntity = new ItemLineSideStore2LineEntity
{
COMPANY_CODE = "01",
WORKSHOP = "8101",
ITEM_CODE = entity.ITEM_CODE,
ITEM_NAME = entity.ITEM_NAME,
ITEM_QTY = entity.STAND_QTY,
CREATE_TIME = DateTime.Now,
CREATE_USER_ID = theUserManager.getUserId(),
T_LINESIDESTORE = entity.LINESIDE_STORE_CODE,
S_LINESIDESTORE = entity.RESOURCE_STORE,
};
DB.GetInstance().Insert(tempStoreEntity);
IMESStore2LineEntity storeEntity = new IMESStore2LineEntity
{
WERKS = "8101",
AUFNR = DateTime.Now.ToString("yyyyMMdd").Insert(0, "A000"),
SUBMAT = entity.ITEM_CODE,
MATKT = entity.ITEM_NAME,
MENGE = entity.STAND_QTY.ToString(),
SLGORT = entity.RESOURCE_STORE,
TLGORT = entity.LINESIDE_STORE_CODE,
SERIAL = DateTime.Now.ToString("yyyyMMddhhmmss"),
WKDT = time,
BATCH = batch_id,
CHARG1 = batch_id,
CHARG2 = batch_id,
PRIND = "0"
};
DB.GetInstance().Insert(storeEntity);
num++;
SAPMessageTransEntity msgEntity = new SAPMessageTransEntity
{
MESSAGE_CODE = "0046",
WORK_DATE = DateTime.Now,
HANDLE_FLAG = "0",
};
DB.GetInstance().Insert(msgEntity);
}
string sql1 = "update IMES_DATA_STORE2LINE set KUNNR=" + num + " where BATCH='" + batch_id + "'";
DB.GetInstance().Execute(sql1);
DB.GetInstance().CompleteTransaction();
e.Result = "success";
}
catch (Exception ex)
{
DB.GetInstance().AbortTransaction();
e.Result = "false";
}
}
