public ActionResult EmailSystem(EmailSystem model) { if (!IsLogged()) { return(BackToLogin()); } //duong dan file encryption key FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkey.config")); //lay key da ma hoa string strKeyEncrypt = EncDec.Decrypt(function.ReadXMLGetKeyEncrypt()); XDocument doc = new XDocument( new XDeclaration("1.0", "utf-8", "true"), new XProcessingInstruction("test", "value"), new XComment(String.Format("Ngày {0} author: {1}", DateTime.Now, Session["userid"])), new XElement("email", new XElement("smtp_host", model.host), new XElement("smtp_port", model.port), new XElement("smtp_user", AES.EncryptText(model.user, strKeyEncrypt)), new XElement("smtp_pass", AES.EncryptText(model.pass, strKeyEncrypt)), new XElement("displayName", model.displayName), new XElement("enableSSL", model.enableSSL)) ); doc.Save(Functions.MapPath("~/Xml/Config/email.xml")); return(View()); }
public ActionResult Edit(string makh) { if (!IsLogged()) { return(BackToLogin()); } KeHoachServices serKeHoach = new KeHoachServices(); TaiKhoanServices serTaiKhoan = new TaiKhoanServices(); StringBuilder sbHeHoach = new StringBuilder(); StringBuilder sbNguoiThucHien = new StringBuilder(); List <KeHoachForCombobox> lstKeHoachForCombobox = serKeHoach.SelectKeHoachForCombobox(new KeHoachModels()); var keHoachGroup = from p in lstKeHoachForCombobox where p.makehoachgoc == "0" select p; foreach (var item in keHoachGroup) { string strPref = ""; sbHeHoach.Append(string.Format("<option value='{0}'>{1}</option>", item.maKeHoach, item.noidungmuctieu)); var subItem = from p in lstKeHoachForCombobox where p.makehoachgoc == item.maKeHoach select p; if (subItem.Count() > 0) { sbHeHoach.Append(PrefAppendCombobox(lstKeHoachForCombobox, item.maKeHoach, ref strPref)); } } foreach (var item in serTaiKhoan.SelectTaiKhoanForCombobox(new M_TaiKhoan())) { sbNguoiThucHien.Append(string.Format("<option value='{0}'>{1}</option>", item.mataikhoan, item.hoten)); } ViewBag.keHoachs = sbHeHoach.ToString(); ViewBag.nguoiThucHiens = sbNguoiThucHien.ToString(); #region Set Param M_KeHoach param = new M_KeHoach(); string strMaKeHoach = "0"; if (makh != "0" && makh != null) { FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); strMaKeHoach = AES.DecryptText(makh, function.ReadXMLGetKeyEncrypt()); } if (GetPhongBanDonVi() != null) { param.madonvi = GetPhongBanDonVi().madonvi; param.makehoach = strMaKeHoach; } #endregion makehoach = strMaKeHoach; KeHoachServices service = new KeHoachServices(); List <KeHoachModels> lstResult = service.SelectRows(param); if (lstResult.Count > 0) { return(View(lstResult[0])); } return(View()); }
public ActionResult EmailSystem() { if (!IsLogged()) { return(BackToLogin()); } //duong dan file encryption key FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkey.config")); //lay key da ma hoa string strKeyEncrypt = EncDec.Decrypt(function.ReadXMLGetKeyEncrypt()); EmailSystem model = new Models.EmailSystem(); #region doc thong tin chung (chuc vu, nguoi ky, ) XElement doc = XElement.Load(Functions.MapPath("~/Xml/Config/email.xml")); var list = doc.Elements(); model.host = list.ElementAt(0).Value; model.port = list.ElementAt(1).Value; model.user = AES.DecryptText(list.ElementAt(2).Value, strKeyEncrypt); model.pass = AES.DecryptText(list.ElementAt(3).Value, strKeyEncrypt); model.displayName = list.ElementAt(4).Value; if (list.ElementAt(5).Value == "1") { model.enableSSL = true; } else { model.enableSSL = false; } #endregion return(View(model)); }
//Hiệu chỉnh đơn đăng ký public ActionResult Editforleave(string madangky) { //check login if (!IsLogged()) { return(BackToLogin()); } DanhmucServices service = new DanhmucServices(); PhongBanModels parampb = new PhongBanModels(); List <PhongBanModels> lstResult_phongban = service.SelectRows(parampb); StringBuilder sbphongban = new StringBuilder(); foreach (var item in lstResult_phongban) { sbphongban.Append(string.Format("<option value='{0}'>{1}</option>", item.maphongban, item.tenphongban)); } ViewBag.sbphongban = sbphongban.ToString(); if (madangky != "0" && madangky != null) { FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); madangky = AES.DecryptText(madangky, function.ReadXMLGetKeyEncrypt()); MaDangKyNP = madangky; AbsentModels param = new AbsentModels(); param.manghiphep = madangky.Trim(); AbsentServices service_dangky = new AbsentServices(); List <AbsentModels> lstResult_dangky = service_dangky.SelectRows_Danhsachnghiphep_11111(param); if (lstResult_dangky.Count > 0) { if (lstResult_dangky[0].duyetcap1 == "1") { } string[] chuoi = lstResult_dangky[0].ngaysinh.Split('/'); if (chuoi.Length == 3) { lstResult_dangky[0].ngaysinh = chuoi[0]; lstResult_dangky[0].thangsinh = chuoi[1]; lstResult_dangky[0].namsinh = chuoi[2]; } else if (chuoi.Length == 2) { lstResult_dangky[0].thangsinh = chuoi[0]; lstResult_dangky[0].namsinh = chuoi[1]; } else { lstResult_dangky[0].namsinh = chuoi[0]; } if (lstResult_dangky.Count > 0) { return(View(lstResult_dangky[0])); } } } return(View()); }
public ActionResult Updatechucvu(string act, string ID, ChucDanhModels model) { if (!IsLogged()) { return(BackToLogin()); } if (act == "create") { ChucDanhModels param = new ChucDanhModels(); param.machucdanh = model.machucdanh; param.tenchucdanh = model.tenchucdanh; param.tengiaodich = model.tengiaodich; param.ghichu = model.ghichu; param.xoa = "0"; param.nguoitao = int.Parse(Session["userid"].ToString()); param.ngaytao = ngaytao; DanhmucServices services = new DanhmucServices(); string result = services.InsertRow_chucdanh(param); } else if (act == "update") { ChucDanhModels param = new ChucDanhModels(); FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); param.machucdanh = int.Parse(AES.DecryptText(ID, function.ReadXMLGetKeyEncrypt())); param.tenchucdanh = model.tenchucdanh; param.tengiaodich = model.tengiaodich; param.ghichu = model.ghichu; param.xoa = "0"; param.nguoitao = int.Parse(Session["userid"].ToString()); param.ngaytao = ngaytao; DanhmucServices services = new DanhmucServices(); bool result = services.UpdateRow_chucdanh(param); } else if (act == "delete") { ChucDanhModels param = new ChucDanhModels(); FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); param.machucdanh = int.Parse(AES.DecryptText(ID, function.ReadXMLGetKeyEncrypt())); param.nguoihieuchinh = int.Parse(Session["userid"].ToString()); DanhmucServices services = new DanhmucServices(); bool result = services.DeleteRows_chucdanh(param); } return(RedirectToAction("Indexchucdanh", "Danhmuc")); }
public ActionResult Deleted(string makh) { if (!IsLogged()) { return(BackToLogin()); } string strMaKeHoach = "0"; if (makh != "0" && makh != null) { FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); strMaKeHoach = AES.DecryptText(makh, function.ReadXMLGetKeyEncrypt()); } else { } return(View()); }
public ActionResult Deleted(string madangky) { if (!IsLogged()) { return(BackToLogin()); } if (madangky != null) { FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); madangky = AES.DecryptText(madangky, function.ReadXMLGetKeyEncrypt()); DaotaoServices service = new DaotaoServices(); bool kq = service.DeletedRow_Dangky_vpp(madangky, Session["userid"].ToString()); if (kq) { } } return(RedirectToAction("Index")); }
public ActionResult Deleted(string manghiphep) { if (!IsLogged()) { return(BackToLogin()); } if (manghiphep != null) { FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); string manghiphepaaaa = AES.DecryptText(manghiphep, function.ReadXMLGetKeyEncrypt()); AbsentServices service = new AbsentServices(); bool madangky = service.DeletedRow_Dondangkynghiphep(manghiphepaaaa, Session["userid"].ToString()); if (madangky) { } } return(RedirectToAction("Vacationlist")); }
private string EncryptData(string connectionString) { try { //duong dan file encryption key FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkey.config")); //lay key da ma hoa string strKeyEncrypt = EncDec.Decrypt(function.ReadXMLGetKeyEncrypt()); //lay gia tri trong cau connection string string[] strSplit = connectionString.Split(';'); //string strServer = AES.DecryptText(strSplit[0].Replace("server=", ""), strKeyEncrypt); //string strDatabaseName = AES.DecryptText(strSplit[1].Replace("database=", ""), strKeyEncrypt); //string strUserName = AES.DecryptText(strSplit[2].Replace("user id=", ""), strKeyEncrypt); //string strPassword = AES.DecryptText(strSplit[3].Replace("password="******""), strKeyEncrypt); string strServer = strSplit[0].Replace("server=", ""); string strDatabaseName = strSplit[1].Replace("database=", ""); string strUserName = strSplit[2].Replace("userid=", ""); string strPassword = strSplit[3].Replace("password="******""); string aaaa = string.Format("{0};{1};{2};{3}", strServer, strDatabaseName, strUserName, strPassword, strSplit[2].Split('=')[1]); //Data Source=RI-TONGHOP-01\SQLEXPRESS;Initial Catalog=RICONS;Integrated Security=True return(string.Format("{0};{1};{2};{3}", strServer, strDatabaseName, strUserName, strPassword, strSplit[2].Split('=')[1])); //return string.Format("server={0};database={1};user id={2};password={3};Port={4};", strServer, strDatabaseName, strUserName, strPassword, strSplit[4].Split('=')[1]); } catch (Exception ex) { logger.Error(ex); } return(string.Empty); }
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); }
private StringBuilder PrepareDataJson_Danhsachnghiphep(AbsentModels 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.manghiphep.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.manghiphep.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}' mdk='" + strEncryptCode + "' duyet='" + model.duyetcap1 + "' />", model.manghiphep); 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.manghiphep + "\""); sbResult.Append("},"); //Mã phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col4\","); sbResult.Append("\"col_id\":\"4\","); sbResult.Append("\"col_value\":\"" + model.hovaten + "\""); sbResult.Append("},"); //Tên đon vi sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col5\","); sbResult.Append("\"col_id\":\"5\","); //sbResult.Append("\"title\":\"" + model.madonvi + "\","); sbResult.Append("\"col_value\":\"" + model.ngaysinh + "\""); sbResult.Append("},"); ////Tên phòng ban //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col6\","); //sbResult.Append("\"col_id\":\"6\","); //sbResult.Append("\"title\":\"" + model.machucdanh + "\","); //sbResult.Append("\"col_value\":\"" + model.tenchucdanh + "\""); //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("\"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 col8\","); sbResult.Append("\"col_id\":\"8\","); sbResult.Append("\"col_value\":\"" + model.ngayxinnghitu + "\""); 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.songayxinnghi + "\""); sbResult.Append("},"); //Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col10\","); sbResult.Append("\"col_id\":\"10\","); sbResult.Append("\"title\":\"" + model.machucdanh + "\","); sbResult.Append("\"col_value\":\"" + model.ngayxinnghiden + "\""); sbResult.Append("},"); ////Tên phòng ban //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col11\","); //sbResult.Append("\"col_id\":\"11\","); //sbResult.Append("\"col_value\":\"" + model.songayphepconlai + "\""); //sbResult.Append("},"); //Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col12\","); sbResult.Append("\"col_id\":\"12\","); sbResult.Append("\"col_value\":\"" + model.lydoxinnghi + "\""); sbResult.Append("},"); //Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col13\","); sbResult.Append("\"col_id\":\"13\","); sbResult.Append("\"col_value\":\"" + model.loaiphepnam + "\""); sbResult.Append("},"); //Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col14\","); sbResult.Append("\"col_id\":\"14\","); sbResult.Append("\"title\":\"" + model.duyetcap1 + "\","); sbResult.Append("\"col_value\":\"" + model.duyetcap1ten + "\""); sbResult.Append("},"); //Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col15\","); sbResult.Append("\"col_id\":\"15\","); sbResult.Append("\"col_value\":\"" + model.duyetcap2ten + "\""); sbResult.Append("},"); //Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col16\","); sbResult.Append("\"col_id\":\"16\","); sbResult.Append("\"col_value\":\"" + model.xacnhantruockhivaolamlaiten + "\""); sbResult.Append("},"); //Ghi chú sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col17\","); sbResult.Append("\"col_id\":\"17\","); sbResult.Append("\"col_value\":\"''\""); sbResult.Append("}"); ////dinh kem tap tin //string strHTML_Attachment = ""; //#region ////string link = Url.Action("Edit", "Account", new { id = EncDec.EncodeCrypto(model.mataikhoan) }); //strHTML_Attachment = "<a href='#' class='edit' ><i class='fa fa-pencil-square-o' ></i></a> <a href='#' class='del'><i class='fa fa-trash-o' ></i></a>"; //#endregion //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col8\","); //sbResult.Append("\"col_id\":\"8\","); //sbResult.Append("\"col_value\":\"" + strHTML_Attachment + "\""); //sbResult.Append("}"); #endregion sbResult.Append("]"); sbResult.Append("},"); } catch (Exception ex) { _logger.Error(ex); } return(sbResult); }
private StringBuilder PrepareDataJson(PhongBanModels 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.maphongban, 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.maphongban, 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}' mpb='" + strEncryptCode + "'/>", model.maphongban); 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.maphongban.Trim() + "\""); sbResult.Append("},"); //Mã phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col4\","); sbResult.Append("\"col_id\":\"4\","); sbResult.Append("\"col_value\":\"" + model.tenphongban.Trim() + "\""); sbResult.Append("},"); //ho va ten sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col5\","); sbResult.Append("\"col_id\":\"5\","); sbResult.Append("\"col_value\":\"" + model.hovaten.Trim() + "\""); sbResult.Append("},"); //Email sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + model.email + "\""); sbResult.Append("},"); //so dien thoai luu thanh email cap quan ly sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col8\","); sbResult.Append("\"col_id\":\"8\","); sbResult.Append("\"col_value\":\"" + model.sodienthoai.Trim() + "\""); sbResult.Append("},"); ////thuoc quan ly //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col7\","); //sbResult.Append("\"col_id\":\"7\","); //sbResult.Append("\"title\":\"" + model.thuocquanly.Trim() + "\","); //sbResult.Append("\"col_value\":\"" + model.hotenquanly + "\""); //sbResult.Append("},"); //Ghi chú sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col9\","); sbResult.Append("\"col_id\":\"9\","); sbResult.Append("\"col_value\":\"" + model.ghichu.Trim() + "\""); sbResult.Append("},"); ////thuoc quan ly1 //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col11\","); //sbResult.Append("\"col_id\":\"11\","); //sbResult.Append("\"title\":\"" + model.thuocquanly1.Trim() + "\","); //sbResult.Append("\"col_value\":\"" + model.hotenquanly1 + "\""); //sbResult.Append("},"); //Ghi chú1 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col12\","); sbResult.Append("\"col_id\":\"12\","); sbResult.Append("\"col_value\":\"" + model.ghichu1.Trim() + "\""); sbResult.Append("},"); ////thuoc quan ly2 //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col13\","); //sbResult.Append("\"col_id\":\"13\","); //sbResult.Append("\"title\":\"" + model.thuocquanly2.Trim() + "\","); //sbResult.Append("\"col_value\":\"" + model.hotenquanly2 + "\""); //sbResult.Append("},"); //Ghi chú2 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col14\","); sbResult.Append("\"col_id\":\"14\","); sbResult.Append("\"col_value\":\"" + model.ghichu2.Trim() + "\""); sbResult.Append("},"); //CV_Thietbi sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col15\","); sbResult.Append("\"col_id\":\"15\","); sbResult.Append("\"col_value\":\"" + model.cv_thietbi.Trim() + "\""); sbResult.Append("},"); //GS_Thietbi sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col16\","); sbResult.Append("\"col_id\":\"16\","); sbResult.Append("\"col_value\":\"" + model.gs_thietbi.Trim() + "\""); sbResult.Append("},"); //CV_HSSE sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col17\","); sbResult.Append("\"col_id\":\"17\","); sbResult.Append("\"col_value\":\"" + model.cv_hsse.Trim() + "\""); sbResult.Append("},"); //GS_HSSE sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col18\","); sbResult.Append("\"col_id\":\"18\","); sbResult.Append("\"col_value\":\"" + model.gs_hsse.Trim() + "\""); sbResult.Append("},"); //CV_QAQC sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col19\","); sbResult.Append("\"col_id\":\"19\","); sbResult.Append("\"col_value\":\"" + model.cv_qaqc.Trim() + "\""); sbResult.Append("},"); //GS_QAQC sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col20\","); sbResult.Append("\"col_id\":\"20\","); sbResult.Append("\"col_value\":\"" + model.gs_qaqc.Trim() + "\""); sbResult.Append("},"); //CV_MEP sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col21\","); sbResult.Append("\"col_id\":\"21\","); sbResult.Append("\"col_value\":\"" + model.cv_mep.Trim() + "\""); sbResult.Append("},"); //GS_MEP sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col22\","); sbResult.Append("\"col_id\":\"22\","); sbResult.Append("\"col_value\":\"" + model.gs_mep.Trim() + "\""); sbResult.Append("},"); //dinh kem tap tin string strHTML_Attachment = ""; #region //string link = Url.Action("Edit", "Account", new { id = EncDec.EncodeCrypto(model.mataikhoan) }); strHTML_Attachment = "<a href='#' class='edit' ><i class='fa fa-pencil-square-o' ></i></a> <a href='#' class='del'><i class='fa fa-trash-o' ></i></a>"; #endregion sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col10\","); sbResult.Append("\"col_id\":\"10\","); sbResult.Append("\"col_value\":\"" + strHTML_Attachment + "\""); sbResult.Append("}"); #endregion sbResult.Append("]"); sbResult.Append("},"); } catch (Exception ex) { _logger.Error(ex); } return(sbResult); }
public JsonResult SelectRows(KeHoachModels model) { //lay phong ban don vi #region Set Param M_KeHoach param = new M_KeHoach(); string strMaKeHoach = "0"; if (model.makehoach != "0") { FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); strMaKeHoach = AES.DecryptText(model.makehoach, function.ReadXMLGetKeyEncrypt()); } if (GetPhongBanDonVi() != null) { param.madonvi = GetPhongBanDonVi().madonvi; param.makehoachgoc = strMaKeHoach; } #endregion KeHoachServices service = new KeHoachServices(); List <KeHoachModels> lstResult = service.SelectRows(param); StringBuilder sbResult = new StringBuilder(); StringBuilder sbRows = new StringBuilder(); if (lstResult.Count > 0) { string strSTT = ""; int i = 1; foreach (var item in lstResult) { bool isPlus = false; param.makehoachgoc = item.makehoach; if (service.CountRows(param) > 0) { isPlus = true; } if (model.stt == "0") { strSTT = i.ToString(); } else { strSTT = string.Format("{0}.{1}", model.stt, i); } sbRows.Append(PrepareDataJson(item, strSTT, isPlus)); i++; } if (sbRows.Length > 0) { sbRows.Remove(sbRows.Length - 1, 1); } } sbResult.Append("{"); sbResult.Append("\"isHeader\":\"" + "111" + "\","); sbResult.Append("\"Pages\":\"" + "212" + "\","); if (model.makehoach != "0") { sbResult.Append("\"SubRow\":\"" + "true" + "\","); sbResult.Append("\"RowID\":\"" + model.makehoach + "\","); } sbResult.Append("\"data\":[" + sbRows.ToString() + "]"); sbResult.Append("}"); return(Json(sbResult.ToString(), JsonRequestBehavior.AllowGet)); }
private StringBuilder PrepareDataJson_chucvu(ChucDanhModels 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.machucdanh.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.machucdanh.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}' mpb='" + strEncryptCode + "'/>", model.machucdanh); 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.machucdanh + "\""); sbResult.Append("},"); //Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col4\","); sbResult.Append("\"col_id\":\"4\","); sbResult.Append("\"col_value\":\"" + model.tenchucdanh + "<a href='" + Url.Action("Indexchucdanh", "Danhmuc", new { mapb = strEncryptCode }) + "' title='" + model.tenchucdanh + "'></a>" + "\""); sbResult.Append("},"); //Mã phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col5\","); sbResult.Append("\"col_id\":\"5\","); sbResult.Append("\"col_value\":\"" + model.tengiaodich + "\""); sbResult.Append("},"); //// Số diện thoại //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col6\","); //sbResult.Append("\"col_id\":\"6\","); //sbResult.Append("\"col_value\":\"" + model.tenphongban + "\""); //sbResult.Append("},"); // Số diện thoại sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + model.ghichu + "\""); sbResult.Append("}"); #endregion sbResult.Append("]"); sbResult.Append("},"); } catch (Exception ex) { _logger.Error(ex); } return(sbResult); }
public ActionResult Updatephongban(string act, string ID, PhongBanModels model) { if (!IsLogged()) { return(BackToLogin()); } if (act == "create") { PhongBanModels paramphongban = new PhongBanModels(); paramphongban.maphongban = ""; paramphongban.madonvi = "1"; paramphongban.tenphongban = model.tenphongban; paramphongban.sodienthoai = model.sodienthoai; paramphongban.email = model.email; paramphongban.hovaten = model.hovaten; //var lstcaptrentt = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly).ToList(); //if (lstcaptrentt.Count > 0) //{ //paramphongban.thuocquanly = model.thuocquanly; //paramphongban.hotenquanly = lstcaptrentt[0].hovaten; paramphongban.ghichu = model.ghichu; //} //var lstcaptrentt1 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly1).ToList(); //if (lstcaptrentt1.Count > 0) //{ //paramphongban.thuocquanly1 = model.thuocquanly1; //paramphongban.hotenquanly1 = lstcaptrentt1[0].hovaten; paramphongban.ghichu1 = model.ghichu1; //} //var lstcaptrentt2 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly2).ToList(); //if (lstcaptrentt2.Count > 0) //{ //paramphongban.thuocquanly2 = model.thuocquanly2; //paramphongban.hotenquanly2 = lstcaptrentt1[0].hovaten; paramphongban.ghichu2 = model.ghichu2; //} paramphongban.cv_thietbi = model.cv_thietbi; paramphongban.gs_thietbi = model.gs_thietbi; paramphongban.cv_hsse = model.cv_hsse; paramphongban.gs_hsse = model.gs_hsse; paramphongban.cv_qaqc = model.cv_qaqc; paramphongban.gs_qaqc = model.gs_qaqc; paramphongban.cv_mep = model.cv_mep; paramphongban.gs_mep = model.gs_mep; paramphongban.xoa = "0"; paramphongban.nguoitao = int.Parse(Session["userid"].ToString()); paramphongban.ngaytao = ngaytao; paramphongban.phongban_congtruong = "1"; DanhmucServices services = new DanhmucServices(); string result = services.Insert_phongban(paramphongban); maphongban = result; } else if (act == "update") { PhongBanModels paramphongban = new PhongBanModels(); FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); paramphongban.maphongban = AES.DecryptText(ID, function.ReadXMLGetKeyEncrypt()); paramphongban.madonvi = "1"; paramphongban.tenphongban = model.tenphongban; paramphongban.sodienthoai = model.sodienthoai; paramphongban.email = model.email; paramphongban.hovaten = model.hovaten; //var lstcaptrentt = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly).ToList(); //if (lstcaptrentt.Count > 0) // //paramphongban.thuocquanly = model.thuocquanly; //paramphongban.hotenquanly = lstcaptrentt[0].hovaten; paramphongban.ghichu = model.ghichu; //} //var lstcaptrentt1 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly1).ToList(); //if (lstcaptrentt1.Count > 0) //{ //paramphongban.thuocquanly1 = model.thuocquanly1; //paramphongban.hotenquanly1 = lstcaptrentt1[0].hovaten; paramphongban.ghichu1 = model.ghichu1; //} //var lstcaptrentt2 = lstthongtingiamdoc.Where(p => p.mathongtin == model.thuocquanly2).ToList(); //if (lstcaptrentt2.Count > 0) //{ //paramphongban.thuocquanly2 = model.thuocquanly2; //paramphongban.hotenquanly2 = lstcaptrentt1[0].hovaten; paramphongban.ghichu2 = model.ghichu2; //} paramphongban.cv_thietbi = model.cv_thietbi; paramphongban.gs_thietbi = model.gs_thietbi; paramphongban.cv_hsse = model.cv_hsse; paramphongban.gs_hsse = model.gs_hsse; paramphongban.cv_qaqc = model.cv_qaqc; paramphongban.gs_qaqc = model.gs_qaqc; paramphongban.cv_mep = model.cv_mep; paramphongban.gs_mep = model.gs_mep; paramphongban.xoa = "0"; paramphongban.nguoitao = int.Parse(Session["userid"].ToString()); paramphongban.ngaytao = ngaytao; DanhmucServices services = new DanhmucServices(); string result = services.Insert_phongban(paramphongban); maphongban = result; } else if (act == "delete") { PhongBanModels paramphongban = new PhongBanModels(); FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); paramphongban.maphongban = AES.DecryptText(ID, function.ReadXMLGetKeyEncrypt()); paramphongban.nguoihieuchinh = int.Parse(Session["userid"].ToString()); DanhmucServices services = new DanhmucServices(); string result = services.Deleted_phongban(paramphongban.maphongban.ToString(), paramphongban.nguoihieuchinh.ToString()); maphongban = result; } return(RedirectToAction("Index", "Danhmuc2")); }
private StringBuilder PrepareDataJson_KpiReport_Year(KpiReport_MonthModels 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.matonghopketqua.ToString(), function.ReadXMLGetKeyEncrypt()); string style = ""; if (model.groupcha.ToString().Trim() == "1") { style = "background-color:#719bef;font-weight: bold;font-size: 13px;"; } try { sbResult.Append("{"); sbResult.Append("\"col_class\":\"rows-box\","); sbResult.Append("\"col_id\":\"" + strEncryptCode + "\","); sbResult.Append("\"col_attr\":[{\"name\":\"" + "subparent" + "\", \"value\":\"" + strEncryptCode + "\"},{\"name\":\"" + "style" + "\", \"value\":\"" + style + "\"},{\"name\":\"" + "groupcha" + "\", \"value\":\"" + model.groupcha + "\"}],"); sbResult.Append("\"col_value\":["); #region Data cell string strHTML_Checkbox = string.Format("<input type='checkbox' onclick='Select(this);' class='chkCheck' codeid='{0}' matonghopketqua='" + model.matonghopketqua + "' phongban_congtruong='" + 1 + "'/>", model.matonghopketqua); sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col1\","); sbResult.Append("\"col_id\":\"1\","); if (model.groupcha == "1") { sbResult.Append("\"col_value\":\"" + "" + "\""); } else { 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\","); if (model.groupcha.Trim() == "1") { sbResult.Append("\"col_value\":\"" + model.stt + "\""); } else { 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\":\"" + "<a href='" + "" + "'title=" + model.manhanvien + ">" + model.manhanvien + "</a>\""); sbResult.Append("},"); // Tên phòng ban sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col4\","); sbResult.Append("\"col_id\":\"4\","); sbResult.Append("\"title\":\"" + model.maphongban + "\","); sbResult.Append("\"col_value\":\"" + "<a href='" + "" + "'title='" + model.hovaten + "'>" + model.hovaten + "</a>\""); sbResult.Append("},"); sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col10\","); sbResult.Append("\"col_id\":\"10\","); sbResult.Append("\"col_value\":\"" + "<a href='" + "" + "'title='" + model.tenchucdanhns + "'>" + model.tenchucdanhns + "</a>\""); sbResult.Append("},"); //Mã nhân viên sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col5\","); sbResult.Append("\"col_id\":\"5\","); sbResult.Append("\"col_value\":\"" + "<a href='" + "" + "'title='" + model.hanhvithaido + "'>" + model.hanhvithaido + "</a>\""); sbResult.Append("},"); // Họ và tên nhân viên soạn kpi sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + "<a href='" + "" + "'title='" + model.giaiquyetcongviec + "'>" + model.giaiquyetcongviec + "</a>\""); sbResult.Append("},"); //Tên chức danh sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col7\","); sbResult.Append("\"col_id\":\"7\","); sbResult.Append("\"title\":\"" + model.chucdanh + "\","); sbResult.Append("\"col_value\":\"" + "<a href='" + "" + "'title='" + model.ketquakpi + "'>" + model.ketquakpi + "</a>\""); sbResult.Append("},"); //Ngày đăng ký sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col8\","); sbResult.Append("\"col_id\":\"8\","); sbResult.Append("\"title\":\"" + model.maphanloaiketqua + "\","); sbResult.Append("\"col_value\":\"" + "<a href='" + "" + "'title='" + model.phanloaiketqua + "'>" + model.phanloaiketqua + "</a>\""); sbResult.Append("},"); // Ngày đánh giá sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col9\","); sbResult.Append("\"col_id\":\"9\","); if (model.groupcha.Trim() == "1") { sbResult.Append("\"col_value\":\"" + "" + "\""); } else { sbResult.Append("\"col_value\":\"" + "<textarea style='width:100%; resize:none; border-radius: 3px; border: 1px solid #bbb;box-shadow: 0 1px 1px rgba(0, 0, 0, 0.075) inset; transition: border 0.2s linear 0s, box-shadow 0.2s linear 0s;' rows='2' placeholder='' id='txtghichu' name='ghichu' >" + model.ghichu + "</textarea>" + "\""); } sbResult.Append("}"); //Ngày duyệt //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col13\","); //sbResult.Append("\"col_id\":\"13\","); //sbResult.Append("\"col_value\":\"" + model.truongphongxemxetkpi_ngay + "\""); //sbResult.Append("}"); #endregion sbResult.Append("]"); sbResult.Append("},"); } catch (Exception ex) { _logger.Error(ex); } return(sbResult); }
private StringBuilder PrepareDataJson(KeHoachModels model, string couter, bool isPlus) { //duong dan file encryption key FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); StringBuilder sbResult = new StringBuilder(); string strEncryptCode = AES.EncryptText(model.makehoach, 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.makehoachgoc, 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}' mkh='" + strEncryptCode + "'/>", model.makehoach); sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col1\","); sbResult.Append("\"col_id\":\"6\","); 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\":\"6\","); sbResult.Append("\"col_value\":\"" + couter + "\""); sbResult.Append("},"); //noi dung string strNoiDUng = ""; string strPref = ""; if (isPlus) { strNoiDUng += "<i class='fa fa-plus' onclick='ShowSubLine(this);' mkh='" + strEncryptCode + "'></i>"; } if (couter.IndexOf('.') > -1) { string[] capDo = couter.Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in capDo) { if (capDo.Length < 3) { strPref += " "; } else { strPref += " "; } } } sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col3\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + strPref + strNoiDUng + "<a href='" + Url.Action("Edit", "Milestones", new { makh = strEncryptCode }) + "' title='" + model.noidungmuctieu + "'>" + model.noidungmuctieu + "</a>\""); sbResult.Append("},"); //ty trọng sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col4\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + model.tytrong + "\""); sbResult.Append("},"); //Chi tieu nam sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col5\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + model.chitieunam + "\""); sbResult.Append("},"); //tháng 7 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + model.t7 + "\""); sbResult.Append("},"); //thang 8 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"8\","); sbResult.Append("\"col_value\":\"" + model.t8 + "\""); sbResult.Append("},"); //Thang 9 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"9\","); sbResult.Append("\"col_value\":\"" + model.t9 + "\""); sbResult.Append("},"); //Thang 10 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"10\","); sbResult.Append("\"col_value\":\"" + model.t10 + "\""); sbResult.Append("},"); //Thang 11 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"11\","); sbResult.Append("\"col_value\":\"" + model.t11 + "\""); sbResult.Append("},"); //Thang 12 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"12\","); sbResult.Append("\"col_value\":\"" + model.t12 + "\""); sbResult.Append("},"); //tháng 1 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"1\","); sbResult.Append("\"col_value\":\"" + model.t1 + "\""); sbResult.Append("},"); //thang 2 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"2\","); sbResult.Append("\"col_value\":\"" + model.t2 + "\""); sbResult.Append("},"); //Thang 3 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"3\","); sbResult.Append("\"col_value\":\"" + model.t3 + "\""); sbResult.Append("},"); //Thang 4 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"4\","); sbResult.Append("\"col_value\":\"" + model.t4 + "\""); sbResult.Append("},"); //Thang 5 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"5\","); sbResult.Append("\"col_value\":\"" + model.t5 + "\""); sbResult.Append("},"); ////nguoi thuc hien //sbResult.Append("{"); //sbResult.Append("\"colspan\":\"1\","); //sbResult.Append("\"col_class\":\"ovh col4\","); //sbResult.Append("\"col_id\":\"6\","); //sbResult.Append("\"title\":\"" + model.nguoithuchien + "\","); //sbResult.Append("\"col_value\":\"" + model.nguoithuchien + "\""); //sbResult.Append("},"); //tháng 6 sbResult.Append("{"); sbResult.Append("\"colspan\":\"1\","); sbResult.Append("\"col_class\":\"ovh col6\","); sbResult.Append("\"col_id\":\"6\","); sbResult.Append("\"col_value\":\"" + model.t6 + "\""); sbResult.Append("}"); #endregion sbResult.Append("]"); sbResult.Append("},"); } catch (Exception ex) { _logger.Error(ex); } return(sbResult); }
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 string Save_ykiensaodautao(string DataJson, string nguoitao, string matiepnhan) { logger.Start("Save_ykiensaodautao"); string matiepnhanid = ""; try { sqlMap.BeginTransaction(); Hashtable param = new Hashtable(); JObject json = JObject.Parse(DataJson); param["malop"] = json["data1"]["malop"].ToString(); param["manv"] = json["data1"]["manv"].ToString(); param["email"] = json["data1"]["email"].ToString(); param["hovaten"] = json["data1"]["hovaten"].ToString(); param["maphongban"] = json["data1"]["maphongban"].ToString(); param["tieudekhoahoc"] = json["data1"]["tieudekhoahoc"].ToString(); param["tengiaovien"] = json["data1"]["tengiaovien"].ToString(); param["ngaydaotao"] = json["data1"]["ngaydaotao"].ToString(); param["nguoitao"] = nguoitao; param["matiepnhan"] = json["data1"]["matiepnhan"].ToString(); if (param["matiepnhan"].ToString().Trim() == "0") { param["matiepnhan"] = GetSequence_All("dm_seq", "daotao_ykiensaodaotao"); sqlMap.Insert("Saudaotao.InsertRow_Saudaotao", param); } else { param["matiepnhan"] = param["matiepnhan"].ToString().Trim(); sqlMap.Update("Saudaotao.UpdateRow_Saudaotao", param); } matiepnhanid = param["matiepnhan"].ToString(); Hashtable param1 = new Hashtable(); JArray json_vpp_chitiet = (JArray)json["data2"]; FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); for (int i = 0; i < json_vpp_chitiet.Count(); i++) { param1 = new Hashtable(); param1["matiepnhan_tieuchidaotao"] = AES.DecryptText(json_vpp_chitiet[i]["matiepnhan_tieuchidaotao"].ToString().Trim(), function.ReadXMLGetKeyEncrypt()); param1["matieuchi"] = AES.DecryptText(json_vpp_chitiet[i]["matieuchi"].ToString().Trim(), function.ReadXMLGetKeyEncrypt()); param1["matiepnhan"] = matiepnhanid; param1["tentieuchi"] = json_vpp_chitiet[i]["tentieuchi"].ToString().Trim();// ["kem"] = "undefined" if (json_vpp_chitiet[i]["kem"].ToString().Trim() == "true") { param1["kem"] = "1"; } else { param1["kem"] = "0"; } if (json_vpp_chitiet[i]["trungbinh"].ToString().Trim() == "true") { param1["trungbinh"] = "1"; } else { param1["trungbinh"] = "0"; } if (json_vpp_chitiet[i]["kha"].ToString().Trim() == "true") { param1["kha"] = "1"; } else { param1["kha"] = "0"; } if (json_vpp_chitiet[i]["tot"].ToString().Trim() == "true") { param1["tot"] = "1"; } else { param1["tot"] = "0"; } if (json_vpp_chitiet[i]["rattot"].ToString().Trim() == "true") { param1["rattot"] = "1"; } else { param1["rattot"] = "0"; } param1["danhmuccha"] = json_vpp_chitiet[i]["danhmuccha"].ToString().Trim(); param1["danhmucgoc"] = json_vpp_chitiet[i]["danhmucgoc"].ToString().Trim(); param1["nguoitao"] = nguoitao; if (param1["matiepnhan_tieuchidaotao"].ToString() == "" || param1["matiepnhan_tieuchidaotao"].ToString() == "0" || param1["matiepnhan_tieuchidaotao"].ToString() == null) { sqlMap.Insert("Saudaotao.InsertRow_Saudaotao_chitiet", param1); } else { sqlMap.Update("Saudaotao.UpdateRow_Saudaotao_chitiet", param1); } } sqlMap.CommitTransaction(); } catch (Exception ex) { sqlMap.RollbackTransaction(); logger.Error(ex.Message); } logger.End("Save_ykiensaodautao"); return(matiepnhanid); }
public ActionResult Edit(string macuochop) { if (!IsLogged()) { return(BackToLogin()); } Item_weedModels param = new Item_weedModels(); DanhmucServices service = new DanhmucServices(); List <Item_weedModels> lstResult_Tuan = service.SelectRows_giaovien(param); StringBuilder sbtuan = new StringBuilder(); foreach (var item in lstResult_Tuan) { item.tentuan = item.tentuan + " " + item.tungay + " - " + item.denngay; sbtuan.Append(string.Format("<option value='{0}'>{1}</option>", item.matuan, item.tentuan)); } ViewBag.sbtuan = sbtuan.ToString(); //phong ban PhongBanModels parampb = new PhongBanModels(); List <PhongBanModels> lstResult_phongban = service.SelectRows2(parampb); StringBuilder sbphongban = new StringBuilder(); string pb = ""; string maphongban = Session["maphongban"].ToString().Trim(); if (Session["loginid"].ToString().Trim().ToLower() == "admin" || Session["grouptk"].ToString().Trim() == "1") { pb = pb + "<option value=0>Chọn phòng ban</option>"; foreach (var item in lstResult_phongban) { pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>"; } } else { foreach (var item in lstResult_phongban.Where(p => p.maphongban == maphongban)) { pb = pb + "<option value=" + item.maphongban + "> " + item.tenphongban + " </option>"; } } ViewBag.sbphongban = pb.ToString(); StringBuilder sbphonghop = new StringBuilder(); sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "0", "Lựa chọn Phòng họp")); sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "1", "Tầng 3 - Phòng họp 1")); sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "2", "Tầng 3 - Phòng họp 2")); sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "3", "Tầng 3 - Phòng họp lớn")); sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "4", "Tầng 3A - Phòng họp nhỏ")); sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "5", "Tầng 3A - Phòng họp lớn")); sbphonghop.Append(string.Format("<option value={0}>{1}</option>", "6", "Khác")); ViewBag.sbphonghop = sbphonghop.ToString(); FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); macuochop = AES.DecryptText(macuochop, function.ReadXMLGetKeyEncrypt()); DaotaoServices servicevpp = new DaotaoServices(); List <WeedMeetingModels> lstResult = new List <WeedMeetingModels>(); lstResult = servicevpp.SelectRows_WeedMeeting_hieuchinh(macuochop); if (lstResult.Count > 0) { //replace(/'/g, "daunhaydon").replace(/"/g, '').replace(/&/g, 'daukytuva') + "',"; lstResult[0].lydobuoihop = lstResult[0].lydobuoihop.Replace("daunhaydon", "'").Replace("daukytuva", "&"); lstResult[0].thanhphanthamdu = lstResult[0].thanhphanthamdu.Replace("daunhaydon", "'").Replace("daukytuva", "&"); //System.Text.RegularExpressions.Regex.Replace(json["noidungcuochop"].ToString().Trim(), @"\n", "\\n").Replace("'", ""); string chuoinoidungs = ""; string chuoinoidung = System.Text.RegularExpressions.Regex.Replace(lstResult[0].noidungcuochop, @"\\n", "\n"); string[] noisungcuochop = chuoinoidung.Split(new char[] { '\n' }); for (int i = 0; i < noisungcuochop.Length; i++) { chuoinoidungs = chuoinoidungs + noisungcuochop[i].Replace("daunhaydon", "'").Replace("daukytuva", "&") + Environment.NewLine; } lstResult[0].noidungcuochop = chuoinoidungs; return(View(lstResult[0])); } return(View()); }
public string Save_nhapkho(string DataJson, string nguoitao, string manhapkho) { logger.Start("Save_nhapkho"); string manhapkhohang = ""; try { sqlMap.BeginTransaction(); Hashtable param = new Hashtable(); JObject json = JObject.Parse(DataJson); param["sochungtu"] = json["data1"]["sochungtu"].ToString(); param["sohoadon"] = json["data1"]["sohoadon"].ToString(); param["ngaynhapchungtu"] = json["data1"]["ngaynhapchungtu"].ToString(); param["nhacungcap"] = json["data1"]["nhacungcap"].ToString(); param["tongtien"] = json["data1"]["tongtien"].ToString(); param["noidungnhaphang"] = json["data1"]["noidungnhaphang"].ToString(); param["nguoitao"] = nguoitao; if (manhapkho.Trim() == "") { param["manhapkho"] = GetSequence_All("dm_seq", "warehousing"); sqlMap.Insert("Nhapkho.Insert_Nhapkho", param); } else { param["manhapkho"] = manhapkho; sqlMap.Update("Nhapkho.UpdateRow_Nhapkho", param); sqlMap.Update("Nhapkho.DeletedRow_Nhapkho_chitiet", param); } manhapkhohang = param["manhapkho"].ToString(); Hashtable param1 = new Hashtable(); JArray json_nhapkho_chitiet = (JArray)json["data2"]; for (int i = 1; i < json_nhapkho_chitiet.Count(); i++) { param1 = new Hashtable(); param1["manhapkho"] = param["manhapkho"].ToString(); //param1["machitiet"] = GetSequence_All("dm_seq", "warehousing_detail"); string madanhmuc = json_nhapkho_chitiet[i]["mavanphongpham"].ToString(); FunctionXML function = new FunctionXML(Functions.MapPath("~/Xml/Config/encryptionkeyEncodeLink.config")); param1["mavanphongpham"] = AES.DecryptText(json_nhapkho_chitiet[i]["mavanphongpham"].ToString(), function.ReadXMLGetKeyEncrypt()); param1["tenvanphongpham"] = json_nhapkho_chitiet[i]["tenvanphongpham"].ToString(); param1["donvitinh"] = json_nhapkho_chitiet[i]["donvitinh"].ToString(); param1["soluong"] = json_nhapkho_chitiet[i]["soluong"].ToString(); param1["dongia"] = json_nhapkho_chitiet[i]["dongia"].ToString(); param1["thanhtien"] = json_nhapkho_chitiet[i]["thanhtien"].ToString(); param1["danhmuccha"] = json_nhapkho_chitiet[i]["danhmuccha"].ToString(); //param1["danhmucgoc"] = json_nhapkho_chitiet[i]["danhmucgoc"].ToString(); param1["nguoitao"] = nguoitao; sqlMap.Insert("Nhapkho.Insert_Nhapkho_chitiet", param1); } sqlMap.CommitTransaction(); } catch (Exception ex) { manhapkhohang = "-1"; sqlMap.RollbackTransaction(); logger.Error(ex.Message); } logger.End("Save_nhapkho"); return(manhapkhohang); }