public MDMachine GetMachineBymc_code(string mc_code) { MDMachine oMDMachine = new MDMachine(); DataTable dTable = new DataTable(); SqlCommand sql = new SqlCommand(); sql.CommandText = "SELECT mc_id,mc_code,mc_name,mc_process,mc.ld_id,ld_linename,FactoryName,mc_updateby,mc_updatedate FROM machine mc"; sql.CommandText += " LEFT JOIN LineData ld ON mc.ld_id=ld.ld_id"; sql.CommandText += " LEFT JOIN FactoryData fac ON ld.FactoryID=fac.FactoryID"; sql.CommandText += " WHERE mc_code=@mc_code"; sql.Parameters.Add(new SqlParameter("@mc_code", mc_code)); dTable = oConn.Query(sql); if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { MDMachine.CMDMachine oMD = new MDMachine.CMDMachine(); oMD.mc_id = row["mc_id"] != DBNull.Value ? Convert.ToInt32(row["mc_id"]) : 0; oMD.mc_code = row["mc_code"].ToString(); oMD.mc_name = row["mc_name"].ToString(); oMD.mc_process = row["mc_process"].ToString(); oMD.ld_id = row["ld_id"] != DBNull.Value ? Convert.ToInt32(row["ld_id"]) : 0; oMD.ld_linename = row["ld_linename"].ToString(); oMD.FactoryName = row["FactoryName"].ToString(); oMD.mc_updateby = row["mc_updateby"].ToString(); oMD.mc_updatedate = row["mc_updatedate"].ToString(); oMDMachine.ListOfmachine.Add(oMD); } } return(oMDMachine); }
private void InitialControl() { oGenControl.GenDDLModel(CGeneral.TypeSelect.Please, ddlModel); MDFactory oMDFactory = new MDFactory(); MDLineData oMDLineData = new MDLineData(); MDMachine oMDMachine = new MDMachine(); oMDFactory = oFactory.GetFactoryByFactoryID(ViewState["FactoryID"].ToString()); oMDLineData = oLineData.GetLineDataByLineID(Convert.ToInt32(ViewState["ld_id"])); oMDMachine = oMachine.GetMachineBymc_code(ViewState["mc_code"].ToString()); if (oMDFactory.ListOfFactory.Count > 0) { lbFactory.Text = oMDFactory.ListOfFactory[0].FactoryName; } if (oMDLineData.ListOfLine.Count > 0) { lbPDLine.Text = oMDLineData.ListOfLine[0].ld_linename; } if (oMDMachine.ListOfmachine.Count > 0) { lbMachine.Text = oMDMachine.ListOfmachine[0].mc_code + " " + oMDMachine.ListOfmachine[0].mc_name; } }
public string GenBlock() { string result = ""; MDMachine oMDMachine = new MDMachine(); oMDMachine = oMachine.GetMachineByLineID(Convert.ToInt32(ViewState["ld_id"])); if (oMDMachine.ListOfmachine.Count > 0) { foreach (MDMachine.CMDMachine oMD in oMDMachine.ListOfmachine) { result += " <div class='col-sm-6 col-md-3'>" + Environment.NewLine; result += " <div class='board-widget-wrap'>" + Environment.NewLine; result += " <a href='" + ResolveClientUrl("~/Production/DataHistory/Quantity/PDQuantityData.aspx?ld_id=" + ViewState["ld_id"].ToString()) + "&FactoryID=" + ViewState["FactoryID"].ToString() + "&mc_code=" + oMD.mc_code + "'><i class='icon-tree'></i>" + Environment.NewLine; result += " <span class='board-widget-label'>" + oMD.mc_code + " " + oMD.mc_name + " </span>" + Environment.NewLine; result += " <span class='board-widget-intro'>" + DateTime.Now.ToString() + ", Qty OK: " + oMD.QtyOK + ",</span>" + Environment.NewLine; result += " <span class='board-widget-intro'>Qty NG: " + oMD.QtyNG + "</span>" + Environment.NewLine; result += " </a>" + Environment.NewLine; result += " </div>" + Environment.NewLine; result += " </div>" + Environment.NewLine; } } return(result); }
private void GetMachineName() { MDMachine oMDMachine = new MDMachine(); oMDMachine = oMachine.GetMachineBymc_code(ViewState["mc_code"].ToString()); if (oMDMachine.ListOfmachine.Count > 0) { lbMachine.Text = oMDMachine.ListOfmachine[0].mc_code; } }
private void Start() { player = this; body = GetComponent <Rigidbody2D> (); coll = GetComponent <CapsuleCollider2D> (); trans = transform; rend = GetComponentInChildren <SpriteRenderer> (); momentDoMachine = MDMachine.Humanic_Player(this); motionMachine = MotionMachine.Humanic(this); animMachine = new AnimMachine(characterName, this); }
public MDMachine GetMachineByLineID(int ld_id) { MDMachine oMDMachine = new MDMachine(); DataTable dTable = new DataTable(); SqlCommand sql = new SqlCommand(); sql.CommandText = "SELECT DISTINCT mc_id,mc.mc_code,mc_name,mc_process,mc.ld_id,ld_linename,FactoryName,mc_updateby,mc_updatedate "; sql.CommandText += " ,(SELECT COUNT(d2.data_partnumber) FROM Data d2 WHERE d2.mc_code=mc.mc_code AND (d2.Result='OK' OR d2.Result='1')"; sql.CommandText += " AND d2.data_mfgdate_search >= @DatetimeStart"; sql.CommandText += " AND d2.data_mfgdate_search <= @DatetimeEnd) as QtyOK"; sql.CommandText += " ,(SELECT COUNT(d2.data_partnumber) FROM Data d2 WHERE d2.mc_code = mc.mc_code AND(d2.Result = 'NG' OR d2.Result = '0')"; sql.CommandText += " AND d2.data_mfgdate_search >= @DatetimeStart"; sql.CommandText += " AND d2.data_mfgdate_search <= @DatetimeEnd) as QtyNG"; sql.CommandText += " FROM machine mc"; sql.CommandText += " LEFT JOIN LineData ld ON mc.ld_id = ld.ld_id"; sql.CommandText += " LEFT JOIN FactoryData fac ON ld.FactoryID = fac.FactoryID"; sql.CommandText += " LEFT JOIN Data d ON mc.mc_code = d.mc_code"; sql.CommandText += " WHERE mc.ld_id = @ld_id"; sql.CommandText += " GROUP BY mc_id,mc.mc_code,mc_name,mc_process,mc.ld_id,ld_linename,FactoryName,mc_updateby,mc_updatedate,d.Result"; sql.Parameters.Add(new SqlParameter("@ld_id", ld_id)); string shift = "D"; if (DateTime.Now >= Convert.ToDateTime(DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " 20:00:00")) { shift = "N"; } if (shift == "D") { sql.Parameters.Add(new SqlParameter("@DatetimeStart", DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " 08:00:00")); sql.Parameters.Add(new SqlParameter("@DatetimeEnd", DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " 20:00:00")); } else { sql.Parameters.Add(new SqlParameter("@DatetimeStart", DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + " 20:00:00")); sql.Parameters.Add(new SqlParameter("@DatetimeEnd", DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.AddDays(1).Day.ToString() + " 08:00:00")); } dTable = oConn.Query(sql); if (dTable.Rows.Count > 0) { foreach (DataRow row in dTable.Rows) { MDMachine.CMDMachine oMD = new MDMachine.CMDMachine(); oMD.mc_id = row["mc_id"] != DBNull.Value ? Convert.ToInt32(row["mc_id"]) : 0; oMD.mc_code = row["mc_code"].ToString(); oMD.mc_name = row["mc_name"].ToString(); oMD.mc_process = row["mc_process"].ToString(); oMD.ld_id = row["ld_id"] != DBNull.Value ? Convert.ToInt32(row["ld_id"]) : 0; oMD.ld_linename = row["ld_linename"].ToString(); oMD.FactoryName = row["FactoryName"].ToString(); oMD.mc_updateby = row["mc_updateby"].ToString(); oMD.mc_updatedate = row["mc_updatedate"].ToString(); oMD.QtyOK = row["QtyOK"] != DBNull.Value ? Convert.ToInt32(row["QtyOK"]) : 0; oMD.QtyNG = row["QtyNG"] != DBNull.Value ? Convert.ToInt32(row["QtyNG"]) : 0; oMDMachine.ListOfmachine.Add(oMD); } } return(oMDMachine); }