예제 #1
0
        public ReturnProductionList Insert(ProductionList productionList)
        {
            ReturnProductionList returnProductionList = new ReturnProductionList();

            try
            {
                using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
                {
                    using (SqlCommand cmd = new SqlCommand("", sqlConnection))
                    {
                        cmd.CommandText = "sp_tProductionList_InsertUpdate";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add(new SqlParameter("@IndicatorID", SqlDbType.VarChar)).Value = productionList.IndicatorID;
                        cmd.Parameters.Add(new SqlParameter("@ItemName", SqlDbType.VarChar)).Value    = productionList.ItemName;
                        cmd.Parameters.Add(new SqlParameter("@ItemCode", SqlDbType.VarChar)).Value    = productionList.ItemCode;
                        cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = productionList.ProgramName;
                        cmd.Parameters.Add(new SqlParameter("@BatchNo", SqlDbType.VarChar)).Value     = productionList.BatchNo;
                        cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value      = productionList.LineID;
                        cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value   = productionList.MachineTypeID;
                        cmd.Parameters.Add(new SqlParameter("@PatternCode", SqlDbType.VarChar)).Value = productionList.PatternCode;
                        cmd.ExecuteNonQuery();

                        returnProductionList.Code    = "00";
                        returnProductionList.Message = "Cập nhật dữ liệu thành công.";
                    }
                }
            }
            catch (Exception ex)
            {
                returnProductionList.Code              = "99";
                returnProductionList.Message           = "Lỗi xử lý dữ liệu: " + ex.ToString();
                returnProductionList.Total             = 0;
                returnProductionList.lstProductionList = null;
                mylog4net.Error("", ex);
            }
            return(returnProductionList);
        }
예제 #2
0
        public ReturnProductionList GetbyID(string ID)
        {
            List <ProductionList> lstProductionList    = null;
            ProductionList        productionList       = null;
            ReturnProductionList  returnProductionList = new ReturnProductionList();

            try
            {
                using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
                {
                    using (SqlCommand cmd = new SqlCommand("", sqlConnection))
                    {
                        //cmd.Connection = _sqlConnection;
                        cmd.CommandText = "sp_tProductionList_SelectByID";
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.Parameters.Add(new SqlParameter("@IndicatorID", SqlDbType.VarChar)).Value = ID;

                        using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
                        {
                            if (sqlDr.HasRows)
                            {
                                lstProductionList = new List <ProductionList>();
                                while (sqlDr.Read())
                                {
                                    productionList                 = new ProductionList();
                                    productionList.IndicatorID     = sqlDr["IndicatorID"].ToString();
                                    productionList.ItemName        = sqlDr["ItemName"].ToString();
                                    productionList.ItemCode        = sqlDr["ItemCode"].ToString();
                                    productionList.BatchNo         = sqlDr["BatchNo"].ToString();
                                    productionList.ProgramName     = sqlDr["ProgramName"].ToString();
                                    productionList.LineID          = sqlDr["LineID"].ToString();
                                    productionList.MachineTypeID   = Convert.ToInt32(sqlDr["MachineTypeID"].ToString());
                                    productionList.PatternCode     = sqlDr["PatternCode"].ToString();
                                    productionList.MachineTypeName = sqlDr["TypeName"].ToString();
                                    lstProductionList.Add(productionList);
                                }
                                returnProductionList.Code              = "00";
                                returnProductionList.Message           = "Lấy dữ liệu thành công.";
                                returnProductionList.lstProductionList = lstProductionList;
                                returnProductionList.Total             = lstProductionList.Count;
                                //}
                            }
                            else
                            {
                                returnProductionList.Code              = "01";
                                returnProductionList.Message           = "Không tồn tại bản ghi nào.";
                                returnProductionList.Total             = 0;
                                returnProductionList.lstProductionList = null;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                returnProductionList.Code              = "99";
                returnProductionList.Message           = "Lỗi xử lý dữ liệu: " + ex.ToString();
                returnProductionList.Total             = 0;
                returnProductionList.lstProductionList = null;
                mylog4net.Error("", ex);
            }
            return(returnProductionList);
        }