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