public ReturnProgramPdtCtrl Insert(ProgramPdtCtrl p)
{
ReturnProgramPdtCtrl returnProgramPdtCtrl = new ReturnProgramPdtCtrl();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProgramPdtCtrl_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.ProgramName;
cmd.Parameters.Add(new SqlParameter("@Part", SqlDbType.NVarChar)).Value = String.IsNullOrEmpty(p.Part) ? "" : p.Part;
cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = p.ControlItem;
cmd.Parameters.Add(new SqlParameter("@ColumnName", SqlDbType.NVarChar)).Value = String.IsNullOrEmpty(p.ColumnName) ? "" : p.ColumnName;
cmd.Parameters.Add(new SqlParameter("@LowerLimit", SqlDbType.NVarChar)).Value = p.LowerLimit;
cmd.Parameters.Add(new SqlParameter("@Unit", SqlDbType.NVarChar)).Value = String.IsNullOrEmpty(p.Unit) ? "" : p.Unit;
cmd.Parameters.Add(new SqlParameter("@UpperLimit", SqlDbType.NVarChar)).Value = p.UpperLimit;
cmd.Parameters.Add(new SqlParameter("@OperatorID", SqlDbType.Int)).Value = p.OperatorID;
cmd.Parameters.Add(new SqlParameter("@SpecDisplay", SqlDbType.NVarChar)).Value = String.IsNullOrEmpty(p.SpecDisplay) ? "" : p.SpecDisplay;
//int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value);
cmd.ExecuteNonQuery();
returnProgramPdtCtrl.Code = "00";
returnProgramPdtCtrl.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnProgramPdtCtrl.Code = "99";
returnProgramPdtCtrl.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProgramPdtCtrl.Total = 0;
returnProgramPdtCtrl.lstProgramPdtCtrl = null;
mylog4net.Error("", ex);
}
return(returnProgramPdtCtrl);
}
public ReturnMachine Insert(Machine machine)
{
ReturnMachine returnMachine = new ReturnMachine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineList_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = machine.MachineID;
cmd.Parameters.Add(new SqlParameter("@MachineName", SqlDbType.NVarChar)).Value = machine.MachineName;
cmd.Parameters.Add(new SqlParameter("@MachineNumber", SqlDbType.NVarChar)).Value = machine.MachineNumber;
cmd.Parameters.Add(new SqlParameter("@Area", SqlDbType.VarChar)).Value = machine.Area;
cmd.Parameters.Add(new SqlParameter("@Section", SqlDbType.VarChar)).Value = machine.Section == null ? "" : machine.Section;
cmd.Parameters.Add(new SqlParameter("@ReceiveDate", SqlDbType.DateTime)).Value = machine.ReceiveDate;
cmd.Parameters.Add(new SqlParameter("@Maker", SqlDbType.VarChar)).Value = machine.Maker == null ? "" : machine.Maker;
cmd.Parameters.Add(new SqlParameter("@SerialNumber", SqlDbType.VarChar)).Value = machine.SerialNumber == null ? "" : machine.SerialNumber;
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = machine.LineID;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = machine.MachineTypeID;
cmd.ExecuteNonQuery();
returnMachine.Code = "00";
returnMachine.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachine.Code = "99";
returnMachine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachine.Total = 0;
returnMachine.lstMachine = null;
mylog4net.Error("", ex);
}
return(returnMachine);
}
public ReturnToolCleaningContent Insert(ToolCleaningContent toolCleaningContent)
{
ReturnToolCleaningContent returnToolCleaningContent = new ReturnToolCleaningContent();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tToolCleaningContent_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ToolID", SqlDbType.VarChar)).Value = toolCleaningContent.ToolID;
cmd.Parameters.Add(new SqlParameter("@LineUsing", SqlDbType.VarChar)).Value = toolCleaningContent.LineUsing;
cmd.Parameters.Add(new SqlParameter("@Shift", SqlDbType.SmallInt)).Value = toolCleaningContent.Shift;
cmd.Parameters.Add(new SqlParameter("@Result", SqlDbType.VarChar)).Value = toolCleaningContent.Result;
cmd.Parameters.Add(new SqlParameter("@NGContents", SqlDbType.NVarChar)).Value = toolCleaningContent.NGContents;
cmd.Parameters.Add(new SqlParameter("@RepairDate", SqlDbType.DateTime)).Value = toolCleaningContent.RepairDate;
cmd.Parameters.Add(new SqlParameter("@RepairContents", SqlDbType.NVarChar)).Value = toolCleaningContent.RepairContents;
cmd.Parameters.Add(new SqlParameter("@RepairID", SqlDbType.VarChar)).Value = toolCleaningContent.RepairID;
cmd.Parameters.Add(new SqlParameter("@CheckBy", SqlDbType.VarChar)).Value = toolCleaningContent.CheckBy;
cmd.Parameters.Add(new SqlParameter("@ImageLink", SqlDbType.VarChar)).Value = String.IsNullOrEmpty(toolCleaningContent.ImageLink) ? "" : toolCleaningContent.ImageLink;
cmd.ExecuteNonQuery();
returnToolCleaningContent.Code = "00";
returnToolCleaningContent.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnToolCleaningContent.Code = "99";
returnToolCleaningContent.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnToolCleaningContent.Total = 0;
returnToolCleaningContent.LstToolCleaningContent = null;
mylog4net.Error("", ex);
}
return(returnToolCleaningContent);
}
public ReturnFPB Insert(FPB FPB)
{
ReturnFPB returnFPB = new ReturnFPB();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_FPB_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = FPB.ID;
cmd.Parameters.Add(new SqlParameter("@IDFPBCheckingItem", SqlDbType.Int)).Value = FPB.IDFPBCheckingItem;
cmd.Parameters.Add(new SqlParameter("@FPBDate", SqlDbType.DateTime)).Value = FPB.FPBDate;
cmd.Parameters.Add(new SqlParameter("@IndicationNo", SqlDbType.VarChar)).Value = FPB.IndicationNo;
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.VarChar)).Value = FPB.UserID;
cmd.Parameters.Add(new SqlParameter("@SeqNo", SqlDbType.VarChar)).Value = FPB.SeqNo;
cmd.Parameters.Add(new SqlParameter("@BlockID", SqlDbType.VarChar)).Value = FPB.BlockID;
cmd.Parameters.Add(new SqlParameter("@Result", SqlDbType.VarChar)).Value = FPB.Result;
cmd.Parameters.Add(new SqlParameter("@ResultContent", SqlDbType.NVarChar)).Value = FPB.ResultContent;
cmd.ExecuteNonQuery();
returnFPB.Code = "00";
returnFPB.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnFPB.Code = "99";
returnFPB.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPB.Total = 0;
returnFPB.LstFPB = null;
mylog4net.Error("", ex);
}
return(returnFPB);
}
public ReturnMachineMtnContentList ImportExcel(Import_MachineMtnType_ContentList import_aMachineMtnType_ContentList)
{
ReturnMachineMtnContentList returnMachineTypeMtnContentList = new ReturnMachineMtnContentList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtnContentList_ImportExcel";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineMtnContentList.ID;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = import_aMachineMtnType_ContentList.MachineTypeID;
cmd.Parameters.Add(new SqlParameter("@MachinePart", SqlDbType.NVarChar)).Value = import_aMachineMtnType_ContentList.MachinePart.Trim();
cmd.Parameters.Add(new SqlParameter("@ContentMtn", SqlDbType.NVarChar)).Value = import_aMachineMtnType_ContentList.ContentMtn.Trim();
cmd.Parameters.Add(new SqlParameter("@ToolMtn", SqlDbType.NVarChar)).Value = import_aMachineMtnType_ContentList.ToolMtn.Trim();
cmd.Parameters.Add(new SqlParameter("@MethodMtn", SqlDbType.NVarChar)).Value = import_aMachineMtnType_ContentList.MethodMtn.Trim();
cmd.Parameters.Add(new SqlParameter("@Standard", SqlDbType.NVarChar)).Value = import_aMachineMtnType_ContentList.Standard.Trim();
cmd.Parameters.Add(new SqlParameter("@Min", SqlDbType.NVarChar)).Value = import_aMachineMtnType_ContentList.Min.Trim();
cmd.Parameters.Add(new SqlParameter("@Max", SqlDbType.NVarChar)).Value = import_aMachineMtnType_ContentList.Max.Trim();
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.SmallInt)).Value = import_aMachineMtnType_ContentList.FrequencyID;
int x = cmd.ExecuteNonQuery();
returnMachineTypeMtnContentList.Code = "00";
returnMachineTypeMtnContentList.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachineTypeMtnContentList.Code = "99";
returnMachineTypeMtnContentList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineTypeMtnContentList.Total = 0;
returnMachineTypeMtnContentList.lstMachineMtnContentList = null;
mylog4net.Error("public ReturnMachineMtnContentList ImportExcel(Import_MachineMtnType_ContentList import_aMachineMtnType_ContentList): ", ex);
}
return(returnMachineTypeMtnContentList);
}
public ReturnConditionSetting Insert(ConditionSetting conditionSetting)
{
ReturnConditionSetting returnConditionSetting = new ReturnConditionSetting();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProductionControlList_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = conditionSetting.ID;
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = conditionSetting.LineID;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.VarChar)).Value = conditionSetting.MachineTypeID;
cmd.Parameters.Add(new SqlParameter("@PatternCode", SqlDbType.VarChar)).Value = conditionSetting.PatternCode;
cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = conditionSetting.ControlItem;
cmd.Parameters.Add(new SqlParameter("@SpecDisplay", SqlDbType.NVarChar)).Value = conditionSetting.SpecDisplay;
cmd.Parameters.Add(new SqlParameter("@Unit", SqlDbType.NVarChar)).Value = conditionSetting.Unit;
cmd.Parameters.Add(new SqlParameter("@LowerLimit", SqlDbType.Float)).Value = conditionSetting.LowerLimit;
cmd.Parameters.Add(new SqlParameter("@UpperLimit", SqlDbType.Float)).Value = conditionSetting.UpperLimit;
cmd.ExecuteNonQuery();
returnConditionSetting.Code = "00";
returnConditionSetting.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnConditionSetting.Code = "99";
returnConditionSetting.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnConditionSetting.Total = 0;
returnConditionSetting.lstConditionSetting = null;
mylog4net.Error("", ex);
}
return(returnConditionSetting);
}
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 ReturnToolIQC Insert(ToolIQC _toolIQC)
{
ReturnToolIQC returnToolIQC = new ReturnToolIQC();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tToolIQC_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = _toolIQC.ID;
cmd.Parameters.Add(new SqlParameter("@ToolTypeID", SqlDbType.Int)).Value = _toolIQC.ToolTypeID;
cmd.Parameters.Add(new SqlParameter("@PrefixToolID", SqlDbType.VarChar)).Value = _toolIQC.PrefixToolID;
cmd.Parameters.Add(new SqlParameter("@FromToolID", SqlDbType.VarChar)).Value = _toolIQC.FromToolID;
cmd.Parameters.Add(new SqlParameter("@ToToolID", SqlDbType.VarChar)).Value = _toolIQC.ToToolID;
cmd.Parameters.Add(new SqlParameter("@FileUrl", SqlDbType.NVarChar)).Value = _toolIQC.FileUrl;
cmd.Parameters.Add(new SqlParameter("@FactoryID", SqlDbType.VarChar)).Value = _toolIQC.FactoryID;
cmd.Parameters.Add(new SqlParameter("@OperatorID", SqlDbType.VarChar)).Value = _toolIQC.OperatorID;
cmd.ExecuteNonQuery();
returnToolIQC.Code = "00";
returnToolIQC.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnToolIQC.Code = "99";
returnToolIQC.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnToolIQC.Total = 0;
returnToolIQC.lstToolIQC = null;
mylog4net.Error("", ex);
}
return(returnToolIQC);
}
public ReturnProgramPdtCtrlHistory DeleteByKey(ProgramPdtCtrlHistory p)
{
ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory();
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_tProgramPdtCtrlHistory_DeleteByKey";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.ProgramName;
cmd.Parameters.Add(new SqlParameter("@Parameter", SqlDbType.VarChar)).Value = p.Parameter;
cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.VarChar)).Value = p.ControlItem;
//cmd.Parameters.Add("@RETURN_CODE", SqlDbType.Int).Direction = ParameterDirection.Output;
//int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value);
cmd.ExecuteNonQuery();
returnProgramPdtCtrlHistory.Code = "00";
returnProgramPdtCtrlHistory.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnProgramPdtCtrlHistory.Code = "99";
returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProgramPdtCtrlHistory.Total = 0;
returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null;
mylog4net.Error("", ex);
}
return(returnProgramPdtCtrlHistory);
}
public string GetToolTypeNamebyID(string ToolTypeID)
{
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tToolTypeList_GetToolTypeNamebyID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ToolTypeID", SqlDbType.VarChar)).Value = ToolTypeID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
while (sqlDr.Read())
{
return(sqlDr[0].ToString());
}
}
else
{
return("");
}
}
}
}
}
catch (Exception ex)
{
return("");
}
return("");
}
//public ReturnMachineMtn DeleteMachineMtnDetailByID(int _ID)
//{
// //ReturnMachineMtn returnMachineMtn = new ReturnMachineMtn();
// //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_tMachineMtn_DeleteByID";
// // cmd.CommandType = CommandType.StoredProcedure;
// // cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = _ID;
// // //cmd.Parameters.Add("@RETURN_CODE", SqlDbType.Int).Direction = ParameterDirection.Output;
// // //int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value);
// // cmd.ExecuteNonQuery();
// // returnMachineMtn.Code = "00";
// // returnMachineMtn.Message = "Cập nhật dữ liệu thành công.";
// // }
// // }
// //}
// //catch (Exception ex)
// //{
// // returnMachineMtn.Code = "99";
// // returnMachineMtn.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
// // returnMachineMtn.Total = 0;
// // returnMachineMtn.lstMachineMtn = null;
// // mylog4net.Error("", ex);
// //}
// //return returnMachineMtn;
//}
public ReturnMachineMtn GetMachineMtnbyID(int ID)
{
List <MachineMtn> lstMachineMtn = null;
MachineMtn machineMtn = null;
ReturnMachineMtn returnMachineMtn = new ReturnMachineMtn();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtn_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = ID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstMachineMtn = new List <MachineMtn>();
while (sqlDr.Read())
{
machineMtn = new MachineMtn();
machineMtn.ID = Convert.ToInt16(sqlDr["ID"].ToString());
machineMtn.MachineID = sqlDr["MachineID"].ToString();
//get MachineName.
ReturnMachine returnMachine = (new MachineDB()).GetbyID(machineMtn.MachineID);
if (returnMachine.Code == "00")
{
machineMtn.MachineName = returnMachine.lstMachine[0].MachineName;
}
//get OperatorName.
int _operatorID = 0;
ReturnUser returnUser;
if (Int32.TryParse(sqlDr["OperatorID"].ToString(), out _operatorID))
{
returnUser = (new UserDB()).GetbyID(_operatorID);
if (returnUser.Code == "00")
{
machineMtn.OperatorName = returnUser.lstUser[0].UserName;
}
}
machineMtn.Shift = Convert.ToInt16(sqlDr["Shift"].ToString());
machineMtn.MaintenanceDate = Convert.ToDateTime(sqlDr["MaintenanceDate"].ToString());
if (!String.IsNullOrEmpty(sqlDr["FrequencyID"].ToString()))
{
machineMtn.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString());
}
machineMtn.Result = sqlDr["Result"].ToString();
machineMtn.ResultContents = sqlDr["ResultContents"].ToString();
if (!String.IsNullOrEmpty(sqlDr["Month"].ToString()))
{
machineMtn.Month = Convert.ToInt16(sqlDr["Month"].ToString());
}
if (!String.IsNullOrEmpty(sqlDr["Year"].ToString()))
{
machineMtn.Year = Convert.ToInt16(sqlDr["Year"].ToString());
}
if (!String.IsNullOrEmpty(sqlDr["Week"].ToString()))
{
machineMtn.Week = Convert.ToInt16(sqlDr["Week"].ToString());
}
if (sqlDr["CheckerID"].ToString() != "")
{
machineMtn.CheckerID = Convert.ToInt16(sqlDr["CheckerID"].ToString());
//get name.
int _CheckerID = 0;
ReturnUser returnChecker;
if (Int32.TryParse(sqlDr["CheckerID"].ToString(), out _operatorID))
{
returnChecker = (new UserDB()).GetbyID(_CheckerID);
if (returnChecker.Code == "00")
{
machineMtn.CheckerName = returnChecker.lstUser[0].UserName;
}
}
}
if (sqlDr["CheckerResult"].ToString() != "")
{
machineMtn.CheckerResult = sqlDr["CheckerResult"].ToString();
}
lstMachineMtn.Add(machineMtn);
}
returnMachineMtn.Code = "00";
returnMachineMtn.Message = "Lấy dữ liệu thành công.";
returnMachineMtn.lstMachineMtn = lstMachineMtn;
returnMachineMtn.UserID = MyShareInfo.ID;
returnMachineMtn.UserName = MyShareInfo.UserName;
}
else
{
returnMachineMtn.Code = "01";
returnMachineMtn.Message = "Không tồn tại bản ghi nào.";
returnMachineMtn.Total = 0;
returnMachineMtn.lstMachineMtn = null;
returnMachineMtn.UserID = MyShareInfo.ID;
returnMachineMtn.UserName = MyShareInfo.UserName;
}
}
}
}
}
catch (Exception ex)
{
returnMachineMtn.Code = "99";
returnMachineMtn.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineMtn.Total = 0;
returnMachineMtn.lstMachineMtn = null;
mylog4net.Error("", ex);
}
return(returnMachineMtn);
}
public ReturnMachineMtn Insert(MachineMtn machineMtn)
{
ReturnMachineMtn returnMachineMtn = new ReturnMachineMtn();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtn_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineMtn.ID;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = machineMtn.MachineID;
cmd.Parameters.Add(new SqlParameter("@OperatorID", SqlDbType.VarChar)).Value = machineMtn.OperatorID;
if (machineMtn.Shift != 0)
{
cmd.Parameters.Add(new SqlParameter("@Shift", SqlDbType.SmallInt)).Value = machineMtn.Shift;
}
else
{
cmd.Parameters.Add(new SqlParameter("@Shift", SqlDbType.SmallInt)).Value = DBNull.Value;
}
cmd.Parameters.Add(new SqlParameter("@MaintenanceDate", SqlDbType.DateTime)).Value = machineMtn.MaintenanceDate;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = machineMtn.FrequencyID;
cmd.Parameters.Add(new SqlParameter("@Result", SqlDbType.VarChar)).Value = machineMtn.Result;
cmd.Parameters.Add(new SqlParameter("@ResultContents", SqlDbType.NVarChar)).Value = "";
if (machineMtn.Week != 0)
{
cmd.Parameters.Add(new SqlParameter("@Week", SqlDbType.Int)).Value = machineMtn.Week;
}
else
{
cmd.Parameters.Add(new SqlParameter("@Week", SqlDbType.Int)).Value = DBNull.Value;
}
if (machineMtn.Month != 0)
{
cmd.Parameters.Add(new SqlParameter("@Month", SqlDbType.SmallInt)).Value = machineMtn.Month;
}
else
{
cmd.Parameters.Add(new SqlParameter("@Month", SqlDbType.SmallInt)).Value = DBNull.Value;
}
if (machineMtn.Year != 0)
{
cmd.Parameters.Add(new SqlParameter("@Year", SqlDbType.Int)).Value = machineMtn.Year;
}
else
{
cmd.Parameters.Add(new SqlParameter("@Year", SqlDbType.Int)).Value = DBNull.Value;
}
cmd.Parameters.Add(new SqlParameter("@CheckerID", SqlDbType.Int)).Value = machineMtn.CheckerID;
cmd.Parameters.Add(new SqlParameter("@CheckerResult", SqlDbType.VarChar)).Value = machineMtn.CheckerResult;
cmd.Parameters.Add("@LastID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
returnMachineMtn.Code = "00";
returnMachineMtn.Message = "Cập nhật dữ liệu thành công.";
//if (returnMachineMtn.Code == "00")
// returnMachineMtn.LastID = Convert.ToInt32(cmd.Parameters["@LastID"].Value);
if (returnMachineMtn.Code == "00")
{
returnMachineMtn.LastID = Convert.ToInt32(cmd.Parameters["@LastID"].Value);
}
}
}
}
catch (Exception ex)
{
returnMachineMtn.Code = "99";
returnMachineMtn.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineMtn.Total = 0;
returnMachineMtn.lstMachineMtn = null;
mylog4net.Error("", ex);
}
return(returnMachineMtn);
}
public ReturnProductionControl SearchProductionControl(string where)
{
List <ProductionControl> lstProductionControl = null;
ProductionControl productionControl = null;
ReturnProductionControl returnProductionControl = new ReturnProductionControl();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProductionControl_SearchProductionControl";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@where", SqlDbType.NVarChar)).Value = where;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstProductionControl = new List <ProductionControl>();
while (sqlDr.Read())
{
productionControl = new ProductionControl();
productionControl.ID = int.Parse(sqlDr["ID"].ToString());
productionControl.IndicationID = sqlDr["IndicationID"].ToString();
productionControl.MachineID = sqlDr["MachineID"].ToString();
productionControl.MachineName = sqlDr["MachineName"].ToString();
productionControl.PdtCtrlDateTime = Convert.ToDateTime(sqlDr["PdtCtrlDateTime"].ToString());
productionControl.UserID = sqlDr["UserID"].ToString();
productionControl.UserName = sqlDr["UserName"].ToString();
productionControl.ItemName = sqlDr["ItemName"].ToString();
productionControl.ItemCode = sqlDr["ItemCode"].ToString();
productionControl.BatchNo = sqlDr["BatchNo"].ToString();
productionControl.SeqNo = sqlDr["SeqNo"].ToString();
productionControl.Result = sqlDr["Result"].ToString();
productionControl.ProgramName = sqlDr["ProgramName"].ToString();
lstProductionControl.Add(productionControl);
}
returnProductionControl.Code = "00";
returnProductionControl.Message = "Lấy dữ liệu thành công.";
returnProductionControl.lstProductionControl = lstProductionControl;
returnProductionControl.userID = MyShareInfo.ID;
returnProductionControl.UserName = MyShareInfo.UserName;
}
else
{
returnProductionControl.Code = "01";
returnProductionControl.Message = "Không tồn tại bản ghi nào.";
returnProductionControl.Total = 0;
returnProductionControl.lstProductionControl = null;
returnProductionControl.userID = MyShareInfo.ID;
returnProductionControl.UserName = MyShareInfo.UserName;
}
}
}
}
}
catch (Exception ex)
{
returnProductionControl.Code = "99";
returnProductionControl.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProductionControl.Total = 0;
returnProductionControl.lstProductionControl = null;
mylog4net.Error("", ex);
}
return(returnProductionControl);
}
public ReturnFPB GetbyID(string ID)
{
List <FPB> lstFPB = null;
FPB FPB = null;
ReturnFPB returnFPB = new ReturnFPB();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_FPB_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = int.Parse(ID);
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstFPB = new List <FPB>();
while (sqlDr.Read())
{
FPB = new FPB();
FPB.ID = int.Parse(sqlDr["ID"].ToString());
FPB.IDFPBCheckingItem = int.Parse(sqlDr["IDFPBCheckingItem"].ToString());
FPB.FPBDate = DateTime.Parse(sqlDr["FPBDate"].ToString());
FPB.IndicationNo = sqlDr["IndicationNo"].ToString();
FPB.UserID = sqlDr["UserID"].ToString();
FPB.SeqNo = sqlDr["SeqNo"].ToString();
FPB.BlockID = sqlDr["BlockID"].ToString();
FPB.Result = sqlDr["Result"].ToString();
FPB.ResultContent = sqlDr["ResultContent"].ToString();
lstFPB.Add(FPB);
}
returnFPB.Code = "00";
returnFPB.Message = "Lấy dữ liệu thành công.";
returnFPB.LstFPB = lstFPB;
}
else
{
returnFPB.Code = "01";
returnFPB.Message = "Không tồn tại bản ghi nào.";
returnFPB.Total = 0;
returnFPB.LstFPB = null;
}
}
}
}
}
catch (Exception ex)
{
returnFPB.Code = "99";
returnFPB.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPB.Total = 0;
returnFPB.LstFPB = null;
mylog4net.Error("", ex);
}
return(returnFPB);
}
public ReturnProductionControl SearchProductionControl_UsingDataTables(SearchProductionControl searchProductionControl, int pageNumber, int pageSize)
{
List <ProductionControl> lstProductionControl = null;
ProductionControl productionControl = null;
ReturnProductionControl returnProductionControl = new ReturnProductionControl();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProductionControl_SearchProductionControl";
cmd.Parameters.AddWithValue("@MachineID", searchProductionControl.MachineID);
cmd.Parameters.AddWithValue("@IndicationID", searchProductionControl.IndicationID);
cmd.Parameters.AddWithValue("@ProgramName", searchProductionControl.ProgramName);
cmd.Parameters.AddWithValue("@Result", searchProductionControl.Result);
if (searchProductionControl.FromDate != DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@FromDate", searchProductionControl.FromDate);
}
if (searchProductionControl.ToDate != DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@ToDate", searchProductionControl.ToDate);
}
//paging
cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = pageNumber;
cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize;
cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@where", SqlDbType.NVarChar)).Value = where;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstProductionControl = new List <ProductionControl>();
while (sqlDr.Read())
{
productionControl = new ProductionControl();
productionControl.ID = int.Parse(sqlDr["ID"].ToString());
productionControl.IndicationID = sqlDr["IndicationID"].ToString();
productionControl.MachineID = sqlDr["MachineID"].ToString();
productionControl.MachineName = sqlDr["MachineName"].ToString();
productionControl.PdtCtrlDateTime = Convert.ToDateTime(sqlDr["PdtCtrlDateTime"].ToString());
productionControl.UserID = sqlDr["UserID"].ToString();
productionControl.UserName = sqlDr["UserName"].ToString();
productionControl.ItemName = sqlDr["ItemName"].ToString();
productionControl.ItemCode = sqlDr["ItemCode"].ToString();
productionControl.BatchNo = sqlDr["BatchNo"].ToString();
productionControl.SeqNo = sqlDr["SeqNo"].ToString();
productionControl.Result = sqlDr["Result"].ToString();
productionControl.ProgramName = sqlDr["ProgramName"].ToString();
lstProductionControl.Add(productionControl);
}
returnProductionControl.Code = "00";
returnProductionControl.Message = "Lấy dữ liệu thành công.";
returnProductionControl.lstProductionControl = lstProductionControl;
}
else
{
returnProductionControl.Code = "01";
returnProductionControl.Message = "Không tồn tại bản ghi nào.";
returnProductionControl.Total = 0;
returnProductionControl.lstProductionControl = null;
}
}
//paging.
if (returnProductionControl.Code == "00")
{
returnProductionControl.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value);
}
}
}
}
catch (Exception ex)
{
returnProductionControl.Code = "99";
returnProductionControl.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProductionControl.Total = 0;
returnProductionControl.lstProductionControl = null;
mylog4net.Error("", ex);
}
return(returnProductionControl);
}
public ReturnToolList SelectByCondition(string where)
{
List <ToolList> lstToolList = null;
ToolList toolList = null;
ReturnToolList returnToolList = new ReturnToolList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tToolList_SelectByCondition";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@where", SqlDbType.NVarChar)).Value = where;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstToolList = new List <ToolList>();
while (sqlDr.Read())
{
toolList = new ToolList();
toolList.ToolID = sqlDr["ToolID"].ToString();
toolList.UserID = sqlDr["UserID"].ToString();
toolList.UserName = sqlDr["UserName"].ToString();
toolList.ToolType = sqlDr["ToolType"].ToString();
toolList.ItemCode = sqlDr["ItemCode"].ToString();
toolList.Maker = sqlDr["Maker"].ToString();
toolList.Specification = sqlDr["Specification"].ToString();
toolList.ReceiveDate = DateTime.Parse(sqlDr["ReceiveDate"].ToString());
toolList.StartUsing = DateTime.Parse(sqlDr["StartUsing"].ToString());
//toolList.ReceiveDate = sqlDr["ReceiveDate"].ToString();
//toolList.StartUsing = sqlDr["StartUsing"].ToString();
toolList.LifeTime = sqlDr["LifeTime"].ToString();
toolList.ExpireDate = DateTime.Parse(sqlDr["ExpireDate"].ToString());
//toolList.ExpireDate = sqlDr["ExpireDate"].ToString();
toolList.LineID = sqlDr["LineID"].ToString();
toolList.Status = sqlDr["Status"].ToString();
toolList.Remark = sqlDr["Remark"].ToString();
toolList.ImageUrl = sqlDr["ImageUrl"].ToString();
toolList.CreatedDate = DateTime.Parse(sqlDr["CreatedDate"].ToString());
toolList.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstToolList.Add(toolList);
}
returnToolList.Code = "00";
returnToolList.Message = "Lấy dữ liệu thành công.";
//_ReturnToolList.Total = Convert.ToInt32(cmd.Parameters["P_TOTAL"].Value.ToString());
returnToolList.lstToolList = lstToolList;
returnToolList.UserID = MyShareInfo.ID;
returnToolList.UserName = MyShareInfo.UserName;
//}
}
else
{
returnToolList.Code = "01";
returnToolList.Message = "Không tồn tại bản ghi nào.";
returnToolList.Total = 0;
returnToolList.lstToolList = null;
returnToolList.UserID = MyShareInfo.ID;
returnToolList.UserName = MyShareInfo.UserName;
}
}
}
}
}
catch (Exception ex)
{
returnToolList.Code = "99";
returnToolList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnToolList.Total = 0;
returnToolList.lstToolList = null;
}
return(returnToolList);
}
public ReturnConditionSetting GetbyID(int ID)
{
List <ConditionSetting> lstConditionSetting = null;
ConditionSetting conditionSetting = null;
ReturnConditionSetting returnConditionSetting = new ReturnConditionSetting();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tProductionControlList_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = ID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstConditionSetting = new List <ConditionSetting>();
while (sqlDr.Read())
{
conditionSetting = new ConditionSetting();
conditionSetting.ID = Convert.ToInt32(sqlDr["ID"].ToString());
conditionSetting.LineID = sqlDr["LineID"].ToString();
conditionSetting.MachineTypeID = Convert.ToInt32(sqlDr["MachineTypeID"].ToString());
conditionSetting.MachineTypeName = sqlDr["TypeName"].ToString();
conditionSetting.PatternCode = sqlDr["PatternCode"].ToString();
conditionSetting.ControlItem = sqlDr["ControlItem"].ToString();
conditionSetting.SpecDisplay = sqlDr["SpecDisplay"].ToString();
conditionSetting.Unit = sqlDr["Unit"].ToString();
conditionSetting.LowerLimit = float.Parse(sqlDr["LowerLimit"].ToString());
conditionSetting.UpperLimit = float.Parse(sqlDr["UpperLimit"].ToString());
lstConditionSetting.Add(conditionSetting);
}
returnConditionSetting.Code = "00";
returnConditionSetting.Message = "Lấy dữ liệu thành công.";
//_ReturnTool.Total = Convert.ToInt32(cmd.Parameters["P_TOTAL"].Value.ToString());
returnConditionSetting.lstConditionSetting = lstConditionSetting;
//}
}
else
{
returnConditionSetting.Code = "01";
returnConditionSetting.Message = "Không tồn tại bản ghi nào.";
returnConditionSetting.Total = 0;
returnConditionSetting.lstConditionSetting = null;
}
}
}
}
}
catch (Exception ex)
{
returnConditionSetting.Code = "99";
returnConditionSetting.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnConditionSetting.Total = 0;
returnConditionSetting.lstConditionSetting = null;
mylog4net.Error("", ex);
}
return(returnConditionSetting);
}
public ReturnProgramPdtCtrlHistory GetbyKey(ProgramPdtCtrlHistory p)
{
List <ProgramPdtCtrlHistory> lstProgramPdtCtrlHistory = null;
ProgramPdtCtrlHistory programPdtCtrlHistory = null;
ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tProgramPdtCtrlHistory_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.ProgramName;
cmd.Parameters.Add(new SqlParameter("@Parameter", SqlDbType.NVarChar)).Value = p.Parameter;
cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = p.ControlItem;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstProgramPdtCtrlHistory = new List <ProgramPdtCtrlHistory>();
while (sqlDr.Read())
{
programPdtCtrlHistory = new ProgramPdtCtrlHistory();
programPdtCtrlHistory.ProgramName = sqlDr["ProgramName"].ToString();
programPdtCtrlHistory.Parameter = sqlDr["Parameter"].ToString();
programPdtCtrlHistory.ControlItem = sqlDr["ControlItem"].ToString();
programPdtCtrlHistory.ColumnName = sqlDr["ColumnName"].ToString();
programPdtCtrlHistory.Unit = sqlDr["Unit"].ToString();
programPdtCtrlHistory.SpecDisplay = sqlDr["SpecDisplay"].ToString();
programPdtCtrlHistory.LowerLimit = sqlDr["LowerLimit"].ToString();
programPdtCtrlHistory.UpperLimit = sqlDr["UpperLimit"].ToString();
if (!String.IsNullOrEmpty(sqlDr["HistoryOperatorID"].ToString()))
{
programPdtCtrlHistory.HistoryOperatorID = Int32.Parse(sqlDr["HistoryOperatorID"].ToString());//Convert.ToInt32(sqlDr["HistoryOperatorID"].ToString());
programPdtCtrlHistory.HistoryOperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.HistoryOperatorID));
}
if (!String.IsNullOrEmpty(sqlDr["OperatorID"].ToString()))
{
programPdtCtrlHistory.OperatorID = Int32.Parse(sqlDr["OperatorID"].ToString());//Convert.ToInt32(sqlDr["OperatorID"].ToString());
programPdtCtrlHistory.OperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.OperatorID));
}
programPdtCtrlHistory.ItemName = sqlDr["ItemName"].ToString();
lstProgramPdtCtrlHistory.Add(programPdtCtrlHistory);
}
returnProgramPdtCtrlHistory.Code = "00";
returnProgramPdtCtrlHistory.Message = "Lấy dữ liệu thành công.";
returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = lstProgramPdtCtrlHistory;
returnProgramPdtCtrlHistory.Total = lstProgramPdtCtrlHistory.Count;
//}
}
else
{
returnProgramPdtCtrlHistory.Code = "01";
returnProgramPdtCtrlHistory.Message = "Không tồn tại bản ghi nào.";
returnProgramPdtCtrlHistory.Total = 0;
returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null;
}
}
}
}
}
catch (Exception ex)
{
returnProgramPdtCtrlHistory.Code = "99";
returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProgramPdtCtrlHistory.Total = 0;
returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null;
mylog4net.Error("", ex);
}
return(returnProgramPdtCtrlHistory);
}
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);
}
public ReturnUser GetbyID(int ID)
{
List <User> lstUser = null;
User user = null;
ReturnUser returnUser = new ReturnUser();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tUser_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = ID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstUser = new List <User>();
while (sqlDr.Read())
{
user = new User();
user.ID = int.Parse(sqlDr["ID"].ToString());
user.FullName = sqlDr["FullName"].ToString();
user.UserName = sqlDr["UserName"].ToString();
user.PassWord = sqlDr["PassWord"].ToString();
user.MobileNumber = sqlDr["MobileNumber"].ToString();
user.FactoryID = sqlDr["FactoryID"].ToString();
user.isActive = int.Parse(sqlDr["isActive"].ToString());
//user.RoleID = int.Parse(sqlDr["RoleID"].ToString());
lstUser.Add(user);
}
returnUser.Code = "00";
returnUser.Message = "Lấy dữ liệu thành công.";
returnUser.lstUser = lstUser;
}
else
{
returnUser.Code = "01";
returnUser.Message = "Không tồn tại bản ghi nào.";
returnUser.Total = 0;
returnUser.lstUser = null;
}
}
}
}
}
catch (Exception ex)
{
returnUser.Code = "99";
returnUser.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUser.Total = 0;
returnUser.lstUser = null;
mylog4net.Error("", ex);
}
return(returnUser);
}
public ReturnUser CheckPermission_ByUserNameAndPassword(string userName, string password, string permission)
{
List <User> lstUser = null;
User user = null;
ReturnUser returnUser = new ReturnUser();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tUser_CheckPermission";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar)).Value = userName;
cmd.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar)).Value = password;
cmd.Parameters.Add(new SqlParameter("@Permission", SqlDbType.NVarChar)).Value = permission;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstUser = new List <User>();
while (sqlDr.Read())
{
user = new User();
user.ID = int.Parse(sqlDr["ID"].ToString());
user.FullName = sqlDr["FullName"].ToString();
user.UserName = sqlDr["UserName"].ToString();
user.PassWord = sqlDr["PassWord"].ToString();
user.MobileNumber = sqlDr["MobileNumber"].ToString();
user.FactoryID = sqlDr["FactoryID"].ToString();
user.isActive = int.Parse(sqlDr["isActive"].ToString());
//user.RoleID = int.Parse(sqlDr["RoleID"].ToString());
lstUser.Add(user);
}
returnUser.Code = "00";
returnUser.Message = "Lấy dữ liệu thành công.";
returnUser.lstUser = lstUser;
}
else
{
returnUser.Code = "01";
returnUser.Message = "Không tồn tại bản ghi nào.";
returnUser.Total = 0;
returnUser.lstUser = null;
}
}
}
}
}
catch (Exception ex)
{
returnUser.Code = "99";
returnUser.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUser.Total = 0;
returnUser.lstUser = null;
mylog4net.Error("", ex);
}
return(returnUser);
}
public ReturnMachineMtnContentDetail SelectByMachineMtnID(int MachineMtnID)
{
List <MachineMtnContentDetail> lstMachineMtnContentDetail = null;
MachineMtnContentDetail machineMtnContentDetail = null;
ReturnMachineMtnContentDetail returnMachineMtnContentDetail = new ReturnMachineMtnContentDetail();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtnDetail_SelectByMachineMtnID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineMtnID", SqlDbType.Int)).Value = MachineMtnID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstMachineMtnContentDetail = new List <MachineMtnContentDetail>();
while (sqlDr.Read())
{
machineMtnContentDetail = new MachineMtnContentDetail();
machineMtnContentDetail.ID = Convert.ToInt16(sqlDr["ID"].ToString());
machineMtnContentDetail.MachineMtnID = Convert.ToInt16(sqlDr["MachineMtnID"].ToString());
machineMtnContentDetail.MachineMtnContentID = Convert.ToInt16(sqlDr["MachineMtnContentID"].ToString());
machineMtnContentDetail.Result = sqlDr["Result"].ToString();
machineMtnContentDetail.ResultContents = sqlDr["ResultContents"].ToString();
machineMtnContentDetail.MachinePart = sqlDr["MachinePartID"].ToString();
machineMtnContentDetail.ContentMtn = sqlDr["ContentMtn"].ToString();
machineMtnContentDetail.ToolMtn = sqlDr["ToolMtn"].ToString();
machineMtnContentDetail.MethodMtn = sqlDr["MethodMtn"].ToString();
machineMtnContentDetail.Standard = sqlDr["Standard"].ToString();
machineMtnContentDetail.MachinePartName = sqlDr["Name"].ToString();
machineMtnContentDetail.Min = sqlDr["Min"].ToString();
machineMtnContentDetail.Max = sqlDr["Max"].ToString();
machineMtnContentDetail.ActualValue = sqlDr["ActualValue"].ToString();
lstMachineMtnContentDetail.Add(machineMtnContentDetail);
}
returnMachineMtnContentDetail.Code = "00";
returnMachineMtnContentDetail.Message = "Lấy dữ liệu thành công.";
returnMachineMtnContentDetail.lstMachineMtnContentDetail = lstMachineMtnContentDetail;
}
else
{
returnMachineMtnContentDetail.Code = "01";
returnMachineMtnContentDetail.Message = "Không tồn tại bản ghi nào.";
returnMachineMtnContentDetail.Total = 0;
returnMachineMtnContentDetail.lstMachineMtnContentDetail = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachineMtnContentDetail.Code = "99";
returnMachineMtnContentDetail.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineMtnContentDetail.Total = 0;
returnMachineMtnContentDetail.lstMachineMtnContentDetail = null;
mylog4net.Error("", ex);
}
return(returnMachineMtnContentDetail);
}
public ReturnMachineMtn SelectByPage(string where, int pageNumber, int pageSize)
{
List <MachineMtn> lstMachineMtn = null;
MachineMtn machineMtn = null;
ReturnMachineMtn returnMachineMtn = new ReturnMachineMtn();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtn_SearchBypage";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@where", SqlDbType.NVarChar)).Value = where;
//paging
cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = pageNumber;
cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize;
cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstMachineMtn = new List <MachineMtn>();
while (sqlDr.Read())
{
machineMtn = new MachineMtn();
machineMtn.ID = Convert.ToInt16(sqlDr["ID"].ToString());
machineMtn.MachineID = sqlDr["MachineID"].ToString();
machineMtn.MachineName = sqlDr["MachineName"].ToString();
machineMtn.OperatorID = sqlDr["OperatorID"].ToString();
machineMtn.OperatorName = sqlDr["UserName"].ToString(); // UserName in Sql = operatorName in C#
if (!String.IsNullOrEmpty(sqlDr["Shift"].ToString()))
{
machineMtn.Shift = Convert.ToInt16(sqlDr["Shift"].ToString());
}
machineMtn.MaintenanceDate = Convert.ToDateTime(sqlDr["MaintenanceDate"].ToString());
machineMtn.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString());
machineMtn.Result = sqlDr["Result"].ToString();
machineMtn.ResultContents = sqlDr["ResultContents"].ToString();
if (!String.IsNullOrEmpty(sqlDr["Month"].ToString()))
{
machineMtn.Month = Convert.ToInt16(sqlDr["Month"].ToString());
}
if (!String.IsNullOrEmpty(sqlDr["Year"].ToString()))
{
machineMtn.Year = Convert.ToInt16(sqlDr["Year"].ToString());
}
if (!String.IsNullOrEmpty(sqlDr["Week"].ToString()))
{
machineMtn.Week = Convert.ToInt16(sqlDr["Week"].ToString());
}
machineMtn.CheckerID = Convert.ToInt16(sqlDr["CheckerID"].ToString());
//get Checker name.
int _checkerID = 0;
machineMtn.CheckerName = "";
if (Int32.TryParse(sqlDr["CheckerID"].ToString(), out _checkerID))
{
ReturnUser returnUser = (new UserDB()).GetbyID(_checkerID);
if (returnUser.Code == "00")
{
machineMtn.CheckerName = returnUser.lstUser[0].UserName;
}
}
machineMtn.CheckerResult = sqlDr["CheckerResult"].ToString();
lstMachineMtn.Add(machineMtn);
}
returnMachineMtn.Code = "00";
returnMachineMtn.Message = "Lấy dữ liệu thành công.";
returnMachineMtn.lstMachineMtn = lstMachineMtn;
returnMachineMtn.UserID = MyShareInfo.ID;
returnMachineMtn.UserName = MyShareInfo.UserName;
}
else
{
returnMachineMtn.Code = "01";
returnMachineMtn.Message = "Không tồn tại bản ghi nào.";
returnMachineMtn.Total = 0;
returnMachineMtn.lstMachineMtn = null;
returnMachineMtn.UserID = MyShareInfo.ID;
returnMachineMtn.UserName = MyShareInfo.UserName;
}
}
//paging.
if (returnMachineMtn.Code == "00")
{
returnMachineMtn.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value);
}
}
}
}
catch (Exception ex)
{
returnMachineMtn.Code = "99";
returnMachineMtn.Message = "Lỗi xử lý dữ liệu/Error: " + ex.ToString();
returnMachineMtn.Total = 0;
returnMachineMtn.lstMachineMtn = null;
mylog4net.Error("public ReturnMachineMtn SelectByCondition(string where, int pageSize) ", ex);
}
return(returnMachineMtn);
}
public ReturnMenu SelectTempSorted()
{
List <Menu> lstMenu = null;
Menu menu = null;
ReturnMenu returnMenu = new ReturnMenu();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMenu_SelectTempSorted";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstMenu = new List <Menu>();
while (sqlDr.Read())
{
menu = new Menu();
menu.ID = int.Parse(sqlDr["ID"].ToString());
menu.MenuName = sqlDr["MenuName"].ToString();
menu.DisplayName = sqlDr["DisplayName"].ToString();
menu.ParentMenuID = int.Parse(sqlDr["ParentMenuID"].ToString());
menu.isActive = int.Parse(sqlDr["isActive"].ToString());
menu.UrlLink = sqlDr["UrlLink"].ToString();
if (menu.isActive == 1)
{
lstMenu.Add(menu);
}
}
returnMenu.Code = "00";
returnMenu.Message = "Lấy dữ liệu thành công.";
returnMenu.lstMenu = lstMenu;
}
else
{
returnMenu.Code = "01";
returnMenu.Message = "Không tồn tại bản ghi nào.";
returnMenu.Total = 0;
returnMenu.lstMenu = null;
}
}
}
}
}
catch (Exception ex)
{
returnMenu.Code = "99";
returnMenu.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMenu.Total = 0;
returnMenu.lstMenu = null;
mylog4net.Error("", ex);
}
return(returnMenu);
}
public ReturnFPBCheckingItem GetFPBCheckingItemName(string MachineID)
{
List <FPBCheckingItem> lstFPBCheckingItem = null;
FPBCheckingItem FPBCheckingItem = null;
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_FPBCheckingItem_GetFPBCheckingItemName";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstFPBCheckingItem = new List <FPBCheckingItem>();
while (sqlDr.Read())
{
FPBCheckingItem = new FPBCheckingItem();
FPBCheckingItem.IDFPBCheckingItem = int.Parse(sqlDr["IDFPBCheckingItem"].ToString());
FPBCheckingItem.MachineID = sqlDr["MachineID"].ToString();
FPBCheckingItem.CheckingItemName = sqlDr["CheckingItemName"].ToString();
FPBCheckingItem.FrequencyID = int.Parse(sqlDr["FrequencyID"].ToString());
lstFPBCheckingItem.Add(FPBCheckingItem);
}
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Lấy dữ liệu thành công.";
returnFPBCheckingItem.LstFPBCheckingItem = lstFPBCheckingItem;
returnFPBCheckingItem.UserID = MyShareInfo.ID;
returnFPBCheckingItem.UserName = MyShareInfo.UserName;
}
else
{
returnFPBCheckingItem.Code = "01";
returnFPBCheckingItem.Message = "Không tồn tại bản ghi nào.";
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
returnFPBCheckingItem.UserID = MyShareInfo.ID;
returnFPBCheckingItem.UserName = MyShareInfo.UserName;
}
}
}
}
}
catch (Exception ex)
{
returnFPBCheckingItem.Code = "99";
returnFPBCheckingItem.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
mylog4net.Error("", ex);
}
return(returnFPBCheckingItem);
}
public ReturnMenuRole GetMenusByUserID(User user)
{
List <MenuRole> lstMenu = null;
MenuRole menuRole = null;
ReturnMenuRole returnMenu = new ReturnMenuRole();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "tMenu_listMenu_ByOrder_WithUserID";
cmd.Parameters.Add(new SqlParameter("@isReturnAllMenu", SqlDbType.Int)).Value = 0; // get menu item corresponding to UserID.
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = user.ID;
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstMenu = new List <MenuRole>();
while (sqlDr.Read())
{
menuRole = new MenuRole();
menuRole.ID = int.Parse(sqlDr["ID"].ToString());
menuRole.MenuName = sqlDr["MenuName"].ToString();
menuRole.DisplayName = sqlDr["DisplayName"].ToString();
menuRole.ParentMenuID = int.Parse(sqlDr["ParentMenuID"].ToString());
menuRole.isActive = int.Parse(sqlDr["isActive"].ToString());
menuRole.UrlLink = sqlDr["UrlLink"].ToString();
menuRole.Permission = sqlDr["Permission"].ToString();
if (menuRole.isActive == 1)
{
lstMenu.Add(menuRole);
}
}
returnMenu.Code = "00";
returnMenu.Message = "Lấy dữ liệu thành công.";
returnMenu.lstMenuRole = lstMenu;
}
else
{
returnMenu.Code = "01";
returnMenu.Message = "Không tồn tại bản ghi nào.";
returnMenu.Total = 0;
returnMenu.lstMenuRole = null;
}
}
}
}
}
catch (Exception ex)
{
returnMenu.Code = "99";
returnMenu.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMenu.Total = 0;
returnMenu.lstMenuRole = null;
mylog4net.Error("public ReturnMenuRole GetMenusByUserID(User user) ", ex);
}
return(returnMenu);
}
public ReturnToolList ListAll()
{
List <ToolList> lstToolList = null;
ToolList toolList = null;
ReturnToolList returnToolList = new ReturnToolList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tToolList_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstToolList = new List <ToolList>();
while (sqlDr.Read())
{
toolList = new ToolList();
toolList.ToolID = sqlDr["ToolID"].ToString();
toolList.UserID = sqlDr["UserID"].ToString();
if (!String.IsNullOrEmpty(toolList.UserID))
{
toolList.UserName = (new UserDB()).getUserNameByID(Convert.ToInt16(toolList.UserID));
}
else
{
toolList.UserName = "";
}
toolList.ToolType = sqlDr["ToolType"].ToString();
if (!String.IsNullOrEmpty(toolList.ToolType))
{
toolList.ToolTypeName = (new ToolTypeListDB()).GetToolTypeNamebyID(toolList.ToolType);
}
else
{
toolList.ToolTypeName = "";
}
toolList.ItemCode = sqlDr["ItemCode"].ToString();
toolList.Maker = sqlDr["Maker"].ToString();
toolList.Specification = sqlDr["Specification"].ToString();
toolList.ReceiveDate = DateTime.Parse(sqlDr["ReceiveDate"].ToString());
toolList.StartUsing = DateTime.Parse(sqlDr["StartUsing"].ToString());
//toolList.ReceiveDate = sqlDr["ReceiveDate"].ToString();
//toolList.StartUsing = sqlDr["StartUsing"].ToString();
toolList.LifeTime = sqlDr["LifeTime"].ToString();
toolList.ExpireDate = DateTime.Parse(sqlDr["ExpireDate"].ToString());
//toolList.ExpireDate = sqlDr["ExpireDate"].ToString();
toolList.LineID = sqlDr["LineID"].ToString();
toolList.Status = sqlDr["Status"].ToString();
toolList.Remark = sqlDr["Remark"].ToString();
toolList.ImageUrl = sqlDr["ImageUrl"].ToString();
toolList.CreatedDate = DateTime.Parse(sqlDr["CreatedDate"].ToString());
toolList.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstToolList.Add(toolList);
}
returnToolList.Code = "00";
returnToolList.Message = "Lấy dữ liệu thành công.";
returnToolList.lstToolList = lstToolList;
returnToolList.UserID = MyShareInfo.ID;
returnToolList.UserName = MyShareInfo.UserName;
}
else
{
returnToolList.Code = "01";
returnToolList.Message = "Không tồn tại bản ghi nào.";
returnToolList.Total = 0;
returnToolList.lstToolList = null;
returnToolList.UserID = MyShareInfo.ID;
returnToolList.UserName = MyShareInfo.UserName;
}
}
}
}
}
catch (Exception ex)
{
returnToolList.Code = "99";
returnToolList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnToolList.Total = 0;
returnToolList.lstToolList = null;
}
return(returnToolList);
}
public ReturnFPB ListAll()
{
List <FPB> lstFPB = null;
FPB FPB = null;
ReturnFPB returnFPB = new ReturnFPB();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_FPB_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstFPB = new List <FPB>();
while (sqlDr.Read())
{
FPB = new FPB();
FPB.ID = int.Parse(sqlDr["ID"].ToString());
FPB.IDFPBCheckingItem = int.Parse(sqlDr["IDFPBCheckingItem"].ToString());
FPB.FPBDate = DateTime.Parse(sqlDr["FPBDate"].ToString());
FPB.IndicationNo = sqlDr["IndicationNo"].ToString();
FPB.UserID = sqlDr["UserID"].ToString();
FPB.SeqNo = sqlDr["SeqNo"].ToString();
FPB.BlockID = sqlDr["BlockID"].ToString();
FPB.Result = sqlDr["Result"].ToString();
FPB.ResultContent = sqlDr["ResultContent"].ToString();
lstFPB.Add(FPB);
}
returnFPB.Code = "00";
returnFPB.Message = "Lấy dữ liệu thành công.";
returnFPB.LstFPB = lstFPB;
returnFPB.UserID = MyShareInfo.ID;
returnFPB.UserName = MyShareInfo.UserName;
}
else
{
returnFPB.Code = "01";
returnFPB.Message = "Không tồn tại bản ghi nào.";
returnFPB.Total = 0;
returnFPB.LstFPB = null;
returnFPB.UserID = MyShareInfo.ID;
returnFPB.UserName = MyShareInfo.UserName;
}
}
}
}
}
catch (Exception ex)
{
returnFPB.Code = "99";
returnFPB.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPB.Total = 0;
returnFPB.LstFPB = null;
mylog4net.Error("", ex);
}
return(returnFPB);
}
//public ReturnProgramPdtCtrlHistory SearchProgramPdtCtrlHistory(ReturnProgramPdtCtrlHistory searchProgramPdtCtrlHistory, int pageSize)
//{
// List<ProgramPdtCtrlHistory> lstProgramPdtCtrlHistory = null;
// ProgramPdtCtrlHistory programPdtCtrlHistory = null;
// ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory();
// try
// {
// using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
// {
// using (SqlCommand cmd = new SqlCommand("", sqlConnection))
// {
// cmd.CommandText = "sp_tProgramPdtCtrlHistory_Search";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = searchProgramPdtCtrlHistory.aProgramPdtCtrlHistory.ProgramName;
// cmd.Parameters.Add(new SqlParameter("@Parameter", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.aProgramPdtCtrlHistory.Parameter;
// cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.aProgramPdtCtrlHistory.ControlItem;
// cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = searchProgramPdtCtrlHistory.PageNumber;
// cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize;
// cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output;
// using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
// {
// if (sqlDr.HasRows)
// {
// lstProgramPdtCtrlHistory = new List<ProgramPdtCtrlHistory>();
// while (sqlDr.Read())
// {
// programPdtCtrlHistory = new ProgramPdtCtrlHistory();
// programPdtCtrlHistory.ProgramName = sqlDr["ProgramName"].ToString();
// programPdtCtrlHistory.Parameter = sqlDr["Parameter"].ToString();
// programPdtCtrlHistory.ControlItem = sqlDr["ControlItem"].ToString();
// programPdtCtrlHistory.SpecDisplay = sqlDr["SpecDisplay"].ToString();
// programPdtCtrlHistory.Unit = sqlDr["Unit"].ToString();
// programPdtCtrlHistory.UpperLimit = sqlDr["UpperLimit"].ToString();
// programPdtCtrlHistory.LowerLimit = sqlDr["LowerLimit"].ToString();
// programPdtCtrlHistory.ColumnName = sqlDr["ColumnName"].ToString();
// programPdtCtrlHistory.OperatorID = Convert.ToInt32(sqlDr["OperatorID"].ToString());
// programPdtCtrlHistory.HistoryOperatorID = Convert.ToInt32(sqlDr["HistoryOperatorID"].ToString());
// programPdtCtrlHistory.ItemName = sqlDr["ItemName"].ToString();
// lstProgramPdtCtrlHistory.Add(programPdtCtrlHistory);
// }
// returnProgramPdtCtrlHistory.Code = "00";
// returnProgramPdtCtrlHistory.Message = "Lấy dữ liệu thành công.";
// returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = lstProgramPdtCtrlHistory;
// }
// else
// {
// returnProgramPdtCtrlHistory.Code = "01";
// returnProgramPdtCtrlHistory.Message = "Không tồn tại bản ghi nào.";
// returnProgramPdtCtrlHistory.Total = 0;
// returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null;
// }
// }
// //get return Totalpage value.
// if (returnProgramPdtCtrlHistory.Code == "00")
// returnProgramPdtCtrlHistory.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value);
// }
// }
// }
// catch (Exception ex)
// {
// returnProgramPdtCtrlHistory.Code = "99";
// returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
// returnProgramPdtCtrlHistory.Total = 0;
// returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null;
// mylog4net.Error("", ex);
// }
// return returnProgramPdtCtrlHistory;
//}
public ReturnProgramPdtCtrlHistory SearchProgramPdtCtrlHistory(ProgramPdtCtrlHistory searchProgramPdtCtrlHistory, int pageNumber, int pageSize)
{
List <ProgramPdtCtrlHistory> lstProgramPdtCtrlHistory = null;
ProgramPdtCtrlHistory programPdtCtrlHistory = null;
ReturnProgramPdtCtrlHistory returnProgramPdtCtrlHistory = new ReturnProgramPdtCtrlHistory();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProgramPdtCtrlHistory_Search";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = searchProgramPdtCtrlHistory.ProgramName;
cmd.Parameters.Add(new SqlParameter("@Part", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.Part;
cmd.Parameters.Add(new SqlParameter("@ControlItem", SqlDbType.NVarChar)).Value = searchProgramPdtCtrlHistory.ControlItem;
cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = pageNumber;
cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize;
cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstProgramPdtCtrlHistory = new List <ProgramPdtCtrlHistory>();
while (sqlDr.Read())
{
programPdtCtrlHistory = new ProgramPdtCtrlHistory();
programPdtCtrlHistory.ProgramName = sqlDr["ProgramName"].ToString();
programPdtCtrlHistory.Parameter = sqlDr["Parameter"].ToString();
programPdtCtrlHistory.ControlItem = sqlDr["ControlItem"].ToString();
programPdtCtrlHistory.SpecDisplay = sqlDr["SpecDisplay"].ToString();
programPdtCtrlHistory.Unit = sqlDr["Unit"].ToString();
programPdtCtrlHistory.UpperLimit = sqlDr["UpperLimit"].ToString();
programPdtCtrlHistory.LowerLimit = sqlDr["LowerLimit"].ToString();
programPdtCtrlHistory.ColumnName = sqlDr["ColumnName"].ToString();
if (!String.IsNullOrEmpty(sqlDr["HistoryOperatorID"].ToString()))
{
programPdtCtrlHistory.HistoryOperatorID = Int32.Parse(sqlDr["HistoryOperatorID"].ToString());//Convert.ToInt32(sqlDr["HistoryOperatorID"].ToString());
programPdtCtrlHistory.HistoryOperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.HistoryOperatorID));
}
if (!String.IsNullOrEmpty(sqlDr["OperatorID"].ToString()))
{
programPdtCtrlHistory.OperatorID = Int32.Parse(sqlDr["OperatorID"].ToString());//Convert.ToInt32(sqlDr["OperatorID"].ToString());
programPdtCtrlHistory.OperatorName = (new UserDB()).getUserNameByID(Convert.ToInt32(programPdtCtrlHistory.OperatorID));
}
programPdtCtrlHistory.CreatedDate = DateTime.Parse(sqlDr["CreatedDate"].ToString());
programPdtCtrlHistory.HistoryDate = DateTime.Parse(sqlDr["HistoryDate"].ToString());
programPdtCtrlHistory.StatusCRUD = sqlDr["StatusCRUD"].ToString();
lstProgramPdtCtrlHistory.Add(programPdtCtrlHistory);
}
returnProgramPdtCtrlHistory.Code = "00";
returnProgramPdtCtrlHistory.Message = "Lấy dữ liệu thành công.";
returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = lstProgramPdtCtrlHistory;
}
else
{
returnProgramPdtCtrlHistory.Code = "01";
returnProgramPdtCtrlHistory.Message = "Không tồn tại bản ghi nào.";
returnProgramPdtCtrlHistory.Total = 0;
returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null;
}
}
//get return Totalpage value.
if (returnProgramPdtCtrlHistory.Code == "00")
{
returnProgramPdtCtrlHistory.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value);
}
}
}
}
catch (Exception ex)
{
returnProgramPdtCtrlHistory.Code = "99";
returnProgramPdtCtrlHistory.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProgramPdtCtrlHistory.Total = 0;
returnProgramPdtCtrlHistory.lstProgramPdtCtrlHistory = null;
mylog4net.Error("", ex);
}
return(returnProgramPdtCtrlHistory);
}
public ReturnToolList SearchTools(ReturnToolList searchToolLists, int pageSize)
{
List <ToolList> lstToolList = null;
ToolList toolList = null;
ReturnToolList returnToolList = new ReturnToolList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tToolList_SearchTools";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ToolID", SqlDbType.VarChar)).Value = string.Format("%{0}%", searchToolLists.aToolList.ToolID);
cmd.Parameters.Add(new SqlParameter("@ItemCode", SqlDbType.VarChar)).Value = string.Format("%{0}%", searchToolLists.aToolList.ItemCode);
cmd.Parameters.Add(new SqlParameter("@Maker", SqlDbType.VarChar)).Value = string.Format("%{0}%", searchToolLists.aToolList.Maker);
if (searchToolLists.aToolList.ReceiveDate == DateTime.MinValue)
{
cmd.Parameters.Add(new SqlParameter("@ReceiveDate", SqlDbType.DateTime)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@ReceiveDate", SqlDbType.DateTime)).Value = searchToolLists.aToolList.ReceiveDate;
}
if (searchToolLists.aToolList.StartUsing == DateTime.MinValue)
{
cmd.Parameters.Add(new SqlParameter("@StartUsing", SqlDbType.DateTime)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@StartUsing", SqlDbType.DateTime)).Value = searchToolLists.aToolList.StartUsing;
}
if (searchToolLists.aToolList.ExpireDate == DateTime.MinValue)
{
cmd.Parameters.Add(new SqlParameter("@ExpireDate", SqlDbType.DateTime)).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add(new SqlParameter("@ExpireDate", SqlDbType.DateTime)).Value = searchToolLists.aToolList.ExpireDate;
}
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = string.Format("%{0}%", searchToolLists.aToolList.LineID);
cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = searchToolLists.PageNumber;
cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize;
cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstToolList = new List <ToolList>();
while (sqlDr.Read())
{
toolList = new ToolList();
toolList.ToolID = sqlDr["ToolID"].ToString();
toolList.UserID = sqlDr["UserID"].ToString();
toolList.UserName = sqlDr["UserName"].ToString();
toolList.ToolType = sqlDr["ToolType"].ToString();
if (!String.IsNullOrEmpty(toolList.ToolType))
{
toolList.ToolTypeName = (new ToolTypeListDB()).GetToolTypeNamebyID(toolList.ToolType);
}
else
{
toolList.ToolTypeName = "";
}
toolList.ItemCode = sqlDr["ItemCode"].ToString();
toolList.Maker = sqlDr["Maker"].ToString();
toolList.Specification = sqlDr["Specification"].ToString();
toolList.ReceiveDate = DateTime.Parse(sqlDr["ReceiveDate"].ToString());
toolList.StartUsing = DateTime.Parse(sqlDr["StartUsing"].ToString());
toolList.LifeTime = sqlDr["LifeTime"].ToString();
toolList.ExpireDate = DateTime.Parse(sqlDr["ExpireDate"].ToString());
toolList.LineID = sqlDr["LineID"].ToString();
toolList.Status = sqlDr["Status"].ToString();
toolList.Remark = sqlDr["Remark"].ToString();
toolList.ImageUrl = sqlDr["ImageUrl"].ToString();
toolList.CreatedDate = DateTime.Parse(sqlDr["CreatedDate"].ToString());
toolList.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstToolList.Add(toolList);
}
returnToolList.Code = "00";
returnToolList.Message = "Lấy dữ liệu thành công.";
returnToolList.lstToolList = lstToolList;
returnToolList.UserID = MyShareInfo.ID;
returnToolList.UserName = MyShareInfo.UserName;
returnToolList.UserName = MyShareInfo.UserName;
}
else
{
returnToolList.Code = "01";
returnToolList.Message = "Không tồn tại bản ghi nào.";
returnToolList.Total = 0;
returnToolList.lstToolList = null;
returnToolList.UserName = MyShareInfo.UserName;
returnToolList.UserName = MyShareInfo.UserName;
}
}
//get return Totalpage value.
if (returnToolList.Code == "00")
{
returnToolList.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value);
}
}
}
}
catch (Exception ex)
{
returnToolList.Code = "99";
returnToolList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnToolList.Total = 0;
returnToolList.lstToolList = null;
}
return(returnToolList);
}