//}
public Hashtable GetProductCTTable2()
{
Hashtable ctTable = new Hashtable();
try
{
DataSet dataSet = null;
//string strSql = "SELECT * FROM tlb_product ORDER BY CREATE_TIME ASC";
string strSql = "SELECT * FROM tlb_product ";
dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet != null)
{
foreach (DataRow row in dataSet.Tables[0].Rows)
{
ProductionMDL mdl = ProductionMDL.ParseDataRow(row);
CTUnitMDL unit = new CTUnitMDL();
unit.PN = mdl.PN;
unit.CT = mdl.CT;
unit.EMS = mdl.EMS;
unit.OP = mdl.OP;
ctTable.Add(mdl.PN, unit);
}
}
return(ctTable);
}
catch
{
throw;
}
}
/// <summary>
/// 查询过去CTUNIT
/// </summary>
/// <param name="LineID"></param>
/// <param name="ems"></param>
/// <returns></returns>
public CTUnitMDL GetCTUnit(string lineid, int ems)
{
CTUnitMDL unit = null;
try
{
int id = 0;
Int32.TryParse(lineid, out id);
if (id <= 0)
{
return(null);
}
string strSql = "SELECT * FROM tlb_product WHERE PLID='{0}' AND EMS={1}";
strSql = string.Format(strSql, id.ToString(), ems);
DataSet dataSet = null;
dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
ProductionMDL mdl = ProductionMDL.ParseDataRow(dataSet.Tables[0].Rows[0]);
unit = new CTUnitMDL();
unit.PN = mdl.PN;
unit.CT = mdl.CT;
unit.EMS = mdl.EMS;
unit.OP = mdl.OP;
return(unit);
}
else
{
return(null);
}
}
catch
{
return(null);
}
}
