public int CountRows_WeedMeeting(WeedMeetingModels clparam) { logger.Start("CountRows_WeedMeeting"); int iResult = 0; try { Hashtable param = new Hashtable(); param = base.SetDataToHashtable(false, clparam); if (clparam.maphongban == "0" || clparam.maphongban == null) { param["maphongban"] = ""; } else { param["maphongban"] = clparam.maphongban; } iResult = (int)sqlMap.ExecuteQueryForObject("WeedMeeting.CountRows_WeedMeeting", param); } catch (Exception ex) { sqlMap.RollbackTransaction(); iResult = 0; logger.Error(ex.Message); } logger.End("CountRows_WeedMeeting"); return(iResult); }
public List <WeedMeetingModels> SelectRows_WeedMeetingBCTC(WeedMeetingModels clParam, int trangbd, int trangkt) { logger.Start("SelectRows_WeedMeetingBCTC"); List <WeedMeetingModels> lstResult = new List <WeedMeetingModels>(); try { Hashtable param = new Hashtable(); param = base.SetDataToHashtable(false, clParam); if (clParam.nguoitao == 0) { param["nguoitao"] = ""; } if (clParam.maphongban == "0") { param["maphongban"] = ""; } else { param["maphongban"] = clParam.maphongban; } if (clParam.loaibaocao == 0) { param["loaibaocao"] = ""; } else { param["loaibaocao"] = clParam.loaibaocao; } param["trangbd"] = trangbd; param["trangkt"] = trangkt; IList ilist = sqlMap.ExecuteQueryForList("WeedMeeting.SelectRow_WeedMeetingBCTC", param); CastDataType cast = new CastDataType(); lstResult = cast.AdvanceCastDataToList <WeedMeetingModels>(ilist); } catch (Exception ex) { logger.Error("Loi ---> " + ex.Message); } logger.End("SelectRows_WeedMeetingBCTC"); return(lstResult); }
private StringBuilder PrepareDataJson_WeedMeeting(WeedMeetingModels 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.macuochop.ToString(), function.ReadXMLGetKeyEncrypt()); try { sbResult.Append("{"); sbResult.Append("\"col_class\":\"rows-box\","); sbResult.Append("\"col_id\":\"" + strEncryptCode + "\","); sbResult.Append("\"col_attr\":[{\"name\":\"" + "subparent" + "\", \"value\":\"" + AES.EncryptText(model.macuochop.ToString(), function.ReadXMLGetKeyEncrypt()) + "\"}],"); sbResult.Append("\"col_value\":["); #region Data cell //colum checkbox string strHTML_Checkbox = string.Format("<input type='checkbox' onclick='Select(this);' class='chkCheck' codeid='{0}' macuochop='" + strEncryptCode + "'/>", model.macuochop); 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("Edit", "WeedMeeting2", new { macuochop = strEncryptCode }) + "'title='" + model.matuan + "'>" + model.tentuan + "</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("Edit", "WeedMeeting2", new { macuochop = strEncryptCode }) + "'title='" + model.ngayhop + "'>" + model.ngayhop + "</a>\""); //sbResult.Append("\"col_value\":\"" + model.tenkhoahoc + "\""); 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\":\"" + "<a href='" + Url.Action("Edit", "WeedMeeting2", new { macuochop = strEncryptCode }) + "'title='" + model.loaicuochop + "'>" + model.tenloaicuochop + "</a>\""); 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("\"title\":\"" + model.madonvi + "\","); sbResult.Append("\"col_value\":\"" + "<a href='" + Url.Action("Edit", "WeedMeeting2", new { macuochop = strEncryptCode }) + "'title='" + model.maphongban + "'>" + model.tenphongban + "</a>\""); 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.lydobuoihop + "\""); //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("\"col_value\":\"" + model.thanhphanthamdu + "\""); //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\":\"<a href='" + Url.Action("DownloadFile", "WeedMeeting2", new { tenfile = model.tenfile, idcode = model.uploadfile }) + "'>" + model.tenfile + "</a>\""); sbResult.Append("}"); #endregion sbResult.Append("]"); sbResult.Append("},"); } catch (Exception ex) { _logger.Error(ex); } return(sbResult); }
public JsonResult SelectRows_WeedMeeting(WeedMeetingModels model, int curentPage) { WeedMeetingModels param = new WeedMeetingModels(); DaotaoServices service = new DaotaoServices(); DanhmucServices service_danhmuc = new DanhmucServices(); //param.nguoitao = int.Parse(Session["userid"].ToString()); param.maphongban = model.maphongban; param.loaibaocao = model.loaibaocao; //if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1") //{ param.nguoitao = 0; //} string thudientu = Session["thudientu"].ToString().Trim(); List <PhongBanModels> y = null; var lstcaptrentt = y; PhongBanModels parampb = new PhongBanModels(); List <PhongBanModels> lstResult_phongban = service_danhmuc.SelectRows2(parampb); lstcaptrentt = lstResult_phongban.Where(p => p.maphongban == model.maphongban).ToList(); //StringBuilder sbloaibaocao = new StringBuilder(); //sbloaibaocao.Append(string.Format("<option value={0}>{1}</option>", "1", "Báo cáo tuần CHT/TPB")); if (lstcaptrentt[0].email == thudientu || lstcaptrentt[0].ghichu == thudientu || lstcaptrentt[0].sodienthoai == thudientu || lstcaptrentt[0].ghichu1 == thudientu || lstcaptrentt[0].ghichu2 == thudientu || Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1") { param.loaibaocao = param.loaibaocao; } else if (model.loaibaocao == 2 && (lstcaptrentt[0].cv_thietbi == thudientu || lstcaptrentt[0].gs_thietbi == thudientu)) { param.loaibaocao = 2; } else if (model.loaibaocao == 3 && (lstcaptrentt[0].cv_hsse == thudientu || lstcaptrentt[0].gs_hsse == thudientu)) { param.loaibaocao = 3; } else if (model.loaibaocao == 4 && (lstcaptrentt[0].cv_qaqc == thudientu || lstcaptrentt[0].gs_qaqc == thudientu)) { param.loaibaocao = 4; } else if (model.loaibaocao == 5 && (lstcaptrentt[0].cv_mep == thudientu || lstcaptrentt[0].gs_mep == thudientu)) { param.loaibaocao = 5; } else { param.loaibaocao = 6; } int tongsodong = service.CountRows_WeedMeeting2(param); int sotrang = 1; if (tongsodong > 20) { if (tongsodong % 20 > 0) { sotrang = (tongsodong / 20) + 1; } else { sotrang = (tongsodong / 20); } } int trangbd = 1; int trangkt = 20; if (curentPage != 1 && curentPage <= sotrang) { trangbd = (trangkt * (curentPage - 1)) + 1; trangkt = trangkt * curentPage; } List <WeedMeetingModels> lstResult = new List <WeedMeetingModels>(); if (curentPage <= sotrang) { lstResult = service.SelectRows_WeedMeeting2(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(); if (item.loaicuochop == "1") { item.tenloaicuochop = "Họp tuần phòng"; } else if (item.loaicuochop == "2") { item.tenloaicuochop = "Họp tuần BGĐ"; } else if (item.loaicuochop == "3") { item.tenloaicuochop = "Họp khác"; } else { item.tenloaicuochop = ""; } if (item.phonghop == "1") { item.tenphonghop = "Tầng 3 - Phòng họp 1"; } else if (item.phonghop == "2") { item.tenphonghop = "Tầng 3 - Phòng họp 2"; } else if (item.phonghop == "3") { item.tenphonghop = "Tầng 3 - Phòng họp lớn"; } else if (item.phonghop == "4") { item.tenphonghop = "Tầng 3A - Phòng họp nhỏ"; } else if (item.phonghop == "5") { item.tenphonghop = "Tầng 3A - Phòng họp lớn"; } else if (item.phonghop == "6") { item.tenphonghop = "Khác"; } else { item.tenphonghop = ""; } sbRows.Append(PrepareDataJson_WeedMeeting(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)); }
public JsonResult SelectRows_WeedMeeting(WeedMeetingModels model, int curentPage) { WeedMeetingModels param = new WeedMeetingModels(); DaotaoServices service = new DaotaoServices(); //param.nguoitao = int.Parse(Session["userid"].ToString()); param.maphongban = model.maphongban; if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1") { param.nguoitao = 0; } int tongsodong = service.CountRows_WeedMeeting(param); int sotrang = 1; if (tongsodong > 20) { if (tongsodong % 20 > 0) { sotrang = (tongsodong / 20) + 1; } else { sotrang = (tongsodong / 20); } } int trangbd = 1; int trangkt = 20; if (curentPage != 1 && curentPage <= sotrang) { trangbd = (trangkt * (curentPage - 1)) + 1; trangkt = trangkt * curentPage; } List <WeedMeetingModels> lstResult = new List <WeedMeetingModels>(); if (curentPage <= sotrang) { lstResult = service.SelectRows_WeedMeeting(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(); if (item.loaicuochop == "1") { item.tenloaicuochop = "Họp tuần phòng"; } else if (item.loaicuochop == "2") { item.tenloaicuochop = "Họp tuần BGĐ"; } else if (item.loaicuochop == "3") { item.tenloaicuochop = "Họp khác"; } else { item.tenloaicuochop = ""; } if (item.phonghop == "1") { item.tenphonghop = "Tầng 3 - Phòng họp 1"; } else if (item.phonghop == "2") { item.tenphonghop = "Tầng 3 - Phòng họp 2"; } else if (item.phonghop == "3") { item.tenphonghop = "Tầng 3 - Phòng họp lớn"; } else if (item.phonghop == "4") { item.tenphonghop = "Tầng 3A - Phòng họp nhỏ"; } else if (item.phonghop == "5") { item.tenphonghop = "Tầng 3A - Phòng họp lớn"; } else if (item.phonghop == "6") { item.tenphonghop = "Khác"; } else { item.tenphonghop = ""; } sbRows.Append(PrepareDataJson_WeedMeeting(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)); }