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 ReturnMachineMtnContentList Insert(MachineMtnContentList machineMtnContentList)
{
ReturnMachineMtnContentList returnMachineTypeMtnContentList = new ReturnMachineMtnContentList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtnContentList_InsertUpdate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = machineMtnContentList.ID;
cmd.Parameters.Add(new SqlParameter("@MachineTypeID", SqlDbType.VarChar)).Value = machineMtnContentList.MachineTypeID;
cmd.Parameters.Add(new SqlParameter("@MachinePartID", SqlDbType.NVarChar)).Value = machineMtnContentList.MachinePartID;
cmd.Parameters.Add(new SqlParameter("@ContentMtn", SqlDbType.NVarChar)).Value = machineMtnContentList.ContentMtn.Trim();
cmd.Parameters.Add(new SqlParameter("@ToolMtn", SqlDbType.NVarChar)).Value = machineMtnContentList.ToolMtn != null?machineMtnContentList.ToolMtn.Trim() : "";
cmd.Parameters.Add(new SqlParameter("@MethodMtn", SqlDbType.NVarChar)).Value = machineMtnContentList.MethodMtn != null?machineMtnContentList.MethodMtn.Trim() : "";
cmd.Parameters.Add(new SqlParameter("@Standard", SqlDbType.NVarChar)).Value = machineMtnContentList.Standard != null?machineMtnContentList.Standard.Trim() : "";
cmd.Parameters.Add(new SqlParameter("@FrequencyID", SqlDbType.SmallInt)).Value = machineMtnContentList.FrequencyID;
cmd.Parameters.Add(new SqlParameter("@IsActive", SqlDbType.Bit)).Value = machineMtnContentList.IsActive;
cmd.Parameters.Add(new SqlParameter("@Min", SqlDbType.NVarChar)).Value = String.IsNullOrEmpty(machineMtnContentList.Min) ? "" : machineMtnContentList.Min.Trim();
cmd.Parameters.Add(new SqlParameter("@Max", SqlDbType.NVarChar)).Value = String.IsNullOrEmpty(machineMtnContentList.Max) ? "" : machineMtnContentList.Max.Trim();
cmd.ExecuteNonQuery();
returnMachineTypeMtnContentList.Code = "00";
returnMachineTypeMtnContentList.Message = "Cập nhật dữ liệu thành công.";
}
}
}
catch (Exception ex)
{
returnMachineTypeMtnContentList.Code = "99";
returnMachineTypeMtnContentList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineTypeMtnContentList.Total = 0;
returnMachineTypeMtnContentList.lstMachineMtnContentList = null;
mylog4net.Error("", ex);
}
return(returnMachineTypeMtnContentList);
}
public ReturnMachineMtnContentList GetbyID(int ID)
{
List <MachineMtnContentList> lstMachineTypeMtnContentList = null;
MachineMtnContentList machineMtnContentList = null;
ReturnMachineMtnContentList returnMachineTypeMtnContentList = new ReturnMachineMtnContentList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
//cmd.Connection = _sqlConnection;
cmd.CommandText = "sp_tMachineMtnContentList_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)
{
lstMachineTypeMtnContentList = new List <MachineMtnContentList>();
while (sqlDr.Read())
{
machineMtnContentList = new MachineMtnContentList();
machineMtnContentList.ID = Convert.ToInt16(sqlDr["ID"].ToString());
machineMtnContentList.MachineTypeID = Convert.ToInt16(sqlDr["MachineTypeID"].ToString());
machineMtnContentList.MachinePartID = Convert.ToInt16(sqlDr["MachinePartID"].ToString());
machineMtnContentList.ContentMtn = sqlDr["ContentMtn"].ToString();
machineMtnContentList.ToolMtn = sqlDr["ToolMtn"].ToString();
machineMtnContentList.MethodMtn = sqlDr["MethodMtn"].ToString();
machineMtnContentList.Standard = sqlDr["Standard"].ToString();
machineMtnContentList.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString());
machineMtnContentList.MachinePartName = sqlDr["Name"].ToString();
machineMtnContentList.MachineTypeName = sqlDr["TypeName"].ToString();
machineMtnContentList.IsActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
machineMtnContentList.Min = sqlDr["Min"].ToString();
machineMtnContentList.Max = sqlDr["Max"].ToString();
lstMachineTypeMtnContentList.Add(machineMtnContentList);
}
returnMachineTypeMtnContentList.Code = "00";
returnMachineTypeMtnContentList.Message = "Lấy dữ liệu thành công.";
returnMachineTypeMtnContentList.lstMachineMtnContentList = lstMachineTypeMtnContentList;
}
else
{
returnMachineTypeMtnContentList.Code = "01";
returnMachineTypeMtnContentList.Message = "Không tồn tại bản ghi nào.";
returnMachineTypeMtnContentList.Total = 0;
returnMachineTypeMtnContentList.lstMachineMtnContentList = null;
}
}
}
}
}
catch (Exception ex)
{
returnMachineTypeMtnContentList.Code = "99";
returnMachineTypeMtnContentList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineTypeMtnContentList.Total = 0;
returnMachineTypeMtnContentList.lstMachineMtnContentList = null;
mylog4net.Error("", ex);
}
return(returnMachineTypeMtnContentList);
}
public ReturnMachineMtnContentList ListByPage(int page, int pageSize)
{
List <MachineMtnContentList> lstMachineTypeMtnContentList = null;
MachineMtnContentList machineMtnContentList = null;
ReturnMachineMtnContentList returnMachineTypeMtnContentList = new ReturnMachineMtnContentList();
try
{
using (SqlConnection sqlConnection = ConnectSQLCommon.CreateAndOpenSqlConnection())
{
using (SqlCommand cmd = new SqlCommand("", sqlConnection))
{
cmd.CommandText = "sp_tMachineMtnContentList_SelectByPage";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int)).Value = page;
cmd.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int)).Value = pageSize;
cmd.Parameters.Add("@totalRow", SqlDbType.Int).Direction = ParameterDirection.Output;
using (SqlDataReader sqlDr = ConnectSQLCommon.ExecuteDataReader(cmd))
{
//if (float.Parse(cmd.Parameters["P_RETURN_CODE"].Value.ToString()) > 0)
//{
if (sqlDr.HasRows)
{
lstMachineTypeMtnContentList = new List <MachineMtnContentList>();
while (sqlDr.Read())
{
machineMtnContentList = new MachineMtnContentList();
machineMtnContentList.ID = Convert.ToInt16(sqlDr["ID"].ToString());
machineMtnContentList.MachineTypeID = Convert.ToInt16(sqlDr["MachineTypeID"].ToString());
machineMtnContentList.MachinePartID = Convert.ToInt16(sqlDr["MachinePartID"].ToString());
machineMtnContentList.ContentMtn = sqlDr["ContentMtn"].ToString();
machineMtnContentList.ToolMtn = sqlDr["ToolMtn"].ToString();
machineMtnContentList.MethodMtn = sqlDr["MethodMtn"].ToString();
machineMtnContentList.Standard = sqlDr["Standard"].ToString();
machineMtnContentList.FrequencyID = Convert.ToInt16(sqlDr["FrequencyID"].ToString());
machineMtnContentList.MachinePartName = sqlDr["Name"].ToString();
machineMtnContentList.MachineTypeName = sqlDr["TypeName"].ToString();
machineMtnContentList.IsActive = SMCommon.ConvertToBoolean(sqlDr["isActive"].ToString());
machineMtnContentList.Min = sqlDr["Min"].ToString();
machineMtnContentList.Max = sqlDr["Max"].ToString();
lstMachineTypeMtnContentList.Add(machineMtnContentList);
}
returnMachineTypeMtnContentList.Code = "00";
returnMachineTypeMtnContentList.Message = "Lấy dữ liệu thành công.";
returnMachineTypeMtnContentList.lstMachineMtnContentList = lstMachineTypeMtnContentList;
returnMachineTypeMtnContentList.UserID = MyShareInfo.ID;
returnMachineTypeMtnContentList.UserName = MyShareInfo.UserName;
returnMachineTypeMtnContentList.PageNumber = page;
}
else
{
returnMachineTypeMtnContentList.Code = "01";
returnMachineTypeMtnContentList.Message = "Không tồn tại bản ghi nào.";
returnMachineTypeMtnContentList.Total = 0;
returnMachineTypeMtnContentList.lstMachineMtnContentList = null;
}
//get return Totalpage value.
}
if (returnMachineTypeMtnContentList.Code == "00")
{
returnMachineTypeMtnContentList.Total = Convert.ToInt32(cmd.Parameters["@totalRow"].Value);
}
}
}
}
catch (Exception ex)
{
returnMachineTypeMtnContentList.Code = "99";
returnMachineTypeMtnContentList.Message = "Lỗi xử lý dữ liệu: " + ex.ToString();
returnMachineTypeMtnContentList.Total = 0;
returnMachineTypeMtnContentList.lstMachineMtnContentList = null;
mylog4net.Error("", ex);
}
return(returnMachineTypeMtnContentList);
}