/// <summary>
///获取生产线信息
/// </summary>
/// <returns></returns>
public DataTable GetProductionInfos()
{
try
{
DataSet dataSet = null;
string strSql = "select * from production order by createtime asc";
//dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
dataSet = SQLiteDBHelper.ExecuteDataset(strSql);
if (dataSet != null)
{
return(dataSet.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(null);
}
}
/// <summary>
/// 获取产品名称
/// </summary>
/// <returns></returns>
public ArrayList GetProductionNames()
{
try
{
ArrayList list = new ArrayList();
DataSet dataSet = null;
string strSql = "select * from production order by createtime asc";
// dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
dataSet = SQLiteDBHelper.ExecuteDataset(strSql);
foreach (DataRow dr in dataSet.Tables[0].Rows)
{
list.Add(Convert.ToString(dr["brakename"]));
}
if (list.Count <= 0)
{
return(null);
}
return(list);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(null);
}
}
/// <summary>
/// 获取产品计划通过计划ID
/// </summary>
/// <param name="planid"></param>
/// <returns></returns>
public DataTable GetAcqCountUnits()
{
try
{
DataSet dataSet = null;
string strSql = "select CurrentCount from acq_count_list ";
// strSql = string.Format(strSql, tid);
//dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
dataSet = SQLiteDBHelper.ExecuteDataset(strSql);
if (dataSet != null)
{
return(dataSet.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(null);
}
}
/// <summary>
/// 获取产品计划通过产品ID和时间
/// </summary>
/// <param name="planid"></param>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <returns></returns>
public DataTable GetProductionPalnByDateTime(string planid, DateTime startTime, DateTime endTime)
{
try
{
DataSet dataSet = null;
string strSql = "select * from production_plan where plan_id='{0}' and create_time between '{1}' and '{2}' order by start_time desc";
strSql = string.Format(strSql, planid);
dataSet = SQLiteDBHelper.ExecuteDataset(strSql);
if (dataSet != null)
{
return(dataSet.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(null);
}
}
/// <summary>
/// 通过计划ID获取产线计划
/// </summary>
/// <param name="planid"></param>
/// <returns></returns>
public DataTable GetProductionPalnByPlanID2(string planid)
{
try
{
DataSet dataSet = null;
string strSql = "select * from production_plan where planid='{0}' ";
strSql = string.Format(strSql, planid);
//dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
dataSet = SQLiteDBHelper.ExecuteDataset(strSql);
if (dataSet != null)
{
return(dataSet.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(null);
}
}
/// <summary>
/// 获取产品计划通过序号ID
/// </summary>
/// <param name="planid"></param>
/// <returns></returns>
public ProductionPlanMDL GetProductionPalnByID(int tid)
{
try
{
ProductionPlanMDL mdl = new ProductionPlanMDL();
DataSet dataSet = null;
string strSql = "select * from production_plan where tid='{0}' ";
strSql = string.Format(strSql, tid);
//dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
dataSet = SQLiteDBHelper.ExecuteDataset(strSql);
if (dataSet != null)
{
DataRow row = dataSet.Tables[0].Rows[0];
mdl.Prase(row);
return(mdl);
}
return(null);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(null);
}
}
