/// <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;
}
}
}