public List <C_INTERFACE> GetInterfaceStatus(string BU, string IP, string Program_Name, string Item_Name, string Emp_No, OleExec DB, DB_TYPE_ENUM DBType)
{
string Message = "";
List <C_INTERFACE> ListInterface = new List <C_INTERFACE>();
Dictionary <string, string> Dic_Interface = new Dictionary <string, string>();
string StrSql = $@"SELECT * from C_INTERFACE where program_name='{Program_Name}' ";
DataTable dt = DB.ExecSelect(StrSql).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
C_INTERFACE Row = GetRow(dr);
ListInterface.Add(Row);
}
return(ListInterface);
}
else
{
if (dt.Rows.Count > 1)
{
Message = "配置信息有多筆!";
}
else if (dt.Rows.Count == 0)
{
Message = "信息未配置";
}
return(null);
}
//InsertLog(BU, Program_Name, Item_Name, Message, StrSql, Emp_No, DB, DBType);
}
/// <summary>
/// 檢查前台服務器IP與後台服務器IP是否一致
/// </summary>
/// <param name="BU"></param>
/// <param name="IP"></param>
/// <param name="Program_Name"></param>
/// <param name="Item_Name"></param>
/// <param name="Emp_No"></param>
/// <param name="DB"></param>
/// <param name="DBType"></param>
/// <returns></returns>
public C_INTERFACE CHECK_IP(string BU, string IP, string Program_Name, string Item_Name, string Emp_No, OleExec DB, DB_TYPE_ENUM DBType)
{
string Message = "";
List <C_INTERFACE> ListInterface = new List <C_INTERFACE>();
try
{
string StrSql = $@"SELECT * from C_Program_Server where program_name='{Program_Name}' and server_ip='{IP}' ";
DataTable dt = DB.ExecSelect(StrSql).Tables[0];
if (dt.Rows.Count == 1)
{
C_INTERFACE Row = GetRow(dt.Rows[0]);
return(Row);
}
else
{
if (dt.Rows.Count > 1)
{
Message = Item_Name + "配置信息有多筆!";
}
else if (dt.Rows.Count == 0)
{
Message = Item_Name + "信息未配置";
}
return(null);
}
//InsertLog(BU, Program_Name, Item_Name, Message, StrSql, Emp_No, DB, DBType);
}
catch (Exception ex)
{
throw (ex);
}
}
public C_INTERFACE GetDataObject()
{
C_INTERFACE DataObject = new C_INTERFACE();
DataObject.ID = this.ID;
DataObject.PROGRAM_NAME = this.PROGRAM_NAME;
DataObject.CLASS_NAME = this.CLASS_NAME;
DataObject.FUNCTION_NAME = this.FUNCTION_NAME;
DataObject.ITEM_NAME = this.ITEM_NAME;
DataObject.SEQ_NO = this.SEQ_NO;
DataObject.ITEM_STATUS = this.ITEM_STATUS;
DataObject.LAST_RUN_DATE = this.LAST_RUN_DATE;
DataObject.NEXT_RUN_DATE = this.NEXT_RUN_DATE;
DataObject.RUN_TYPE = this.RUN_TYPE;
DataObject.RUN_TIME = this.RUN_TIME;
DataObject.DESCRIPTION = this.DESCRIPTION;
DataObject.EDIT_EMP = this.EDIT_EMP;
DataObject.EDIT_TIME = this.EDIT_TIME;
return(DataObject);
}