public ReturnLine DeleteByID(string _ID)
{
ReturnLine ReturnLine = new ReturnLine();
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_tLine_DeleteByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = _ID.Trim();
cmd.ExecuteNonQuery();
ReturnLine.Code = "00";
ReturnLine.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
ReturnLine.Code = "99";
ReturnLine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
ReturnLine.Total = 0;
ReturnLine.LstLine = null;
mylog4net.Error("", ex);
}
return(ReturnLine);
}
public ReturnUserWithRoles SaveUserWith_aRole(int userID, Role role)
{
ReturnUserWithRoles ReturnUserWithRoles = new ReturnUserWithRoles();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tUserRole_SaveUserRoleByChecked";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = userID;
//cmd.Parameters.Add(new SqlParameter("@RoleID", SqlDbType.NVarChar)).Value = user.FullName;
//cmd.Parameters.Add(new SqlParameter("@Checked", SqlDbType.Bit)).Value = user.UserName;
cmd.Parameters.AddWithValue("@UserID", userID);
cmd.Parameters.AddWithValue("@RoleID", role.ID);
cmd.Parameters.AddWithValue("@Checked", role.Checked);
cmd.ExecuteNonQuery();
ReturnUserWithRoles.Code = "00";
ReturnUserWithRoles.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
ReturnUserWithRoles.Code = "99";
ReturnUserWithRoles.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
ReturnUserWithRoles.Total = 0;
ReturnUserWithRoles.lstUserWithRoles = null;
mylog4net.Error("public ReturnUserWithRoles SaveUserWith_aRole(int userID, Role role) ", ex);
}
return(ReturnUserWithRoles);
}
public ReturnToolTypeList Insert(ToolTypeList toolTypeList)
{
ReturnToolTypeList returnToolTypeList = new ReturnToolTypeList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tToolTypeList_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ToolTypeID", SqlDbType.VarChar)).Value = toolTypeList.ToolTypeID;
cmd.Parameters.Add(new SqlParameter("@ToolTypeName", SqlDbType.NVarChar)).Value = toolTypeList.ToolTypeName;
cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)).Value = 1;
cmd.ExecuteNonQuery();
returnToolTypeList.Code = "00";
returnToolTypeList.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnToolTypeList.Code = "99";
returnToolTypeList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnToolTypeList.Total = 0;
returnToolTypeList.LstToolTypeList = null;
mylog4net.Error("", ex);
}
return(returnToolTypeList);
}
public ReturnMachinePart Insert(MachinePart machinePart)
{
ReturnMachinePart returnMachinePart = new ReturnMachinePart();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachinePart_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machinePart.ID;
cmd.Parameters.Add(new SqlParameter("@Name", SqlDbType.NVarChar)).Value = machinePart.Name;
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.NVarChar)).Value = machinePart.Description;
cmd.Parameters.Add(new SqlParameter("@MachineType", SqlDbType.Int)).Value = machinePart.MachineType;
cmd.ExecuteNonQuery();
returnMachinePart.Code = "00";
returnMachinePart.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachinePart.Code = "99";
returnMachinePart.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachinePart.Total = 0;
returnMachinePart.lstMachinePart = null;
mylog4net.Error("", ex);
}
return(returnMachinePart);
}
public ReturnProgramPdtCtrl DeleteByKey(ProgramPdtCtrl p)
{
ReturnProgramPdtCtrl returnProgramPdtCtrl = new ReturnProgramPdtCtrl();
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_tProgramPdtCtrl_DeleteByKey";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.ProgramName;
cmd.Parameters.Add(new SqlParameter("@Part", SqlDbType.VarChar)).Value = p.Part;
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();
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;
}
return(returnProgramPdtCtrl);
}
public ReturnUser UserAll()
{
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_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)
{
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 ReturnLine Insert(Line line)
{
ReturnLine ReturnLine = new ReturnLine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tLine_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = line.LineID;
cmd.Parameters.Add(new SqlParameter("@LineName", SqlDbType.VarChar)).Value = line.LineName;
cmd.Parameters.Add(new SqlParameter("@FactoryID", SqlDbType.VarChar)).Value = line.FactoryID;
//int RETURN_CODE = Convert.ToInt32(cmd.Parameters["@RETURN_CODE"].Value);
cmd.ExecuteNonQuery();
ReturnLine.Code = "00";
ReturnLine.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
ReturnLine.Code = "99";
ReturnLine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
ReturnLine.Total = 0;
ReturnLine.LstLine = null;
mylog4net.Error("", ex);
}
return(ReturnLine);
}
public ReturnMachineTypeFrequency Insert(MachineTypeFrequency machineTypeFrequency)
{
ReturnMachineTypeFrequency returnMachineTypeFrequency = new ReturnMachineTypeFrequency();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineTypeFrequency_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineTypeFrequency.ID;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = machineTypeFrequency.MachineTypeID;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.SmallInt)).Value = machineTypeFrequency.FrequencyID;
cmd.ExecuteNonQuery();
returnMachineTypeFrequency.Code = "00";
returnMachineTypeFrequency.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachineTypeFrequency.Code = "99";
returnMachineTypeFrequency.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineTypeFrequency.Total = 0;
returnMachineTypeFrequency.lstMachineTypeFrequency = null;
mylog4net.Error("", ex);
}
return(returnMachineTypeFrequency);
}
public ReturnMenuRole SaveRoleWithPermissionMenus(MenuRole menuRole)
{
ReturnMenuRole returnMenuRole = new ReturnMenuRole();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tRoleMenu_SaveRoleWithPermissionMenus";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RoleID", menuRole.RoleID);
cmd.Parameters.AddWithValue("@MenuID", menuRole.ID);
cmd.Parameters.AddWithValue("@Permission", menuRole.Permission != null ? menuRole.Permission : "");
cmd.ExecuteNonQuery();
returnMenuRole.Code = "00";
returnMenuRole.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMenuRole.Code = "99";
returnMenuRole.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMenuRole.Total = 0;
returnMenuRole.lstMenuRole = null;
mylog4net.Error("public ReturnUserWithRoles SaveUserWith_aRole(int userID, Role role) ", ex);
}
return(returnMenuRole);
}
public ReturnLine ListAll()
{
List <Line> lstLine = null;
Line line = null;
ReturnLine returnLine = new ReturnLine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tLine_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)
{
lstLine = new List <Line>();
while (sqlDr.Read())
{
line = new Line();
line.LineID = sqlDr["LineID"].ToString();
line.LineName = sqlDr["LineName"].ToString();
line.FactoryID = sqlDr["FactoryID"].ToString();
line.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstLine.Add(line);
}
returnLine.Code = "00";
returnLine.Message = "Lấy dữ liệu thành công.";
returnLine.LstLine = lstLine;
returnLine.UserID = MyShareInfo.ID;
returnLine.UserName = MyShareInfo.UserName;
}
else
{
returnLine.Code = "01";
returnLine.Message = "Không tồn tại bản ghi nào.";
returnLine.Total = 0;
returnLine.LstLine = null;
}
}
}
}
}
catch (Exception ex)
{
returnLine.Code = "99";
returnLine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnLine.Total = 0;
returnLine.LstLine = null;
mylog4net.Error("", ex);
}
return(returnLine);
}
public ReturnProgramName ListAll()
{
List <ProgramName> lstProgramName = null;
ProgramName programname = null;
ReturnProgramName returnProgramName = new ReturnProgramName();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProgramName_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstProgramName = new List <ProgramName>();
while (sqlDr.Read())
{
programname = new ProgramName();
programname.programName = sqlDr["ProgramName"].ToString();
programname.ProgramType = sqlDr["ProgramType"].ToString();
programname.FactoryID = sqlDr["FactoryID"].ToString();
programname.OperatorID = Int32.Parse(sqlDr["OperatorID"].ToString());
programname.OperatorName = sqlDr["UserName"].ToString();
programname.CreatedDate = DateTime.Parse(sqlDr["CreatedDate"].ToString());
lstProgramName.Add(programname);
}
returnProgramName.Code = "00";
returnProgramName.Message = "Lấy dữ liệu thành công.";
returnProgramName.lstProgramName = lstProgramName;
returnProgramName.userID = MyShareInfo.ID;
returnProgramName.UserName = MyShareInfo.UserName;
}
else
{
returnProgramName.Code = "01";
returnProgramName.Message = "Không tồn tại bản ghi nào.";
returnProgramName.Total = 0;
returnProgramName.userID = MyShareInfo.ID;
returnProgramName.UserName = MyShareInfo.UserName;
returnProgramName.lstProgramName = null;
}
}
}
}
}
catch (Exception ex)
{
returnProgramName.Code = "99";
returnProgramName.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProgramName.Total = 0;
returnProgramName.lstProgramName = null;
mylog4net.Error("", ex);
}
return(returnProgramName);
}
public ReturnProgramName Insert(ProgramName p)
{
ReturnProgramName returnProgramName = new ReturnProgramName();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProgramName_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.VarChar)).Value = p.programName;
cmd.Parameters.Add(new SqlParameter("@ProgramType", SqlDbType.VarChar)).Value = p.ProgramType;
cmd.Parameters.Add(new SqlParameter("@FactoryID", SqlDbType.VarChar)).Value = p.FactoryID;
cmd.Parameters.Add(new SqlParameter("@OperatorID", SqlDbType.Int)).Value = p.OperatorID;
cmd.ExecuteNonQuery();
returnProgramName.Code = "00";
returnProgramName.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnProgramName.Code = "99";
returnProgramName.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnProgramName.Total = 0;
returnProgramName.lstProgramName = null;
mylog4net.Error("", ex);
}
return(returnProgramName);
}
public ReturnUserMenu Insert(UserMenu userMenu)
{
ReturnUserMenu returnUser = new ReturnUserMenu();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tUserMenu_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = userMenu.ID;
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = userMenu.UserID;
cmd.Parameters.Add(new SqlParameter("@MenuID", SqlDbType.Int)).Value = userMenu.MenuID;
cmd.Parameters.Add(new SqlParameter("@Permission", SqlDbType.NVarChar)).Value = userMenu.Pemission;
cmd.ExecuteNonQuery();
returnUser.Code = "00";
returnUser.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnUser.Code = "99";
returnUser.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUser.Total = 0;
returnUser.lstUserMenu = null;
mylog4net.Error("", ex);
}
return(returnUser);
}
public ReturnProductionControl DeleteByID(int _ID)
{
ReturnProductionControl returnProductionControl = new ReturnProductionControl();
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_tProductionControl_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();
returnProductionControl.Code = "00";
returnProductionControl.Message = "Cập nhật dữ liệu thành công.";
}
}
}
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 ReturnMenu Insert(Menu menu)
{
ReturnMenu returnMenu = new ReturnMenu();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMenu_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = menu.ID;
cmd.Parameters.Add(new SqlParameter("@MenuName", SqlDbType.NVarChar)).Value = menu.MenuName;
cmd.Parameters.Add(new SqlParameter("@DisplayName", SqlDbType.NVarChar)).Value = menu.DisplayName;
cmd.Parameters.Add(new SqlParameter("@ParentMenuID", SqlDbType.Int)).Value = menu.ParentMenuID;
cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Int)).Value = menu.isActive;
cmd.Parameters.Add(new SqlParameter("@UrlLink", SqlDbType.VarChar)).Value = menu.UrlLink;
cmd.ExecuteNonQuery();
returnMenu.Code = "00";
returnMenu.Message = "Cập nhật dữ liệu thành công.";
}
}
}
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 ReturnRole Insert(Role role)
{
ReturnRole returnRole = new ReturnRole();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tRole_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = role.ID;
cmd.Parameters.Add(new SqlParameter("@RoleName", SqlDbType.NVarChar)).Value = role.RoleName;
cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.NVarChar)).Value = role.Title;
cmd.ExecuteNonQuery();
returnRole.Code = "00";
returnRole.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnRole.Code = "99";
returnRole.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnRole.Total = 0;
returnRole.lstRole = null;
}
return(returnRole);
}
public ReturnUserMenu DeleteByUserID(int _UserID)
{
ReturnUserMenu returnUserMenu = new ReturnUserMenu();
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_tUserMenu_DeleteByUserID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = _UserID;
cmd.ExecuteNonQuery();
returnUserMenu.Code = "00";
returnUserMenu.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnUserMenu.Code = "99";
returnUserMenu.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUserMenu.Total = 0;
returnUserMenu.lstUserMenu = null;
}
return(returnUserMenu);
}
public ReturnProgramPdtCtrl DeleteByID(int ID, int OperatorID)
{
ReturnProgramPdtCtrl returnProgramPdtCtrl = new ReturnProgramPdtCtrl();
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_tProgramPdtCtrl_DeleteByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = ID;
cmd.Parameters.Add(new SqlParameter("@OperatorID", SqlDbType.Int)).Value = OperatorID;
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;
}
return(returnProgramPdtCtrl);
}
public string getUserNameByID(int UserID)
{
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tUser_getUserNameByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar)).Value = UserID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
while (sqlDr.Read())
{
return(sqlDr[0].ToString());
}
}
}
}
}
}
catch (Exception ex)
{
return("");
}
return("");
}
public ReturnToolList DeleteByID(string _ID)
{
ReturnToolList returnToolList = new ReturnToolList();
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_tToolList_DeleteByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ToolID", 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();
returnToolList.Code = "00";
returnToolList.Message = "Cập nhật dữ liệu thành công.";
}
}
}
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 ReturnFPBCheckingItem DeleteByMachineID(string MachineID, string FrequencyID)
{
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
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_FPBCheckingItem_DeleteByMachineID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = int.Parse(FrequencyID);
cmd.ExecuteNonQuery();
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Cập nhật dữ liệu thành công.";
}
}
}
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 ReturnFPBCheckingItem Insert(FPBCheckingItem FPBCheckingItem)
{
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_FPBCheckingItem_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IDFPBCheckingItem", SqlDbType.Int)).Value = FPBCheckingItem.IDFPBCheckingItem;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = FPBCheckingItem.MachineID;
cmd.Parameters.Add(new SqlParameter("@CheckingItemName", SqlDbType.NVarChar)).Value = FPBCheckingItem.CheckingItemName;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = FPBCheckingItem.FrequencyID;
cmd.Parameters.Add(new SqlParameter("@isActive", SqlDbType.Bit)).Value = 1;
cmd.ExecuteNonQuery();
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Cập nhật dữ liệu thành công.";
}
}
}
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 ReturnMachineType DeleteByID(int _ID)
{
ReturnMachineType returnMachineType = new ReturnMachineType();
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_tMachineType_DeleteByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = _ID;
cmd.ExecuteNonQuery();
returnMachineType.Code = "00";
returnMachineType.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachineType.Code = "99";
returnMachineType.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineType.Total = 0;
returnMachineType.lstMachineType = null;
mylog4net.Error("", ex);
}
return(returnMachineType);
}
public ReturnFPBCheckingItem GetbyMachineID(string MachineID, int FrequencyID)
{
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_SelectByMachineID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = MachineID;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = FrequencyID;
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());
FPBCheckingItem.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstFPBCheckingItem.Add(FPBCheckingItem);
}
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Lấy dữ liệu thành công.";
returnFPBCheckingItem.LstFPBCheckingItem = lstFPBCheckingItem;
}
else
{
returnFPBCheckingItem.Code = "01";
returnFPBCheckingItem.Message = "Không tồn tại bản ghi nào.";
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
}
}
}
}
}
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 ReturnLine GetbyID(string LineID)
{
List <Line> lstLine = null;
Line line = null;
ReturnLine ReturnLine = new ReturnLine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tLine_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@LineID", SqlDbType.VarChar)).Value = LineID.Trim();
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstLine = new List <Line>();
while (sqlDr.Read())
{
line = new Line();
line.LineID = sqlDr["LineID"].ToString();
line.LineName = sqlDr["LineName"].ToString();
line.FactoryID = sqlDr["FactoryID"].ToString();
line.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstLine.Add(line);
}
ReturnLine.Code = "00";
ReturnLine.Message = "Lấy dữ liệu thành công.";
ReturnLine.LstLine = lstLine;
ReturnLine.Total = lstLine.Count;
//}
}
else
{
ReturnLine.Code = "01";
ReturnLine.Message = "Không tồn tại bản ghi nào.";
ReturnLine.Total = 0;
ReturnLine.LstLine = null;
}
}
}
}
}
catch (Exception ex)
{
ReturnLine.Code = "99";
ReturnLine.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
ReturnLine.Total = 0;
ReturnLine.LstLine = null;
mylog4net.Error("", ex);
}
return(ReturnLine);
}
public ReturnMenu GetbyID(int ID)
{
List <Menu> lstMenu = null;
Menu menu = null;
ReturnMenu returnMenu = new ReturnMenu();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMenu_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)
{
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();
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 ReturnMachinePart GetbyID(int ID)
{
List <MachinePart> lstMachinePart = null;
MachinePart machinePart = null;
ReturnMachinePart returnMachinePart = new ReturnMachinePart();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMachinePart_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)
{
lstMachinePart = new List <MachinePart>();
while (sqlDr.Read())
{
machinePart = new MachinePart();
machinePart.ID = int.Parse(sqlDr["ID"].ToString());
machinePart.Name = sqlDr["Name"].ToString();
machinePart.Description = sqlDr["Description"].ToString();
machinePart.MachineType = int.Parse(sqlDr["MachineType"].ToString());
machinePart.DateCreated = DateTime.Parse(sqlDr["DateCreated"].ToString());
lstMachinePart.Add(machinePart);
}
returnMachinePart.Code = "00";
returnMachinePart.Message = "Lấy dữ liệu thành công.";
returnMachinePart.lstMachinePart = lstMachinePart;
}
else
{
returnMachinePart.Code = "01";
returnMachinePart.Message = "Không tồn tại bản ghi nào.";
returnMachinePart.Total = 0;
returnMachinePart.lstMachinePart = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachinePart.Code = "99";
returnMachinePart.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachinePart.Total = 0;
returnMachinePart.lstMachinePart = null;
mylog4net.Error("", ex);
}
return(returnMachinePart);
}
public ReturnFPBCheckingItem ListAll()
{
List <FPBCheckingItem> lstFPBCheckingItem = null;
FPBCheckingItem FPBCheckingItem = null;
ReturnFPBCheckingItem returnFPBCheckingItem = new ReturnFPBCheckingItem();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_FPBCheckingItem_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)
{
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());
//FPBCheckingItem.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstFPBCheckingItem.Add(FPBCheckingItem);
}
returnFPBCheckingItem.Code = "00";
returnFPBCheckingItem.Message = "Lấy dữ liệu thành công.";
returnFPBCheckingItem.LstFPBCheckingItem = lstFPBCheckingItem;
}
else
{
returnFPBCheckingItem.Code = "01";
returnFPBCheckingItem.Message = "Không tồn tại bản ghi nào.";
returnFPBCheckingItem.Total = 0;
returnFPBCheckingItem.LstFPBCheckingItem = null;
}
}
}
}
}
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 ReturnUserMenu CheckPermission(int userID, int menuId, string UnumPermission)
{
List <UserMenu> lstUserMenu = null;
UserMenu userMenu = null;
ReturnUserMenu returnUserMenu = new ReturnUserMenu();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tUserMenu_CheckPermission";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = userID;
cmd.Parameters.Add(new SqlParameter("@MenuId", SqlDbType.Int)).Value = menuId;
cmd.Parameters.Add(new SqlParameter("@UnumPermission", SqlDbType.NVarChar)).Value = UnumPermission;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstUserMenu = new List <UserMenu>();
while (sqlDr.Read())
{
userMenu = new UserMenu();
userMenu.ID = int.Parse(sqlDr["ID"].ToString());
userMenu.Pemission = sqlDr["Pemission"].ToString();
userMenu.UserID = int.Parse(sqlDr["UserID"].ToString());
userMenu.MenuID = int.Parse(sqlDr["MenuID"].ToString());
lstUserMenu.Add(userMenu);
}
returnUserMenu.Code = "00";
returnUserMenu.Message = "Lấy dữ liệu thành công.";
returnUserMenu.lstUserMenu = lstUserMenu;
}
else
{
returnUserMenu.Code = "01";
returnUserMenu.Message = "Không tồn tại bản ghi nào.";
returnUserMenu.Total = 0;
returnUserMenu.lstUserMenu = null;
}
}
}
}
}
catch (Exception ex)
{
returnUserMenu.Code = "99";
returnUserMenu.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUserMenu.Total = 0;
returnUserMenu.lstUserMenu = null;
mylog4net.Error("", ex);
}
return(returnUserMenu);
}
public ReturnUserMenu GetByUserID(int UserID)
{
List <UserMenu> lstUserMenu = null;
UserMenu userMenu = null;
ReturnUserMenu returnUserMenu = new ReturnUserMenu();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tUserMenu_SelectByUserID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = UserID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstUserMenu = new List <UserMenu>();
while (sqlDr.Read())
{
userMenu = new UserMenu();
userMenu.ID = int.Parse(sqlDr["ID"].ToString());
userMenu.Pemission = sqlDr["Pemission"].ToString();
userMenu.UserID = int.Parse(sqlDr["UserID"].ToString());
userMenu.MenuID = int.Parse(sqlDr["MenuID"].ToString());
userMenu.MenuName = sqlDr["MenuName"].ToString();
lstUserMenu.Add(userMenu);
}
returnUserMenu.Code = "00";
returnUserMenu.Message = "Lấy dữ liệu thành công.";
returnUserMenu.lstUserMenu = lstUserMenu;
}
else
{
returnUserMenu.Code = "01";
returnUserMenu.Message = "Không tồn tại bản ghi nào.";
returnUserMenu.Total = 0;
returnUserMenu.lstUserMenu = null;
}
}
}
}
}
catch (Exception ex)
{
returnUserMenu.Code = "99";
returnUserMenu.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUserMenu.Total = 0;
returnUserMenu.lstUserMenu = null;
mylog4net.Error("", ex);
}
return(returnUserMenu);
}
