// ASUS様指示
public List <CombInstruction> GetDropDownListInstruction()
{
DSNLibrary dsnLib = new DSNLibrary();
StringBuilder stbSql = new StringBuilder();
stbSql.Append("SELECT ");
stbSql.Append(" M_INSTRUCTION.INSTRUCTION_ID, ");
stbSql.Append(" M_INSTRUCTION.INSTRUCTION ");
stbSql.Append("FROM ");
stbSql.Append(" M_INSTRUCTION ");
stbSql.Append("ORDER BY ");
stbSql.Append(" M_INSTRUCTION.INSTRUCTION_ID ");
SqlDataReader sqlRdr = dsnLib.ExecSQLRead(stbSql.ToString());
List <CombInstruction> DropDownListInstruction = new List <CombInstruction>();
while (sqlRdr.Read())
{
DropDownListInstruction.Add(new CombInstruction
{
InstructionID = sqlRdr["INSTRUCTION_ID"].ToString(),
Instruction = sqlRdr["INSTRUCTION"].ToString()
});
}
sqlRdr.Close();
dsnLib.DB_Close();
return(DropDownListInstruction);
}
// シリアルステータス
public List <CombSerialStatus> GetDropDownListSerialStatus()
{
DSNLibrary dsnLib = new DSNLibrary();
StringBuilder stbSql = new StringBuilder();
stbSql.Append("SELECT ");
stbSql.Append(" M_SERIAL_STATUS.SERIAL_STATUS_ID, ");
stbSql.Append(" M_SERIAL_STATUS.SERIAL_STATUS_NAME ");
stbSql.Append("FROM ");
stbSql.Append(" M_SERIAL_STATUS ");
//----------- 2020/07/29 UPDATE START E.KOSHIKAWA -------------
stbSql.Append("WHERE ");
stbSql.Append(" M_SERIAL_STATUS.DEL_FLG = '0' ");
//----------- 2020/07/29 UPDATE END E.KOSHIKAWA -------------
stbSql.Append("ORDER BY ");
stbSql.Append(" M_SERIAL_STATUS.SERIAL_STATUS_ID ");
SqlDataReader sqlRdr = dsnLib.ExecSQLRead(stbSql.ToString());
List <CombSerialStatus> DropDownListSerialStatus = new List <CombSerialStatus>();
while (sqlRdr.Read())
{
DropDownListSerialStatus.Add(new CombSerialStatus
{
SerialStatusID = sqlRdr["SERIAL_STATUS_ID"].ToString(),
SerialStatusName = sqlRdr["SERIAL_STATUS_NAME"].ToString()
});
}
sqlRdr.Close();
dsnLib.DB_Close();
return(DropDownListSerialStatus);
}
// 権限
public List <CombAuthorityName> GetDropDownListAuthorityName()
{
DSNLibrary dsnLib = new DSNLibrary();
StringBuilder stbSql = new StringBuilder();
stbSql.Append("SELECT ");
stbSql.Append(" ID, ");
stbSql.Append(" AUTHORITY_NAME ");
stbSql.Append("FROM ");
stbSql.Append(" M_AUTHORITY ");
stbSql.Append("WHERE ");
stbSql.Append(" DEL_FLG = '0' ");
stbSql.Append("ORDER BY ");
stbSql.Append(" ID ");
SqlDataReader sqlRdr = dsnLib.ExecSQLRead(stbSql.ToString());
List <CombAuthorityName> DropDownAuthorityName = new List <CombAuthorityName>();
while (sqlRdr.Read())
{
DropDownAuthorityName.Add(new CombAuthorityName
{
ID = sqlRdr["ID"].ToString(),
AuthorityName = sqlRdr["AUTHORITY_NAME"].ToString()
});
}
dsnLib.DB_Close();
return(DropDownAuthorityName);
}
// LINE
public List <CombLine> GetDropDownListLine()
{
DSNLibrary dsnLib = new DSNLibrary();
StringBuilder stbSql = new StringBuilder();
stbSql.Append("SELECT ");
stbSql.Append(" M_LINE.LINE_ID, ");
stbSql.Append(" M_LINE.LINE_NAME ");
stbSql.Append("FROM ");
stbSql.Append(" M_LINE ");
stbSql.Append("ORDER BY ");
stbSql.Append(" M_LINE.LINE_ID ");
SqlDataReader sqlRdr = dsnLib.ExecSQLRead(stbSql.ToString());
List <CombLine> DropDownListLine = new List <CombLine>();
while (sqlRdr.Read())
{
DropDownListLine.Add(new CombLine
{
LineID = sqlRdr["LINE_ID"].ToString(),
LineName = sqlRdr["LINE_NAME"].ToString()
});
}
sqlRdr.Close();
dsnLib.DB_Close();
return(DropDownListLine);
}
public UserInfo(string strID)
{
StringBuilder stbSql = new StringBuilder();
stbSql.Append("SELECT * ");
stbSql.Append("FROM dbo.M_USER ");
stbSql.Append("WHERE ID = '" + strID + "' ");
DSNLibrary dsnLib = new DSNLibrary();
SqlDataReader sqlRdr = dsnLib.ExecSQLRead(stbSql.ToString());
while (sqlRdr.Read())
{
ID = sqlRdr["ID"].ToString();
UserName = sqlRdr["USER_NAME"].ToString();
Password = sqlRdr["PASS"].ToString();
AuthorityKbn = sqlRdr["AUTHORITY_KBN"].ToString();
}
dsnLib.DB_Close();
}