public ReturnProductionList DeleteByID(string _ID)
{
ReturnProductionList returnProductionList = new ReturnProductionList();
try
{
// Gọi vào DB để lấy dữ liệu.
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProductionList_DeleteByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IndicatorID", SqlDbType.VarChar)).Value = _ID;
//cmd.Parameters.Add("@RETURN_CODE", SqlDbType.Int).Direction = ParameterDirection.Output;
//int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value);
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);
}
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);
}
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);
}