public ReturnFPBCheckingDetail SelectByFPBCheckingID(int FPBCheckingID)
{
List <FPBCheckingDetail> lstFPBCheckingDetail = null;
FPBCheckingDetail FPBCheckingDetail = null;
ReturnFPBCheckingDetail returnFPBCheckingDetail = new ReturnFPBCheckingDetail();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_FPBCheckingDetail_SelectByFPBCheckingID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FPBCheckingID", SqlDbType.Int)).Value = FPBCheckingID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstFPBCheckingDetail = new List <FPBCheckingDetail>();
while (sqlDr.Read())
{
FPBCheckingDetail = new FPBCheckingDetail();
FPBCheckingDetail.ID = int.Parse(sqlDr["ID"].ToString());
FPBCheckingDetail.FPBCheckingID = int.Parse(sqlDr["FPBCheckingID"].ToString());
FPBCheckingDetail.Images = sqlDr["Images"].ToString();
//FPBCheckingDetail.FPBCheckingItemID = int.Parse(sqlDr["FPBCheckingItemID"].ToString());
FPBCheckingDetail.Result = sqlDr["Result"].ToString();
FPBCheckingDetail.ResultContent = sqlDr["ResultContent"].ToString();
//FPBCheckingDetail.CheckingItemName = sqlDr["CheckingItemName"].ToString();
//FPBCheckingDetail.FrequencyID = int.Parse(sqlDr["FrequencyID"].ToString());
lstFPBCheckingDetail.Add(FPBCheckingDetail);
}
returnFPBCheckingDetail.Code = "00";
returnFPBCheckingDetail.Message = "Lấy dữ liệu thành công.";
returnFPBCheckingDetail.LstFPBCheckingDetail = lstFPBCheckingDetail;
}
else
{
returnFPBCheckingDetail.Code = "01";
returnFPBCheckingDetail.Message = "Không tồn tại bản ghi nào.";
returnFPBCheckingDetail.Total = 0;
returnFPBCheckingDetail.LstFPBCheckingDetail = null;
}
}
}
}
}
catch (Exception ex)
{
returnFPBCheckingDetail.Code = "99";
returnFPBCheckingDetail.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnFPBCheckingDetail.Total = 0;
returnFPBCheckingDetail.LstFPBCheckingDetail = null;
mylog4net.Error("SelectByFPBCheckingID", ex);
}
return(returnFPBCheckingDetail);
}
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 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 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 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 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 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 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 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 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 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);
}
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 ReturnMachineType MachineTypeAll()
{
List <MachineType> lstMachineType = null;
MachineType machineType = null;
ReturnMachineType returnMachineType = new ReturnMachineType();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineType_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstMachineType = new List <MachineType>();
while (sqlDr.Read())
{
machineType = new MachineType();
machineType.ID = int.Parse(sqlDr["ID"].ToString());
machineType.TypeName = sqlDr["TypeName"].ToString();
machineType.Description = sqlDr["Description"].ToString();
machineType.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstMachineType.Add(machineType);
}
returnMachineType.Total = lstMachineType.Count;
returnMachineType.Code = "00";
returnMachineType.Message = "Lấy dữ liệu thành công.";
returnMachineType.lstMachineType = lstMachineType;
}
else
{
returnMachineType.Code = "01";
returnMachineType.Message = "Không tồn tại bản ghi nào.";
returnMachineType.Total = 0;
returnMachineType.lstMachineType = null;
}
}
}
}
}
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 ReturnMachineMtnFrequencyView MachineMtnFrequencyAll()
{
List <MachineMtnFrequencyView> lstMachineMtnFrequencyView = null;
MachineMtnFrequencyView machineMtnFrequencyView = null;
ReturnMachineMtnFrequencyView returnMachineMtnFrequencyView = new ReturnMachineMtnFrequencyView();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtnFrequency_SelectAll";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstMachineMtnFrequencyView = new List <MachineMtnFrequencyView>();
while (sqlDr.Read())
{
machineMtnFrequencyView = new MachineMtnFrequencyView();
machineMtnFrequencyView.MachineID = sqlDr["MachineID"].ToString();
machineMtnFrequencyView.Daily = Convert.ToInt16(sqlDr["TanSuat1"].ToString());
machineMtnFrequencyView.Weekly = Convert.ToInt16(sqlDr["TanSuat2"].ToString());
machineMtnFrequencyView.Monthly = Convert.ToInt16(sqlDr["TanSuat3"].ToString());
machineMtnFrequencyView.ThreeMonths = Convert.ToInt16(sqlDr["TanSuat4"].ToString());
machineMtnFrequencyView.SixMonths = Convert.ToInt16(sqlDr["TanSuat5"].ToString());
machineMtnFrequencyView.Yearly = Convert.ToInt16(sqlDr["TanSuat6"].ToString());
lstMachineMtnFrequencyView.Add(machineMtnFrequencyView);
}
returnMachineMtnFrequencyView.Code = "00";
returnMachineMtnFrequencyView.Message = "Lấy dữ liệu thành công.";
returnMachineMtnFrequencyView.lstMachineMtnFrequencyView = lstMachineMtnFrequencyView;
}
else
{
returnMachineMtnFrequencyView.Code = "01";
returnMachineMtnFrequencyView.Message = "Không tồn tại bản ghi nào.";
returnMachineMtnFrequencyView.Total = 0;
returnMachineMtnFrequencyView.lstMachineMtnFrequencyView = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachineMtnFrequencyView.Code = "99";
returnMachineMtnFrequencyView.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineMtnFrequencyView.Total = 0;
returnMachineMtnFrequencyView.lstMachineMtnFrequencyView = null;
mylog4net.Error("", ex);
}
return(returnMachineMtnFrequencyView);
}
public ReturnRole ListByUserID(int userID)
{
List <Role> lstRole = null;
Role role = null;
ReturnRole returnRole = new ReturnRole();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "[sp_tRole_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)
{
lstRole = new List <Role>();
while (sqlDr.Read())
{
role = new Role();
role.ID = int.Parse(sqlDr["ID"].ToString());
role.RoleName = sqlDr["RoleName"].ToString();
role.Title = sqlDr["Title"].ToString();
lstRole.Add(role);
}
returnRole.Code = "00";
returnRole.Message = "Lấy dữ liệu thành công.";
returnRole.lstRole = lstRole;
}
else
{
returnRole.Code = "01";
returnRole.Message = "Không tồn tại bản ghi nào.";
returnRole.Total = 0;
returnRole.lstRole = null;
}
}
}
}
}
catch (Exception ex)
{
returnRole.Code = "99";
returnRole.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnRole.Total = 0;
returnRole.lstRole = null;
mylog4net.Error("", ex);
}
return(returnRole);
}
public ReturnMachineTypeFrequency GetbyMachineTypeID(int MachineTypeID)
{
List <MachineTypeFrequency> lstMachineTypeFrequency = null;
MachineTypeFrequency machineTypeFrequency = null;
ReturnMachineTypeFrequency returnMachineTypeFrequency = new ReturnMachineTypeFrequency();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMachineTypeFrequency_SelectByMachineTypeID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = MachineTypeID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstMachineTypeFrequency = new List <MachineTypeFrequency>();
while (sqlDr.Read())
{
machineTypeFrequency = new MachineTypeFrequency();
machineTypeFrequency.ID = Convert.ToInt16(sqlDr["ID"].ToString());
machineTypeFrequency.MachineTypeID = Convert.ToInt32(sqlDr["MachineTypeID"].ToString());
machineTypeFrequency.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString());
lstMachineTypeFrequency.Add(machineTypeFrequency);
}
returnMachineTypeFrequency.Code = "00";
returnMachineTypeFrequency.Message = "Lấy dữ liệu thành công.";
returnMachineTypeFrequency.lstMachineTypeFrequency = lstMachineTypeFrequency;
returnMachineTypeFrequency.Total = lstMachineTypeFrequency.Count;
}
else
{
returnMachineTypeFrequency.Code = "01";
returnMachineTypeFrequency.Message = "Không tồn tại bản ghi nào.";
returnMachineTypeFrequency.Total = 0;
returnMachineTypeFrequency.lstMachineTypeFrequency = null;
}
}
}
}
}
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 ReturnUserPermission ListAllControllerName_PermissionByUserID(int userID)
{
List <UserPermission> lstUserPermission = null;
UserPermission userPermission = null;
ReturnUserPermission returnUserMenu = new ReturnUserPermission();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMenu_ListAllControllerName_PermissionByUserID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserID", SqlDbType.Int)).Value = userID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstUserPermission = new List <UserPermission>();
while (sqlDr.Read())
{
userPermission = new UserPermission();
userPermission.RoleID = int.Parse(sqlDr["RoleID"].ToString());
userPermission.MenuID = int.Parse(sqlDr["MenuID"].ToString());
userPermission.Permission = sqlDr["Permission"].ToString();
userPermission.ControllerName = sqlDr["ControllerName"].ToString();
lstUserPermission.Add(userPermission);
}
returnUserMenu.Code = "00";
returnUserMenu.Message = "Lấy dữ liệu thành công.";
returnUserMenu.lstUserPermission = lstUserPermission;
}
else
{
returnUserMenu.Code = "01";
returnUserMenu.Message = "Không tồn tại bản ghi nào.";
returnUserMenu.Total = 0;
returnUserMenu.lstUserPermission = null;
}
}
}
}
}
catch (Exception ex)
{
returnUserMenu.Code = "99";
returnUserMenu.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnUserMenu.Total = 0;
returnUserMenu.lstUserPermission = null;
mylog4net.Error("", ex);
}
return(returnUserMenu);
}
public ReturnToolTypeList GetbyID(string ToolTypeID)
{
List <ToolTypeList> lstToolTypeList = null;
ToolTypeList toolTypeList = null;
ReturnToolTypeList returnToolTypeList = new ReturnToolTypeList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tToolTypeList_SelectByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ToolTypeID", SqlDbType.VarChar)).Value = ToolTypeID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd, sqlConnection))
{
if (sqlDr.HasRows)
{
lstToolTypeList = new List <ToolTypeList>();
while (sqlDr.Read())
{
toolTypeList = new ToolTypeList();
toolTypeList.ToolTypeID = sqlDr["ToolTypeID"].ToString();
toolTypeList.ToolTypeName = sqlDr["ToolTypeName"].ToString();
toolTypeList.isActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
lstToolTypeList.Add(toolTypeList);
}
returnToolTypeList.Code = "00";
returnToolTypeList.Message = "Lấy dữ liệu thành công.";
returnToolTypeList.LstToolTypeList = lstToolTypeList;
}
else
{
returnToolTypeList.Code = "01";
returnToolTypeList.Message = "Không tồn tại bản ghi nào.";
returnToolTypeList.Total = 0;
returnToolTypeList.LstToolTypeList = null;
}
}
}
}
}
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 ReturnMachineMtn CountMachineMtByMachineID(string machineID)
{
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_CountByMachineID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.VarChar)).Value = machineID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
lstMachineMtn = new List <MachineMtn>();
while (sqlDr.Read())
{
returnMachineMtn.Total = Convert.ToInt16(sqlDr[0].ToString());
returnMachineMtn.UserID = MyShareInfo.ID;
returnMachineMtn.UserName = MyShareInfo.UserName;
}
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 ReturnUser SearchByUserName(string where)
{
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_tUserMenu_SearchByUserName";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@where", SqlDbType.NVarChar)).Value = where;
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["UserID"].ToString());
user.UserName = sqlDr["UserName"].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 ReturnMachine CountbyLineID(string LineID)
{
List <Machine> lstMachine = null;
Machine machine = null;
ReturnMachine returnMachine = new ReturnMachine();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMachineList_CountbyLineID";
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)
{
while (sqlDr.Read())
{
returnMachine.lstMachine = null;
returnMachine.Total = Convert.ToInt16(sqlDr[0].ToString());
}
returnMachine.Code = "00";
returnMachine.Message = "Lấy dữ liệu thành công.";
//}
}
else
{
returnMachine.Code = "01";
returnMachine.Message = "Không tồn tại bản ghi nào.";
returnMachine.Total = 0;
returnMachine.lstMachine = null;
}
}
}
}
}
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 ReturnMachineMtnContentList CountbyCondition(MachineMtnContentList machineMtnContentList)
{
List <MachineMtnContentList> lstMachineMtnContentList = null;
ReturnMachineMtnContentList returnMachineMtnContentList = new ReturnMachineMtnContentList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtnContentList_CountbyCondition";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.Int)).Value = machineMtnContentList.MachineTypeID;
cmd.Parameters.Add(new SqlParameter("@MachinePartID", SqlDbType.Int)).Value = machineMtnContentList.MachinePartID;
cmd.Parameters.Add(new SqlParameter("@ContentMtn", SqlDbType.NVarChar)).Value = machineMtnContentList.ContentMtn;
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.Int)).Value = machineMtnContentList.FrequencyID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
//lstMachineMtnContentList = new List<MachineMtnContentList>();
while (sqlDr.Read())
{
returnMachineMtnContentList.Total = Convert.ToInt16(sqlDr[0].ToString());
}
returnMachineMtnContentList.Code = "00";
returnMachineMtnContentList.Message = "Lấy dữ liệu thành công.";
returnMachineMtnContentList.lstMachineMtnContentList = lstMachineMtnContentList;
}
else
{
returnMachineMtnContentList.Code = "01";
returnMachineMtnContentList.Message = "Không tồn tại bản ghi nào.";
returnMachineMtnContentList.Total = 0;
returnMachineMtnContentList.lstMachineMtnContentList = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachineMtnContentList.Code = "99";
returnMachineMtnContentList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineMtnContentList.Total = 0;
returnMachineMtnContentList.lstMachineMtnContentList = null;
mylog4net.Error("public ReturnMachineMtnContentList CountbyCondition(MachineMtnContentList machineMtnContentList) :", ex);
}
return(returnMachineMtnContentList);
}
public ReturnProductionControl CountBySelection(string where)
{
List <ProductionControl> lstProductionControl = null;
ReturnProductionControl returnProductionControl = new ReturnProductionControl();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tProductionControl_CountBySelection";
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@MachineID", SqlDbType.NVarChar)).Value = productionControl.MachineID;
//cmd.Parameters.Add(new SqlParameter("@ProgramName", SqlDbType.NVarChar)).Value = productionControl.ProgramName;
//cmd.Parameters.Add(new SqlParameter("@PdtCtrlDateTime", SqlDbType.VarChar)).Value = productionControl.PdtCtrlDateTime;
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())
{
returnProductionControl.Total = Convert.ToInt16(sqlDr[0].ToString());
}
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;
}
}
}
}
}
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("public ReturnProductionControl CountProductionControlBySelection(ProductionControl productionControl) ", ex);
}
return(returnProductionControl);
}
public ReturnMachineMtnDetail CountbyMachineMtnContentID(int machineMtnContentID)
{
//List<int> lstint = null;
ReturnMachineMtnDetail returnMachineMtnDetail = new ReturnMachineMtnDetail();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtnDetail_CountbyMachineMtnContentID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MachineMtnContentID", SqlDbType.Int)).Value = machineMtnContentID;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
if (sqlDr.HasRows)
{
//lstint = new List<int>();
while (sqlDr.Read())
{
returnMachineMtnDetail.Total = Convert.ToInt16(sqlDr[0].ToString());
}
returnMachineMtnDetail.Code = "00";
returnMachineMtnDetail.Message = "Lấy dữ liệu thành công.";
returnMachineMtnDetail.lstMachineMtnDetail = null;
}
else
{
returnMachineMtnDetail.Code = "01";
returnMachineMtnDetail.Message = "Không tồn tại bản ghi nào.";
returnMachineMtnDetail.Total = 0;
returnMachineMtnDetail.lstMachineMtnDetail = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachineMtnDetail.Code = "99";
returnMachineMtnDetail.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineMtnDetail.Total = 0;
returnMachineMtnDetail.lstMachineMtnDetail = null;
mylog4net.Error("public ReturnMachineMtnDetail CountbyCondition(int machineMtnContentID) :", ex);
}
return(returnMachineMtnDetail);
}
//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 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 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 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 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 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);
}