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