public ActionResult Index(FormCollection form)
{
string sMacCode = iWork.Get_MacCodeByMacAddress();
string sWrkCode = comm.sGetString(form["wrk_code"]);
string sMoCode = comm.Get_QueryData("MET03_0000", sWrkCode, "wrk_code", "mo_code");
string station_Code = comm.Get_QueryData("MEB29_0000", sMacCode, "mac_code", "station_code");
string work_code = comm.Get_QueryData("MEB30_0100", station_Code, "station_code", "work_code");
string sUsrCode = iWork.Get_UserCodeByMacCode(sMacCode);
//寫入報工歷程檔 RowData
MED02_0000 med02_0000 = new MED02_0000();
comm.Upd_Data("MED02_0000", "wrk_code", sWrkCode, "mo_status_wrk", "END");
comm.Upd_Data("MED02_0000", "wrk_code", sWrkCode, "end_date", comm.Get_Date());
comm.Upd_Data("MED02_0000", "wrk_code", sWrkCode, "end_time", comm.Get_Time());
comm.Upd_Data("MED02_0000", "wrk_code", sWrkCode, "end_usr_code", comm.sGetString(sUsrCode));
//更新派工單狀態 為完工
iWork.Upd_MEM01Data(sMoCode, work_code, "work_time_e", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
//寫入報工歷程檔 RowData
comm.Set_ModelValue(med02_0000, form);
med02_0000.mo_code = sMoCode;
med02_0000.wrk_code = sWrkCode;
med02_0000.mac_code = comm.sGetString(sMacCode);
med02_0000.ins_date = comm.Get_Date();
med02_0000.ins_time = comm.Get_Time();
med02_0000.usr_code = comm.sGetString(sUsrCode);
med02_0000.mo_status_wrk = "END";
med02_0000.des_memo = "";
med02_0000.is_ng = "N";
med02_0000.is_end = "N";
med02_0000.end_memo = "";
med02_0000.end_date = "";
med02_0000.end_time = "";
med02_0000.user_field_01 = form["user_field_01"];
med02_0000.user_field_02 = form["user_field_02"];
med02_0000.user_field_03 = form["user_field_03"];
med02_0000.user_field_04 = form["user_field_04"];
med02_0000.user_field_05 = form["user_field_05"];
med02_0000.user_field_06 = form["user_field_06"];
med02_0000.user_field_07 = form["user_field_07"];
med02_0000.user_field_08 = form["user_field_08"];
med02_0000.user_field_09 = form["user_field_09"];
med02_0000.user_field_10 = form["user_field_10"];
if (form["user_field_01"] == null)
{
med02_0000.user_field_01 = "";
}
if (form["user_field_02"] == null)
{
med02_0000.user_field_02 = "";
}
if (form["user_field_03"] == null)
{
med02_0000.user_field_03 = "";
}
if (form["user_field_04"] == null)
{
med02_0000.user_field_04 = "";
}
if (form["user_field_05"] == null)
{
med02_0000.user_field_05 = "";
}
if (form["user_field_06"] == null)
{
med02_0000.user_field_06 = "";
}
if (form["user_field_07"] == null)
{
med02_0000.user_field_07 = "";
}
if (form["user_field_08"] == null)
{
med02_0000.user_field_08 = "";
}
if (form["user_field_09"] == null)
{
med02_0000.user_field_09 = "";
}
if (form["user_field_10"] == null)
{
med02_0000.user_field_10 = "";
}
med02_0000.end_usr_code = "";
med02_0000.InsertData(med02_0000);
//iWork.Upd_MEM01Data(sMoCode, work_code, "mac_code", sMacCode);
//iWork.Upd_MEM01Data(sMoCode, work_code, "station_code", station_Code);
//comm.Upd_Data("MEM01_0000", "work_code", work_code, "work_time_e", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
//string sSql = "select DATEDIFF(N,work_time_s,work_time_e) as a " +
// " from MEM01_0000 " +
// " where work_code = '" + work_code + "' " +
// " AND mo_code='" + sMoCode + "' ";
//var dtDat = comm.Get_DataTable(sSql);
//string date_diff = dtDat.Rows[0]["a"].ToString();
//// string date_diff = comm.Get_QueryData("MEM01_0000", work_code, "work_code", " ").ToString();
//comm.Upd_Data("MEM01_0000", "work_code", work_code, "work_sec", date_diff);
//更新派工單狀態 為完工
iWork.Upd_WrkStatus(sWrkCode, "END");
string sLastWrkCode = med02_0000.Get_LastWrkCode(sMoCode);
if (sWrkCode == sLastWrkCode)
{
med02_0000.Upd_MET01_0000_MoEndDate(sMoCode);
}
comm.Upd_Data("MED08_0000", "wrk_code", sWrkCode, "date_e", comm.Get_Date());
comm.Upd_Data("MED08_0000", "wrk_code", sWrkCode, "time_e", comm.Get_Time());
return(RedirectToAction("Index"));
}
public ActionResult Index(FormCollection form)
{
string sMacCode = iWork.Get_MacCodeByMacAddress();
string sWrkCode = comm.sGetString(form["wrk_code"]);
string sMoCode = comm.Get_QueryData("MET03_0000", sWrkCode, "wrk_code", "mo_code");
string station_Code = comm.Get_QueryData("MEB29_0200", sMacCode, "mac_code", "station_code");
string work_code = comm.Get_QueryData("MEB30_0100", station_Code, "station_code", "work_code");
string sUsrCode = iWork.Get_UserCodeByMacCode(sMacCode);
//寫入報工歷程檔 RowData
MED02_0000 med02_0000 = new MED02_0000();
comm.Set_ModelValue(med02_0000, form);
med02_0000.mo_code = sMoCode;
med02_0000.wrk_code = sWrkCode;
med02_0000.mac_code = comm.sGetString(sMacCode);
med02_0000.ins_date = comm.Get_Date();
med02_0000.ins_time = comm.Get_Time();
med02_0000.usr_code = comm.sGetString(sUsrCode);
med02_0000.mo_status_wrk = "IN";
med02_0000.des_memo = "";
med02_0000.is_ng = "N";
med02_0000.is_end = "N";
med02_0000.end_memo = "";
med02_0000.end_date = "";
med02_0000.end_time = "";
med02_0000.end_usr_code = "";
med02_0000.InsertData(med02_0000);
//更新派工單狀態 為開工中
iWork.Upd_WrkStatus(sWrkCode, "IN");
//更新開工時間
iWork.Upd_MEM01Data(sMoCode, work_code, "work_time_s", DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
iWork.Upd_MEM01Data(sMoCode, work_code, "mac_code", sMacCode);
iWork.Upd_MEM01Data(sMoCode, work_code, "station_code", station_Code);
iWork.Upd_MEM01Data(sMoCode, work_code, "usr_code", sUsrCode);
//若MET01_0000中有開工時間則不更新,若如無開工時間則更新時間
if (!Chk_MET010000_MoStartDate(sMoCode))
{
med02_0000.Upd_MET01_0000_MoStartDate(sMoCode);
}
MED08_0000 med08_0000 = new MED08_0000();
comm.Set_ModelValue(med08_0000, form);
med08_0000.mo_code = sMoCode;
med08_0000.wrk_code = sWrkCode;
med08_0000.mac_code = comm.sGetString(sMacCode);
med08_0000.date_s = DateTime.Now.ToString("yyyy/MM/dd");
med08_0000.time_s = DateTime.Now.ToString("HH:mm:ss");
med08_0000.des_memo = "";
med08_0000.is_ng = "N";
med08_0000.is_end = "N";
med08_0000.end_memo = "";
med08_0000.end_date = "";
med08_0000.end_time = "";
med08_0000.end_usr_code = "";
med08_0000.user_field_01 = form["user_field_01"];
med08_0000.user_field_02 = form["user_field_02"];
med08_0000.user_field_03 = form["user_field_03"];
med08_0000.user_field_04 = form["user_field_04"];
med08_0000.user_field_05 = form["user_field_05"];
med08_0000.user_field_06 = form["user_field_06"];
med08_0000.user_field_07 = form["user_field_07"];
med08_0000.user_field_08 = form["user_field_08"];
med08_0000.user_field_09 = form["user_field_09"];
med08_0000.user_field_10 = form["user_field_10"];
if (form["user_field_01"] == null)
{
med08_0000.user_field_01 = "";
}
if (form["user_field_02"] == null)
{
med08_0000.user_field_02 = "";
}
if (form["user_field_03"] == null)
{
med08_0000.user_field_03 = "";
}
if (form["user_field_04"] == null)
{
med08_0000.user_field_04 = "";
}
if (form["user_field_05"] == null)
{
med08_0000.user_field_05 = "";
}
if (form["user_field_06"] == null)
{
med08_0000.user_field_06 = "";
}
if (form["user_field_07"] == null)
{
med08_0000.user_field_07 = "";
}
if (form["user_field_08"] == null)
{
med08_0000.user_field_08 = "";
}
if (form["user_field_09"] == null)
{
med08_0000.user_field_09 = "";
}
if (form["user_field_10"] == null)
{
med08_0000.user_field_10 = "";
}
med08_0000.InsertData(med08_0000);
////新增生產途程紀錄
//MEM01_0000 mem01_0000 = new MEM01_0000();
//mem01_0000.mo_code = sMoCode;
//mem01_0000.work_code = work_code;
//mem01_0000.station_code = station_Code;
//mem01_0000.mac_code = comm.sGetString(sMacCode);
//mem01_0000.work_time_s = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
//mem01_0000.work_time_e = "";
//mem01_0000.ok_qty = 0;
//mem01_0000.ng_qty = 0;
//mem01_0000.ng_unit = "";
//mem01_0000.ok_unit = "";
//mem01_0000.work_sec = 0;
//mem01_0000.usr_code = sUsrCode;
//mem01_0000.InsertData(mem01_0000);
return(RedirectToAction("Index"));
}
