/// <summary>取得TagLog資料</summary> public static DataTable GetTagLogList(string DockDoorID, string Status, Pages _page) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //判斷Status成功或失敗 Status = (Status == "Y" ? "'Y','A'" : Status); Status = (Status == "N" ? "'N','0'" : Status); //資料庫參數 var param = new DataBase.SqlParams(); param.Add("DockDoorID", DockDoorID); db.SqlParams = param; //條件式 string strWHERE = ""; if (!string.IsNullOrEmpty(DockDoorID)) { strWHERE += " AND DockDoorID = @DockDoorID "; } if (!string.IsNullOrEmpty(Status)) { strWHERE += " AND Status IN (" + Status + ") "; } //取回資料 int iTotal; var sql = "SELECT * FROM Innolux_TagLog WHERE 1=1" + strWHERE; var dt = db.ExecuteDataTable(sql, "ID DESC", _page.PageIndex, _page.PageSize, out iTotal); _page.TotalRows = iTotal; return(dt); } }
/// <summary>取得所有選單檔</summary> public static DataTable GetAllMenuList(bool?Enabled) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("Enabled", Enabled); db.SqlParams = param; //條件式 string strWHERE = ""; if (Enabled != null) { strWHERE += " AND Enabled = @Enabled "; } //取回資料 db.StrSQL = "SELECT * FROM Menu WHERE 1=1" + strWHERE + "ORDER BY OrderID"; var dt = db.ExecuteDataTable(); var dtNew = dt.Clone(); //依選單順序排列 foreach (var r in dt.Select("LEN(MenuNo) = 2", "OrderID")) { dtNew.Rows.Add(r.ItemArray); foreach (var r1 in dt.Select("LEN(MenuNo) = 4 AND MenuNo LIKE '" + r["MenuNo"].ToString() + "%'")) { dtNew.Rows.Add(r1.ItemArray); } } return(dtNew); } }
/// <summary>取得系統參數資料</summary> public static DataTable GetSysParams(string ParaCode, string ParaDesc, Pages _page) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("ParaCode", ParaCode); param.Add("ParaDesc", "%" + ParaDesc + "%"); db.SqlParams = param; //條件式 string strWHERE = ""; if (!string.IsNullOrEmpty(ParaCode)) { strWHERE += " AND ParaCode = @ParaCode "; } if (!string.IsNullOrEmpty(ParaDesc)) { strWHERE += " AND ParaDesc LIKE @ParaDesc "; } //取回資料 int iTotal; var sql = "SELECT * FROM [SysParams] WHERE 1=1" + strWHERE; var dt = db.ExecuteDataTable(sql, "ParaCode", _page.PageIndex, _page.PageSize, out iTotal); _page.TotalRows = iTotal; return(dt); } }
/// <summary>取得使用者清單資料檔</summary> public static DataTable GetUserLoginLog(string _account, string _ip, Pages _page) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("Account", _account); param.Add("IP", _ip); db.SqlParams = param; //條件式 string strWhere = ""; if (!string.IsNullOrEmpty(_account)) { strWhere += " AND Account = @Account "; } if (!string.IsNullOrEmpty(_ip)) { strWhere += " AND IP = @IP "; } //取回資料 int iTotal; var sql = "SELECT * FROM [UserLoginLog] WHERE 1=1 " + strWhere; var dt = db.ExecuteDataTable(sql, "LoginDate DESC", _page.PageIndex, _page.PageSize, out iTotal); _page.TotalRows = iTotal; return(dt); } }
/// <summary>取得使用者的選單權限</summary> public static DataTable GetUserMenuAuth(string Account) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("Account", Account); db.SqlParams = param; //取回資料 db.StrSQL = @"SELECT m.MenuNo, m.MenuName, m.MenuIco, m.OrderID, a.* FROM Menu m LEFT OUTER JOIN Auth a ON a.MenuNo = m.MenuNo AND a.Account = @Account ORDER BY OrderID"; var dt = db.ExecuteDataTable(); var dtNew = dt.Clone(); //依選單順序排列 foreach (var r in dt.Select("LEN(MenuNo) = 2", "OrderID")) { dtNew.Rows.Add(r.ItemArray); foreach (var r1 in dt.Select("LEN(MenuNo) = 4 AND MenuNo LIKE '" + r["MenuNo"].ToString() + "%'")) { dtNew.Rows.Add(r1.ItemArray); } } return(dtNew); } }
/// <summary>取得使用者權限檔</summary> public static DataTable GetUserAuthority(string _account) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("Account", _account); param.Add("Enabled", true); db.SqlParams = param; //取回資料 db.StrSQL = @"SELECT MenuNo, Convert(bit, MAX(Convert(int, [Add]))) [Add], Convert(bit, MAX(Convert(int, [Edit]))) [Edit], Convert(bit, MAX(Convert(int, [Del]))) [Del], Convert(bit, MAX(Convert(int, [Query]))) [Query], Convert(bit, MAX(Convert(int, [Audit]))) [Audit], Convert(bit, MAX(Convert(int, [Print]))) [Print], Convert(bit, MAX(Convert(int, [Export]))) [Export], Convert(bit, MAX(Convert(int, [Import]))) [Import], Convert(bit, MAX(Convert(int, [Admin]))) [Admin], Convert(bit, MAX(Convert(int, [Enabled]))) [Enabled] FROM( SELECT a.* FROM [Auth] a WHERE a.Account = @Account AND a.Enabled = @Enabled UNION ALL SELECT a.* FROM [Auth] a, [GroupUser] g WHERE a.GroupID = g.GroupID AND a.Enabled = @Enabled AND g.Account = @Account ) r GROUP BY MenuNo"; return(db.ExecuteDataTable()); } }
/// <summary>取得群組資料</summary> public static DataTable GetGroupList(string GroupID, string GroupName, Pages _page) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("GroupID", GroupID); param.Add("GroupName", "%" + GroupName + "%"); db.SqlParams = param; //條件式 string strWHERE = ""; if (!string.IsNullOrEmpty(GroupID)) { strWHERE += " AND GroupID = @GroupID "; } if (!string.IsNullOrEmpty(GroupName)) { strWHERE += " AND GroupName LIKE @GroupName "; } //取回資料 int iTotal; var sql = "SELECT * FROM [Group] WHERE 1=1" + strWHERE; var dt = db.ExecuteDataTable(sql, "GroupID", _page.PageIndex, _page.PageSize, out iTotal); _page.TotalRows = iTotal; return(dt); } }
public static DataTable GetSpecialTruckFilteredDetails(string TRUCK_NO) { DataTable dt = null; string Io_no = System.Web.Configuration.WebConfigurationManager.AppSettings["IO_No"]; using (var db = new DataBase.DataBase(Definition.Conn)) { var param = new DataBase.SqlParams(); param.Add("TRUCK_NO", TRUCK_NO); param.Add("IO_NO", Io_no); db.SqlParams = param; string strWHERE = ""; if (!string.IsNullOrEmpty(Io_no)) { strWHERE += " AND IO_NO = '" + Io_no + "' "; } db.StrSQL = "SELECT DISTINCT TRUCK_NO FROM WMS_RFID_TRUCK WHERE 1=1 AND (DOCKED IS NULL OR DOCKED='') AND TRUCK_NO = '" + TRUCK_NO + "'" + strWHERE; dt = db.ExecuteDataTable(); return(dt); } }
//public static void SaveDockDoorInfo(string truckID, string Status,string dockdoorID) //{ // string O_Status = null; // DataTable dt = null; // DataTable dt1 = null; // string IP = null; // int Total = 0; // int iNum = 0; // Result r = new Result(); // string ASN = null; // string DN = null; // string CaptionPanelIP = null; // try // { // //Save in ORACLE // using (var db = new DataBase.DataBase(Definition.Conn)) // { // db.StrSQL = "SELECT COUNT(PALLET_ID) Total, COUNT(RFID_OK_FLAG) iNum FROM WMS_RFID_CONTAINER_CHECK_V"; // DataTable dtable = db.ExecuteDataTable(); // DataRow dr = dtable.Rows[0]; // if (dtable.DefaultView.Count > 0) // { // Total = Convert.ToInt32(dr["Total"]); // iNum = Convert.ToInt32(dr["iNum"]); // } // db.ExecuteSQL(); // if (Status == "I") // { // db.StrSQL = "SELECT ASN_NO FROM WMS_RFID_TRUCK WHERE TRUCK_NO='" + truckID + "'"; // dt = db.ExecuteDataTable(); // DataRow dr_ASN = dt.Rows[0]; // if (dt.DefaultView.Count > 0) // { // ASN = dr_ASN["ASN_NO"].ToString(); // } // if (ASN != null && ASN != "") // { // db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS='I',DOCKED='" + dockdoorID + "' WHERE TRUCK_NO='" + truckID + "'"; // } // else // { // db.StrSQL = "SELECT DN_NO FROM WMS_RFID_CONTAINER_CHECK WHERE CONTAINER_NO='" + truckID + "'"; // dt1 = db.ExecuteDataTable(); // if (dt1.DefaultView.Count > 0) // { // DataRow DN_dr = dt1.Rows[0]; // DN = DN_dr["DN_NO"].ToString(); // if (DN != null && DN != "") // { // db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS='O',DOCKED='" + dockdoorID + "' WHERE TRUCK_NO='" + truckID + "'"; // } // } // else // { // db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS=' ',DOCKED='" + dockdoorID + "' WHERE TRUCK_NO='" + truckID + "'"; // } // } // db.ExecuteSQL(); // db.Commit(); // db.StrSQL = "SELECT STATUS FROM WMS_RFID_TRUCK WHERE TRUCK_NO='" + truckID + "'"; // DataTable dt2 = db.ExecuteDataTable(); // DataRow row = dt2.Rows[0]; // if (dt2.DefaultView.Count > 0) // { // O_Status = row["STATUS"].ToString(); // } // } // else // { // db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS='" + null + "',DOCKED='" + null + "' WHERE TRUCK_NO='" + truckID + "'"; // db.ExecuteSQL(); // } // } // //開啟資料庫存取物件 // using (var db = new DataBase.DataBase(Definition.Conn)) // { // var param = new DataBase.SqlParams(); // param.Add("ContainerID", truckID); // param.Add("ContainerStatus", O_Status); // param.Add("DockDoorID", dockdoorID); // DateTime dtime = DateTime.Now; // param.Add("UpdateTime", dtime); // if (Status == "I") // { // param.Add("Flag", false); // } // else // { // param.Add("Flag", true); // } // db.SqlParams = param; // //Get IP // if (Status == "I") // { // DataTable dtable = null; // db.StrSQL = "SELECT IP,CaptionPanelIP FROM Innolux_DockDoor WHERE DockDoorID='" + dockdoorID + "'"; // dtable = db.ExecuteDataTable(); // DataRow row = dtable.Rows[0]; // IP = row["IP"].ToString(); // CaptionPanelIP = row["CaptionPanelIP"].ToString(); // } // else // { // DataTable dtable = null; // db.StrSQL = "SELECT IP,CaptionPanelIP FROM Innolux_DockDoor WHERE DockDoorID='" + dockdoorID + "'"; // dtable = db.ExecuteDataTable(); // DataRow row = dtable.Rows[0]; // IP = row["IP"].ToString(); // CaptionPanelIP = row["CaptionPanelIP"].ToString(); // } // if (Status == "I") // { // db.StrSQL = " UPDATE [Innolux_DockDoor] SET ContainerID=@ContainerID, ContainerStatus=@ContainerStatus,UpdateTime=@UpdateTime,Flag=@Flag WHERE DockDoorID=@DockDoorID"; // db.ExecuteSQL(); // var mes = "櫃號:" + truckID + " 已進站"; // ApiDataAccess.ControlMachine(CaptionPanelIP, mes, 0); // } // else // { // db.StrSQL = " UPDATE [Innolux_DockDoor] SET ContainerID='', ContainerStatus='',UpdateTime=@UpdateTime, Flag=@Flag WHERE ContainerID=@ContainerID"; // db.ExecuteSQL(); // } // //Save in MySql // if (Status == "I") // { // if (ASN != null && ASN != "") // { // // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('I','0')"); // ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='I',car_out='0'"); // ApiDataAccess.UpdateControlDB(IP, "UPDATE status SET status='I'"); // } // else if (DN != null && DN != "") // { // // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('O','0')"); // ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='O',car_out='0'"); // ApiDataAccess.UpdateControlDB(IP, "UPDATE status SET status='O'"); // } // else // { // // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('_','0')"); // ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in=' ',car_out='0'"); // ApiDataAccess.UpdateControlDB(IP, "UPDATE status SET status=' '"); // } // } // else // { // if (Total == iNum) // { // var msg = string.Format("櫃號:{0}({1}/{2})已離廠", truckID, iNum, Total); // ApiDataAccess.ControlMachine(CaptionPanelIP, msg, 3); // ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='0',car_out='Y'"); // } // else // { // var msg = string.Format("櫃號:{0}({1}/{2})尚未完成作業", truckID, iNum, Total); // ApiDataAccess.ControlMachine(CaptionPanelIP, msg, 3); // ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='0',car_out='N'"); // // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('0','N')"); // } // } // } // } // catch // { // } //} public static DataTable GetDockDoorListDetails() { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //判斷Status成功或失敗 DataTable dt = null; db.StrSQL = "SELECT ContainerID,Flag FROM Innolux_DockDoor WHERE 1=1"; dt = db.ExecuteDataTable(); return(dt); } }
/// <summary>取得使用者清單資料檔</summary> public static DataTable GetUserList(int?_id, string _account, string _password, string _email, string _name, Pages _page) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("ID", _id); param.Add("Account", _account); param.Add("Password", _password); param.Add("Email", "%" + _email + "%"); param.Add("Name", "%" + _name + "%"); db.SqlParams = param; //條件式 string strWhere = ""; if (_id != null) { strWhere += " AND ID = @ID "; } if (!string.IsNullOrEmpty(_account)) { strWhere += " AND Account = @Account "; } if (!string.IsNullOrEmpty(_password)) { strWhere += " AND Password = @Password "; } if (!string.IsNullOrEmpty(_email)) { strWhere += " AND Email LIKE @Email "; } if (!string.IsNullOrEmpty(_name)) { strWhere += " AND Name LIKE @Name "; } //取回資料 int iTotal; var sql = "SELECT * FROM [User] WHERE 1=1 " + strWhere; var dt = db.ExecuteDataTable(sql, "ID", _page.PageIndex, _page.PageSize, out iTotal); _page.TotalRows = iTotal; return(dt); } }
/// <summary>取得DockDoor資料</summary> public static DataTable GetDockDoorList(string DockDoorID, string IP, string Alarm, string ContainerID, Pages _page) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("DockDoorID", DockDoorID); param.Add("IP", IP); param.Add("Alarm", Alarm); param.Add("ContainerID", ContainerID); db.SqlParams = param; //條件式 string strWHERE = ""; if (!string.IsNullOrEmpty(DockDoorID)) { strWHERE += " AND DockDoorID = @DockDoorID "; } if (!string.IsNullOrEmpty(IP)) { strWHERE += " AND IP = @IP "; } if (!string.IsNullOrEmpty(Alarm)) { strWHERE += " AND Alarm = @Alarm "; } if (!string.IsNullOrEmpty(ContainerID)) { strWHERE += " AND ContainerID = @ContainerID "; } //取回資料 int iTotal; var sql = @"SELECT d.*, f.FilterName, f.FilterRules FROM Innolux_DockDoor d INNER JOIN Innolux_Filter f ON f.FilterCode = d.FilterCode WHERE 1=1" + strWHERE; var dt = db.ExecuteDataTable(sql, "DockDoorID", _page.PageIndex, _page.PageSize, out iTotal); _page.TotalRows = iTotal; return(dt); } }
/// <summary>取得群組底下的使用者清單</summary> public static DataTable GetGroupUser(string GroupID) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("GroupID", GroupID); db.SqlParams = param; //取回資料 db.StrSQL = @"SELECT u.* FROM GroupUser gu INNER JOIN [User] u ON u.Account = gu.Account WHERE gu.GroupID = @GroupID"; var dt = db.ExecuteDataTable(); return(dt); } }
/// <summary>取得使用者所屬的群組清單</summary> public static DataTable GetUserGroup(string Account) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("Account", Account); db.SqlParams = param; //取回資料 db.StrSQL = @"SELECT g.* FROM GroupUser gu INNER JOIN [Group] g ON g.GroupID = gu.GroupID WHERE Account = @Account"; var dt = db.ExecuteDataTable(); return(dt); } }
/// <summary>取得白名單規則</summary> public static DataTable GetFilterList(string FilterCode) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("FilterCode", FilterCode); db.SqlParams = param; //條件式 string strWHERE = ""; if (!string.IsNullOrEmpty(FilterCode)) { strWHERE += " AND FilterCode = @FilterCode "; } //取回資料 db.StrSQL = "SELECT * FROM Innolux_Filter WHERE 1=1" + strWHERE; return(db.ExecuteDataTable()); } }
/// <summary>取得選單檔</summary> public static DataTable GetMenuList(int?MenuNoLen, string MenuNo, string MenuName, bool?Enabled) { //開啟資料庫存取物件 using (var db = new DataBase.DataBase(Definition.Conn)) { //資料庫參數 var param = new DataBase.SqlParams(); param.Add("MenuNoLen", MenuNoLen); param.Add("MenuNo", MenuNo); param.Add("MenuName", MenuName); param.Add("Enabled", Enabled); db.SqlParams = param; //條件式 string strWhere = ""; if (MenuNoLen != null) { strWhere += " AND LEN(MenuNo) = @MenuNoLen "; } if (!string.IsNullOrEmpty(MenuNo)) { strWhere += " AND MenuNo = @MenuNo "; } if (!string.IsNullOrEmpty(MenuName)) { strWhere += " AND MenuName = @MenuName "; } if (Enabled != null) { strWhere += " AND Enabled = @Enabled "; } //取回資料 db.StrSQL = "SELECT * FROM Menu WHERE 1=1" + strWhere + " ORDER BY OrderID"; return(db.ExecuteDataTable()); } }
public static void SaveDockDoorInfo(string truckID, string Status, string dockdoorID) { string O_Status = null; DataTable dt = null; DataTable dt1 = null; string IP = null; string strNum, strTotal; string cid = string.Empty; string cstatus = string.Empty; Result r = new Result(); string ASN = null; string DN = null; string CaptionPanelIP = null; //Save in ORACLE using (var db = new DataBase.OracleDataBase(Definition.WMSConn)) { db.StrSQL = "SELECT DN_NO FROM WMS_RFID_CONTAINER_CHECK_V WHERE CONTAINER_NO='" + truckID + "'"; dt1 = db.ExecuteDataTable(); if (dt1.DefaultView.Count > 0) { DataRow DN_dr = dt1.Rows[0]; DN = DN_dr["DN_NO"].ToString(); } } using (var db = new DataBase.DataBase(Definition.Conn, true)) { try { db.StrSQL = "SELECT ASN_NO FROM WMS_RFID_TRUCK WHERE TRUCK_NO='" + truckID + "'"; dt = db.ExecuteDataTable(); DataRow dr_ASN = dt.Rows[0]; if (dt.DefaultView.Count > 0) { ASN = dr_ASN["ASN_NO"].ToString(); } if (Status == "I") { if (ASN != null && ASN != "") { db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS='I',DOCKED='" + dockdoorID + "' WHERE TRUCK_NO='" + truckID + "'"; } else { if (DN != null && DN != "") { db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS='O',DOCKED='" + dockdoorID + "' WHERE TRUCK_NO='" + truckID + "'"; } else { db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS=' ',DOCKED='" + dockdoorID + "' WHERE TRUCK_NO='" + truckID + "'"; } } db.ExecuteSQL(); // db.Commit(); } else { db.StrSQL = "UPDATE WMS_RFID_TRUCK SET STATUS='" + DBNull.Value + "',DOCKED='" + DBNull.Value + "' WHERE TRUCK_NO='" + truckID + "'"; db.ExecuteSQL(); // db.Commit(); } db.StrSQL = "SELECT STATUS FROM WMS_RFID_TRUCK WHERE TRUCK_NO='" + truckID + "'"; DataTable dt2 = db.ExecuteDataTable(); DataRow dtstatus = dt2.Rows[0]; if (dt2.DefaultView.Count > 0) { O_Status = dtstatus["STATUS"].ToString(); } var param = new DataBase.SqlParams(); param.Add("ContainerID", truckID); param.Add("ContainerStatus", O_Status); param.Add("DockDoorID", dockdoorID); DateTime dtime = DateTime.Now; param.Add("UpdateTime", dtime); if (Status == "I") { param.Add("Flag", false); } else { param.Add("Flag", true); } db.SqlParams = param; if (Status == "I") { db.StrSQL = " UPDATE [Innolux_DockDoor] SET ContainerID=@ContainerID, ContainerStatus=@ContainerStatus,UpdateTime=@UpdateTime,Flag=@Flag WHERE DockDoorID=@DockDoorID"; db.ExecuteSQL(); } DataTable dtIP = null; db.StrSQL = "SELECT IP,CaptionPanelIP,ContainerID,ContainerStatus FROM Innolux_DockDoor WHERE DockDoorID='" + dockdoorID + "'"; dtIP = db.ExecuteDataTable(); DataRow row = dtIP.Rows[0]; if (dtIP.DefaultView.Count > 0) { IP = row["IP"].ToString(); CaptionPanelIP = row["CaptionPanelIP"].ToString(); cid = row["ContainerID"].ToString(); cstatus = row["ContainerStatus"].ToString(); } if (Status == "O") { db.StrSQL = " UPDATE [Innolux_DockDoor] SET ContainerID='', ContainerStatus=@ContainerStatus,UpdateTime=@UpdateTime, Flag=@Flag WHERE ContainerID=@ContainerID"; db.ExecuteSQL(); } //Get IP //Save in MySql if (Status == "I") { if (ASN != null && ASN != "") { // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('I','0')"); ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='I',car_out='0'"); ApiDataAccess.UpdateControlDB(IP, "UPDATE status SET status='I'"); } else if (DN != null && DN != "") { // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('O','0')"); ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='O',car_out='0'"); ApiDataAccess.UpdateControlDB(IP, "UPDATE status SET status='O'"); } else { // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('_','0')"); ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in=' ',car_out='0'"); ApiDataAccess.UpdateControlDB(IP, "UPDATE status SET status=' '"); } var mes = "櫃號:" + truckID + " 已進站"; ApiDataAccess.ControlMachine(CaptionPanelIP, mes, 0); } else { if (cstatus == "I" || cstatus == "O") { ApiDataAccess.GetCountProcess(dockdoorID, cid, cstatus, out strNum, out strTotal); if (strNum == strTotal) { var msg = string.Format("櫃號:{0}({1}/{2})已離廠", truckID, strNum, strTotal); ApiDataAccess.ControlMachine(CaptionPanelIP, msg, 3); ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='0',car_out='Y'"); } else { var msg = string.Format("櫃號:{0}({1}/{2})尚未完成作業", truckID, strNum, strTotal); ApiDataAccess.ControlMachine(CaptionPanelIP, msg, 3); ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='0',car_out='N'"); // ApiDataAccess.UpdateControlDB(IP, "INSERT checkin(car_in,car_out)VALUES('0','N')"); } } else if (cstatus == " ") { var msg = string.Format("櫃號:{0})已離廠", truckID); ApiDataAccess.ControlMachine(CaptionPanelIP, msg, 3); ApiDataAccess.UpdateControlDB(IP, "UPDATE checkin SET car_in='0',car_out='Y'"); } } db.Commit(); } catch (Exception ex) { var mes = ex.Message; db.Rollback(); throw ex; } } }