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