public List <P_Con_User> selectList(string id, string name, string pwd, string userNumber)
{
string query_string = "SELECT * from `p_con_user` where 1=1";
if (id != "")
{
query_string = query_string + " and id='" + id + "'";
}
if (name != "")
{
query_string = query_string + " and USER_CODE='" + name + "'";
}
if (pwd != "")
{
query_string = query_string + " and USER_PASSWORD='******'";
}
if (userNumber != "")
{
query_string = query_string + " and USER_NUMBER='" + userNumber + "'";
}
DataTable dt = MESMysqlTool.queryData(query_string, new MySqlParameter[] {
new MySqlParameter()
});
List <P_Con_User> ls = MESMysqlTool.toList <P_Con_User>(dt);
return(ls.Count > 0 ? ls : null);
}
public List <TechnologyDetail> selectList(string toolId)
{
string query_string = "SELECT ID id ,TOOL_ID ToolID, PRECHECK_PRE_COUNT PreNum,PRECHECK_STANDARD Standard,PRECHECK_UPPER PreUpper,PRECHECK_LOWER PreLower,PRECHECK_BACK_COUNT PostNum,PRECHECK_BACK_UPPER PostUpper,PRECHECK_BACK_LOWER PostLower from `base_tool_precheck` where TOOL_ID=@toolId and DEL_FLAG=0";
DataTable dt = MESMysqlTool.queryData(query_string, new MySqlParameter[] {
new MySqlParameter("@toolId", toolId)
});
List <TechnologyDetail> ls = MESMysqlTool.toList <TechnologyDetail>(dt);
return(ls.Count > 0 ? ls : null);
}
public List <Product> selectList(string numIndex)
{
string query_string = "select ID id,TOOL_CODE numIndex,TOOL_NAME name,CHECK_MODE kind from `base_tool` where DEL_FLAG=0";
if (numIndex != "")
{
query_string = query_string + " and TOOL_CODE='" + numIndex + "'";
}
DataTable dt = MESMysqlTool.queryData(query_string, new MySqlParameter[] {
new MySqlParameter()
});
List <Product> ls = MESMysqlTool.toList <Product>(dt);
return(ls.Count > 0 ? ls : null);
}
public string selectOrganizationName(string org_id)
{
string query_string = "SELECT ORG_NAME from `p_con_organization` where ORG_ID='" + org_id + "'";
DataTable dt = MESMysqlTool.queryData(query_string, new MySqlParameter[] {
new MySqlParameter()
});
if (dt.Rows.Count > 0)
{
return(dt.Rows[0]["ORG_NAME"].ToString());
}
else
{
return("");
}
}
public List <TechnologyDetail> selectPostList(string toolId)
{
string query_string = "SELECT ID Id,PRECHECK_PRE_COUNT PreNum,PRECHECK_STANDARD Standard,PRECHECK_UPPER PreUpper,PRECHECK_LOWER PreLower,PRECHECK_BACK_COUNT PostNum,PRECHECK_BACK_UPPER PostUpper,PRECHECK_BACK_LOWER PostLower from `base_tool_precheck` where TOOL_ID=@toolId and DEL_FLAG=0";
DataTable dt = MESMysqlTool.queryData(query_string, new MySqlParameter[] {
new MySqlParameter("@toolId", toolId)
});
List <TechnologyDetail> ls = new List <TechnologyDetail>();
for (int i = 0; i < dt.Rows.Count; i++)
{
TechnologyDetail temp = new TechnologyDetail();
temp.Id = dt.Rows[i]["id"].ToString();
temp.Num = int.Parse(dt.Rows[i]["PostNum"].ToString());
temp.Standard = float.Parse(dt.Rows[i]["Standard"].ToString());
temp.Upper = float.Parse(dt.Rows[i]["PostUpper"].ToString());
temp.Lower = float.Parse(dt.Rows[i]["PostLower"].ToString());
ls.Add(temp);
}
return(ls.Count > 0 ? ls : null);
}
