public T_C_REPAIR_DAY(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_C_PARAMETER(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_C_PARAMETER);
TableName = "C_PARAMETER".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public List <C_PARAMETER> Get_Interface_Parameter_1(string Function_Name, OleExec DB, DB_TYPE_ENUM DBType)
{
string Message = "";
List <C_PARAMETER> ListInterface = new List <C_PARAMETER>();
Dictionary <string, string> Dic_Interface = new Dictionary <string, string>();
string StrSql = $@"select parameter_name,parameter_value from C_PARAMETER where function_name='{Function_Name}' ";;
DataTable dt = DB.ExecSelect(StrSql).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
C_PARAMETER Row = GetRow(dr);
ListInterface.Add(Row);
}
return(ListInterface);
}
else
{
if (dt.Rows.Count > 1)
{
Message = "配置信息有多筆!";
}
else if (dt.Rows.Count == 0)
{
Message = "信息未配置";
}
return(null);
}
}
public T_R_WO_REGION(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_R_STOCK(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_R_STOCK);
TableName = "R_STOCK".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_R_WO_ITEM_TJ(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_R_WO_ITEM_TJ);
TableName = "R_WO_ITEM_TJ".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_C_SERIES(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_C_SAP_STATION_MAP(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_C_SAP_STATION_MAP(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_C_SAP_STATION_MAP);
TableName = "C_SAP_STATION_MAP".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_r_repair_action(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_r_repair_action(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_r_repair_action);
TableName = "r_repair_action".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_C_WT_CONFIG(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_H_WO_TEXT(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_C_REPAIR_DAY(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_C_REPAIR_DAY);
TableName = "C_REPAIR_DAY".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public bool CheckWoItemByWo(string Workorderno, string PartNo, bool Download_Auto, string ColumnName, OleExec DB, DB_TYPE_ENUM DBType)
{
bool CheckFlag = false;
string StrSql = "";
string StrReturnMsg = "";
int n = 0;
if (Download_Auto)
{
StrSql = $@"select * from R_WO_ITEM where AUFNR='{Workorderno}' and MATNR='{ PartNo }' ";
DataTable dt = DB.ExecSelect(StrSql).Tables[0];
if (dt.Rows.Count > 0)
{
CheckFlag = true;
}
}
else
{
StrSql = $@"select * from R_WO_ITEM where AUFNR='{Workorderno}' and MATNR='{ PartNo }'";
DataTable dt = DB.ExecSelect(StrSql).Tables[0];
if (dt.Rows.Count > 0)
{
DB.ExecSQL($@" delete from H_WO_ITEM where AUFNR = '{Workorderno}' and MATNR='{ PartNo }'");
StrSql = $@"insert into H_WO_ITEM(ID,{ ColumnName }) ";
StrSql = StrSql + $@" select* from R_WO_ITEM where AUFNR = '{Workorderno}' and MATNR='{ PartNo }'";
StrReturnMsg = DB.ExecSQL(StrSql);
int.TryParse(StrReturnMsg, out n);
if (n > 0)
{
StrSql = $@" delete from R_WO_ITEM where AUFNR = '{Workorderno}' and MATNR='{ PartNo }'";
StrReturnMsg = DB.ExecSQL(StrSql);
int.TryParse(StrReturnMsg, out n);
CheckFlag = false;
}
}
}
return(CheckFlag);
}
public T_SD_TO_HEAD(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_R_WO_ITEM_TJ(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_SD_TO_HEAD(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_SD_TO_HEAD);
TableName = "SD_TO_HEAD".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_C_PACKING_TYPE(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_R_MRB_GT(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
RowType = typeof(Row_R_MRB_GT);
TableName = "R_MRB_GT".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_C_SERIES(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_C_SERIES);
TableName = "C_SERIES".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_R_Station_Action_Para(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_R_STOCK(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_R_Station_Action_Para(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_R_Station_Action_Para);
TableName = "R_Station_Action_Para".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public T_C_PARAMETER(string _TableName, OleExec DB, DB_TYPE_ENUM DBType) : base(_TableName, DB, DBType)
{
}
public T_H_MRB_GT(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_H_MRB_GT);
TableName = "H_MRB_GT".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
public Dictionary <String, String> Get_Interface_Parameter(string Function_Name, OleExec DB, DB_TYPE_ENUM DBType)
{
string strSql = $@"select parameter_name,parameter_value from C_PARAMETER where function_name='{Function_Name}' ";
DataTable dt = DB.ExecSelect(strSql).Tables[0];
Dictionary <string, string> SAP_Para = new Dictionary <string, string>();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SAP_Para.Add(dt.Rows[i]["parameter_name"].ToString(), dt.Rows[i]["parameter_value"].ToString());
}
return(SAP_Para);
}
else
{
return(null);
}
}
public string EditWoItem(string EditSql, OleExec DB, DB_TYPE_ENUM DBType)
{
string ReturnMsg = DB.ExecSQL(EditSql);
return(ReturnMsg);
}
public Dictionary <String, String> Get_Interface_Parameter_2(string Function_Name, OleExec DB, DB_TYPE_ENUM DBType)
{
string strSql = $@"select parameter_name,parameter_value from C_PARAMETER where function_name='{Function_Name}' ";
DataTable dt = DB.ExecSelect(strSql).Tables[0];
Dictionary <string, string> SAP_Para = new Dictionary <string, string>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SAP_Para.Add(dr["parameter_name"].ToString(), dr["parameter_value"].ToString());
}
return(SAP_Para);
}
else
{
return(null);
}
//InsertLog(BU, Program_Name, Item_Name, Message, StrSql, Emp_No, DB, DBType);
}
public T_R_REPAIR_TRANSFER(OleExec DB, DB_TYPE_ENUM DBType)
{
RowType = typeof(Row_R_REPAIR_TRANSFER);
TableName = "R_REPAIR_TRANSFER".ToUpper();
DataInfo = GetDataObjectInfo(TableName, DB, DBType);
}
