public int CountRows_Danhsachdanhgiasaudaotao(daotao_ykiensaodaotaoModels clparam)
{
logger.Start("CountRows_Danhsachdanhgiasaudaotao");
int iResult = 0;
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
if (clparam.malop == 0)
{
param["malop"] = "";
}
//if (param["madangky"].ToString() == "0")
// param["madangky"] = "";
//if (param["maphongban"].ToString() == "0")
// param["maphongban"] = "";
iResult = (int)sqlMap.ExecuteQueryForObject("Saudaotao.CountRows_Danhsachdanhgiasaudaotao", param);
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
iResult = 0;
logger.Error(ex.Message);
}
logger.End("CountRows_Danhsachdanhgiasaudaotao");
return(iResult);
}
public JsonResult SelectRows_Danhsachdanhgiasaudaotao(daotao_ykiensaodaotaoModels model, int curentPage)
{
daotao_ykiensaodaotaoModels param = new daotao_ykiensaodaotaoModels();
SaudaotaoServices service = new SaudaotaoServices();
param.nguoitao = int.Parse(Session["userid"].ToString());
param.malop = model.malop;
int tongsodong = service.CountRows_Danhsachdanhgiasaudaotao(param);
int sotrang = 1;
if (tongsodong > 30)
{
if (tongsodong % 30 > 0)
{
sotrang = (tongsodong / 30) + 1;
}
else
{
sotrang = (tongsodong / 30);
}
}
int trangbd = 1; int trangkt = 30;
if (curentPage != 1 && curentPage <= sotrang)
{
trangbd = (trangkt * (curentPage - 1)) + 1;
trangkt = trangkt * curentPage;
}
List <daotao_ykiensaodaotaoModels> lstResult = new List <daotao_ykiensaodaotaoModels>();
if (curentPage <= sotrang)
{
lstResult = service.SelectRows_Danhsachdanhgiasaudaotao(param, trangbd, trangkt);
}
else if (curentPage != 1 && curentPage > sotrang)
{
curentPage = curentPage - 1;
}
StringBuilder sbResult = new StringBuilder();
StringBuilder sbRows = new StringBuilder();
int tongdong = 0;
if (lstResult.Count > 0)
{
string strSTT = "";
int i = trangbd;
foreach (var item in lstResult)
{
strSTT = i.ToString();
sbRows.Append(PrepareDataJson_Danhsachdanhgiasaudaotao(item, strSTT));
i++;
}
tongdong = i - 1;
if (sbRows.Length > 0)
{
sbRows.Remove(sbRows.Length - 1, 1);
}
}
if (tongsodong == 0)
{
sotrang = 0;
}
sbResult.Append("{");
sbResult.Append("\"isHeader\":\"" + "111" + "\",");
sbResult.Append("\"tongdong\":\"" + "" + tongsodong + "" + "\",");
sbResult.Append("\"Pages\":\"" + "" + sotrang + "" + "\",");
sbResult.Append("\"SubRow\":\"" + "false" + "\",");
sbResult.Append("\"data\":[" + sbRows.ToString() + "]");
sbResult.Append("}");
return(Json(sbResult.ToString(), JsonRequestBehavior.AllowGet));
}
private StringBuilder PrepareDataJson_Danhsachdanhgiasaudaotao(daotao_ykiensaodaotaoModels model, string couter)
{
//duong dan file encryption key
FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config"));
StringBuilder sbResult = new StringBuilder();
string strEncryptCode = AES.EncryptText(model.matiepnhan.ToString(), function.ReadXMLGetKeyEncrypt());
string mahoa_lop = AES.EncryptText(model.malop.ToString(), function.ReadXMLGetKeyEncrypt());
try
{
sbResult.Append("{");
sbResult.Append("\"col_class\":\"rows-box\",");
sbResult.Append("\"col_id\":\"" + strEncryptCode + "\",");
sbResult.Append("\"col_attr\":[{\"name\":\"" + "subparent" + "\", \"value\":\"" + mahoa_lop + "\"}],");
sbResult.Append("\"col_value\":[");
#region Data cell
//colum checkbox
//string strHTML_Checkbox = string.Format("<input type='checkbox' onclick='Select(this);' class='chkCheck' codeid='{0}' malop='" + strEncryptCode + "'/>", model.malop);
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col1\",");
//sbResult.Append("\"col_id\":\"1\",");
//sbResult.Append("\"col_value\":\"" + strHTML_Checkbox + "\"");
//sbResult.Append("},");
//stt
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col2 stt\",");
sbResult.Append("\"col_id\":\"2\",");
sbResult.Append("\"col_value\":\"" + couter + "\"");
sbResult.Append("},");
//Mã đơn vị
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col3\",");
sbResult.Append("\"col_id\":\"3\",");
//sbResult.Append("\"col_value\":\"" + model.tenlop + "\"");
sbResult.Append("\"col_value\":\"" + "<a href='" + Url.Action("Createtrainning", "Aftertraining", new { idmalophc = model.malop }) + "'title='" + model.tenlop + "'>" + model.tenlop + "</a>\"");
sbResult.Append("},");
//Mã nhân viên
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col4\",");
sbResult.Append("\"col_id\":\"4\",");
sbResult.Append("\"col_value\":\"" + "<a href='" + Url.Action("Createtrainning", "Classlist", new { idmalophc = model.malop }) + "'title='" + model.tieudekhoahoc + "'>" + model.tieudekhoahoc + "</a>\"");
sbResult.Append("},");
//Họ và tên
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col5\",");
sbResult.Append("\"col_id\":\"5\",");
sbResult.Append("\"col_value\":\"" + model.manv + "\"");
sbResult.Append("},");
//Tên đon vi
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col6\",");
sbResult.Append("\"col_id\":\"6\",");
sbResult.Append("\"col_value\":\"" + model.hovaten + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col7\",");
sbResult.Append("\"col_id\":\"7\",");
sbResult.Append("\"col_value\":\"" + model.email + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col8\",");
sbResult.Append("\"col_id\":\"8\",");
sbResult.Append("\"title\":\"" + model.maphongban + "\",");
sbResult.Append("\"col_value\":\"" + model.tenphongban + "\"");
sbResult.Append("},");
//Tên phòng ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col9\",");
sbResult.Append("\"col_id\":\"9\",");
sbResult.Append("\"col_value\":\"" + model.ngaydaotao + "\"");
sbResult.Append("}");
#endregion
sbResult.Append("]");
sbResult.Append("},");
}
catch (Exception ex)
{
_logger.Error(ex);
}
return(sbResult);
}
public List <daotao_ykiensaodaotaoModels> SelectRows_Danhsachdanhgiasaudaotao(daotao_ykiensaodaotaoModels clParam, int trangbd, int trangkt)
{
logger.Start("SelectRows_Danhsachlophoc");
List <daotao_ykiensaodaotaoModels> lstResult = new List <daotao_ykiensaodaotaoModels>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
if (clParam.malop == 0)
{
param["malop"] = "";
}
//if (param["maphongban"].ToString() == "0")
// param["maphongban"] = "";
//if (param["nguoitao"].ToString() == "0" || param["nguoitao"].ToString() == "1")
// param["nguoitao"] = "";
param["trangbd"] = trangbd;
param["trangkt"] = trangkt;
IList ilist = sqlMap.ExecuteQueryForList("Saudaotao.SelectRows_Danhsachdanhgiasaudaotao", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <daotao_ykiensaodaotaoModels>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectRows_Danhsachlophoc");
return(lstResult);
}
public List <daotao_ykiensaodaotaoModels> SelectRows_daotao_ykiensaodaotao_malop_email(daotao_ykiensaodaotaoModels clParam)
{
logger.Start("SelectRows_Laydslophoctheo_nhanvien_theolop");
List <daotao_ykiensaodaotaoModels> lstResult = new List <daotao_ykiensaodaotaoModels>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
IList ilist = sqlMap.ExecuteQueryForList("Saudaotao.SelectRows_daotao_ykiensaodaotao_malop_email", param);
if (ilist.Count > 0)
{
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <daotao_ykiensaodaotaoModels>(ilist);
}
else
{
ilist = sqlMap.ExecuteQueryForList("Saudaotao.SelectRows_Laydslophoctheo_nhanvien_theolop", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <daotao_ykiensaodaotaoModels>(ilist);
}
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectRows_daotao_ykiensaodaotao_malop_email");
return(lstResult);
}
