public void GenDDLAlarmMachineByLine(CGeneral.TypeSelect Type, DropDownList obj, string LineName) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT DISTINCT MachineName"); sbd.AppendLine("FROM AlarmLineSetting"); sbd.AppendLine("WHERE LineName='" + LineName + "'"); dTable = oConnMecha.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { obj.Items.Add(new ListItem(row["MachineName"].ToString(), row["MachineName"].ToString())); } } }
public void GenDDLSubPointByPartTypeAndMainPoint(CGeneral.TypeSelect Type, DropDownList obj, string PartType, string MainPoint) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT DISTINCT SubPoint"); sbd.AppendLine("FROM QC_StandardMaster"); sbd.AppendLine("WHERE PartType = '" + PartType + "' and MainPoint = '" + MainPoint + "'"); dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { obj.Items.Add(new ListItem(row["SubPoint"].ToString().Replace('_', ' '), row["SubPoint"].ToString())); } } }
public void GenDDLFactory(CGeneral.TypeSelect Type, DropDownList obj) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT FactoryID,FactoryName"); sbd.AppendLine("FROM FactoryData"); dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "0")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { obj.Items.Add(new ListItem(row["FactoryName"].ToString(), row["FactoryID"].ToString())); } } }
public void GenDDLLineDataByFactoryID(CGeneral.TypeSelect Type, DropDownList obj, int FactoryID) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT ld_id,ld_linename FROM LineData ld"); sbd.AppendLine("LEFT JOIN FactoryData fd ON ld.FactoryID=fd.FactoryID"); sbd.AppendLine("WHERE ld.FactoryID=" + FactoryID); dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "0")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { obj.Items.Add(new ListItem(row["ld_linename"].ToString() , row["ld_id"].ToString())); } } }
public void GenDDLIndexColumn(CGeneral.TypeSelect Type, DropDownList obj) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT index_id,index_datetime,index_partnumber,index_modelcode,index_result,index_value"); sbd.AppendLine("FROM IndexColumn"); dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "0")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { obj.Items.Add(new ListItem("Date:" + row["index_datetime"].ToString() + ", PartNo:" + row["index_partnumber"].ToString() + ", Model:" + row["index_modelcode"].ToString() + ", Result:" + row["index_result"].ToString() + ", Value:" + row["index_value"].ToString() , row["index_id"].ToString())); } } }
public void GenDDLHeader(CGeneral.TypeSelect Type, DropDownList obj) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT header_id,header_detail"); sbd.AppendLine("FROM headerMaster"); dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "0")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { obj.Items.Add(new ListItem(row["header_detail"].ToString() , row["header_id"].ToString())); } } }
public void GenDDLModelByMachine(CGeneral.TypeSelect Type, DropDownList obj, string mc_code) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT DISTINCT m.model_code,m.model_name"); sbd.AppendLine("FROM data d"); sbd.AppendLine("LEFT JOIN model m ON d.model_id = m.model_id"); sbd.AppendLine("WHERE mc_code = '" + mc_code + "' "); dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "0")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { obj.Items.Add(new ListItem(row["model_code"].ToString() + ", " + row["model_name"].ToString() , row["model_code"].ToString())); } } }
public void GenDDLMachineByLine(CGeneral.TypeSelect Type, DropDownList obj, string ld_id) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); sbd.AppendLine("SELECT mc_code,mc_name FROM machine WHERE ld_id = '" + ld_id + "' and mc_active='1' order by mc_order"); dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "-ALL-")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { bool FianlLineCheck = false; foreach (DataRow row in dTable.Rows) { //if (row["mc_code"].ToString() != "" && row["mc_code"].ToString().Length >= 16) //{ // if (row["mc_code"].ToString().Substring(0, 16) == "FN_RunningTestNo" && !FianlLineCheck) // { // obj.Items.Add(new ListItem("Running Test All M/C" // , "FinalRunningTest")); // FianlLineCheck = true; // } //} obj.Items.Add(new ListItem(row["mc_name"].ToString() , row["mc_code"].ToString())); } } }
public void GenDDLLineManual(CGeneral.TypeSelect Type, DropDownList obj) { obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "0")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } obj.Items.Add(new ListItem("Main Assembly Line", "1")); obj.Items.Add(new ListItem("Rear Head Finish Line", "2")); obj.Items.Add(new ListItem("Cylineder Finish Line", "3")); obj.Items.Add(new ListItem("Crank Shaft Finish Line", "4")); obj.Items.Add(new ListItem("Front Head Finish Line", "5")); obj.Items.Add(new ListItem("Piston Line", "6")); obj.Items.Add(new ListItem("Casing Pipe Line", "7")); //obj.Items.Add(new ListItem("Rotor Line", "8")); //obj.Items.Add(new ListItem("Stator Line", "9")); obj.Items.Add(new ListItem("Final Line", "10")); }
public void GenDDLLineDataByManPowerMachineID(CGeneral.TypeSelect Type, DropDownList obj, int LineID) { //DataTable dTable = new DataTable(); //StringBuilder sbd = new StringBuilder(); //if (LineID == 37) //{ // sbd.AppendLine("SELECT ld_id,ld_linename FROM LineData ld"); // sbd.AppendLine("LEFT JOIN FactoryData fd ON ld.FactoryID=fd.FactoryID"); // sbd.AppendLine("WHERE ld.ld_id =" + LineID); //} // dTable = oConn.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "-ALL-")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } //if (dTable.Rows.Count > 0) //{ // foreach (DataRow row in dTable.Rows) // { // obj.Items.Add(new ListItem(row["ld_linename"].ToString() // , row["ld_id"].ToString())); // } //} if (LineID == 37) { obj.Items.Add(new ListItem("ODM Outdoor Ft1", "37")); } else if (LineID == 8) { obj.Items.Add(new ListItem("Motor", "8")); } else if (LineID == 4) { obj.Items.Add(new ListItem("Main Assembly Line 6", "4")); } else if (LineID == 10) { obj.Items.Add(new ListItem("Final Line 6", "10")); } else if (LineID == 11) { obj.Items.Add(new ListItem("Mecha Line 6", "11")); } else if (LineID == 1) { obj.Items.Add(new ListItem("Rear Head Line 6", "1")); } else if (LineID == 6) { obj.Items.Add(new ListItem("Cylinder Line 6", "6")); } else if (LineID == 7) { obj.Items.Add(new ListItem("Crank Shaft Line 6", "7")); } else if (LineID == 16) { obj.Items.Add(new ListItem("Front Head Line 6", "16")); } else if (LineID == 5) { obj.Items.Add(new ListItem("Piston Line 6", "5")); } }
public void GenDDLMachineManual(CGeneral.TypeSelect Type, DropDownList obj, string LineNo) { obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "0")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } switch (LineNo) { case "1": // Main Assy obj.Items.Add(new ListItem("Rotor Yakibame", "1")); obj.Items.Add(new ListItem("Magnetize", "2")); obj.Items.Add(new ListItem("Pipe Yakibame", "3")); obj.Items.Add(new ListItem("Tack Welding", "4")); obj.Items.Add(new ListItem("Magnet Center", "5")); obj.Items.Add(new ListItem("Air Gap", "6")); obj.Items.Add(new ListItem("Connecting Check", "7")); obj.Items.Add(new ListItem("Top Bottom Welding", "8")); break; case "2": // RH obj.Items.Add(new ListItem("Laser Marking", "1")); break; case "3": // CY obj.Items.Add(new ListItem("Laser Marking", "1")); break; case "4": // CS obj.Items.Add(new ListItem("Laser Marking", "1")); break; case "5": // FH obj.Items.Add(new ListItem("Laser Marking", "1")); break; case "6": // PT obj.Items.Add(new ListItem("Laser Marking", "1")); break; case "7": // Pipe obj.Items.Add(new ListItem("Laser Marking", "1")); obj.Items.Add(new ListItem("Pipe ID Check", "2")); break; case "8": // Rotor //obj.Items.Add(new ListItem("Laser Marking", "1")); break; case "9": // Stator //obj.Items.Add(new ListItem("Laser Marking", "1")); break; case "10": // Final obj.Items.Add(new ListItem("Label Printing", "1")); obj.Items.Add(new ListItem("Running Test", "2")); obj.Items.Add(new ListItem("Oil Filling", "3")); obj.Items.Add(new ListItem("Final Weight Check", "4")); break; case "11": // Mecha obj.Items.Add(new ListItem("Front Head", "1")); obj.Items.Add(new ListItem("Rear Head", "2")); obj.Items.Add(new ListItem("Crank Shaft", "3")); obj.Items.Add(new ListItem("Cylinder", "4")); obj.Items.Add(new ListItem("Piston", "5")); obj.Items.Add(new ListItem("Matching", "6")); obj.Items.Add(new ListItem("Cylinder Centering", "7")); obj.Items.Add(new ListItem("Rear Centering", "8")); obj.Items.Add(new ListItem("Torque Check", "9")); break; } }
public void GenDDLMachineManpowerByLine(CGeneral.TypeSelect Type, DropDownList obj, string ld_id) { DataTable dTable = new DataTable(); StringBuilder sbd = new StringBuilder(); if (ld_id == "37") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'ODM_OD1'"); } else if (ld_id == "8") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'Motor6'"); } else if (ld_id == "4") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'Main6'"); } else if (ld_id == "10") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'Final6'"); } else if (ld_id == "11") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'Mecha'"); } else if (ld_id == "1") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'MC_RH6'"); } else if (ld_id == "6") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'MC_CY6'"); } else if (ld_id == "16") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'MC_FH6'"); } else if (ld_id == "7") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'MC_CS6'"); } else if (ld_id == "5") { sbd.AppendLine("SELECT distinct LocationName FROM [ManPowerLog] WHERE Line = 'MC_PT6'"); } dTable = oConIoTFac3.Query(sbd.ToString()); obj.Items.Clear(); if (Type == CGeneral.TypeSelect.All) { obj.Items.Add(new ListItem("-ALL-", "-ALL-")); } else if (Type == CGeneral.TypeSelect.Please) { obj.Items.Add(new ListItem("-Please Select-", "0")); } if (dTable.Rows.Count > 0) { bool FianlLineCheck = false; foreach (DataRow row in dTable.Rows) { //if (row["mc_code"].ToString() != "" && row["mc_code"].ToString().Length >= 16) //{ // if (row["mc_code"].ToString().Substring(0, 16) == "FN_RunningTestNo" && !FianlLineCheck) // { // obj.Items.Add(new ListItem("Running Test All M/C" // , "FinalRunningTest")); // FianlLineCheck = true; // } //} obj.Items.Add(new ListItem(row["LocationName"].ToString() , row["LocationName"].ToString())); } } }