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);
}
