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));
}
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(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());
}
//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 MenuHeaderLink()
{
if (!IsLogged())
{
return(BackToLogin());
}
//lay danh sach phan quyen
LoginServices service = new LoginServices();
FunctionXML fnc = new FunctionXML(Functions.MapPath("~/xml/Config/sitemap.config"));
List <MenuLinks> model = fnc.ReadMenuConfig(service.GetRoles(new TaiKhoanModels()
{
mataikhoan = Session["userid"].ToString()
}), base.isAdmin, Session["grouptk"].ToString(), Session["phongban_congtruong"].ToString());
return(PartialView(model));
}
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);
}
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);
}
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);
}
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());
}
private StringBuilder PrepareDataJson_DanhSachTaiKhoan(TaiKhoanModels model, int couter)
{
StringBuilder sbResult = new StringBuilder();
try
{
sbResult.Append("{");
sbResult.Append("\"col_class\":\"rows-box\",");
sbResult.Append("\"col_id\":\"" + model.mataikhoan + "\",");
sbResult.Append("\"col_value\":[");
#region Data cell
//colum checkbox
string strHTML_Checkbox = string.Format("<input type='checkbox' onclick='Select(this);' class='chkCheck' codeid='{0}'/>", model.mataikhoan);
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("},");
//tinh trang
FunctionXML fnc = new FunctionXML(Functions.MapPath("~/Xml/Const/Default.xml"));
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col3\",");
sbResult.Append("\"col_id\":\"3\",");
sbResult.Append("\"title\":\"" + model.tinhtrang.Trim() + "\",");
sbResult.Append("\"col_value\":\"" + fnc.ReadConst("kichhoat", int.Parse(model.tinhtrang)) + "\"");
sbResult.Append("},");
//noi dung
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col4\",");
sbResult.Append("\"col_id\":\"4\",");
sbResult.Append("\"title\":\"" + model.grouptk + "\",");
sbResult.Append("\"col_value\":\"" + model.tendangnhap + "\"");
sbResult.Append("},");
//ten dang nhap
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col5\",");
sbResult.Append("\"col_id\":\"5\",");
sbResult.Append("\"title\":\"" + model.grouptk + "\",");
sbResult.Append("\"col_value\":\"" + model.hoten + "\"");
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.thudientu + "\"");
sbResult.Append("},");
//phong ban
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col7\",");
sbResult.Append("\"col_id\":\"7\",");
sbResult.Append("\"title\":\"" + model.maphongban.Trim() + "\",");
sbResult.Append("\"col_value\":\"" + model.tenphongban + "\"");
sbResult.Append("},");
//chucdanh
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col11\",");
sbResult.Append("\"col_id\":\"11\",");
sbResult.Append("\"title\":\"" + model.macongtruong.Trim() + "\",");
sbResult.Append("\"col_value\":\"" + model.tencongtruong + "\"");
sbResult.Append("},");
//chucdanh
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col12\",");
sbResult.Append("\"col_id\":\"12\",");
sbResult.Append("\"title\":\"" + model.loaicuochop + "\",");
if (model.loaicuochop == 1)
{
sbResult.Append("\"col_value\":\"" + "Trưởng PB/CT" + "\"");
}
else if (model.loaicuochop == 2)
{
sbResult.Append("\"col_value\":\"" + "Thiết Bị" + "\"");
}
else if (model.loaicuochop == 3)
{
sbResult.Append("\"col_value\":\"" + "HSSE" + "\"");
}
else if (model.loaicuochop == 4)
{
sbResult.Append("\"col_value\":\"" + "QAQC" + "\"");
}
else if (model.loaicuochop == 5)
{
sbResult.Append("\"col_value\":\"" + "MEP" + "\"");
}
else
{
sbResult.Append("\"col_value\":\"" + "Khác" + "\"");
}
sbResult.Append("},");
//chucdanh
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col8\",");
sbResult.Append("\"col_id\":\"8\",");
sbResult.Append("\"title\":\"" + model.chucdanhkpi + "\",");
sbResult.Append("\"col_value\":\"" + model.tenchucdanhkpi + "\"");
sbResult.Append("},");
//chucdanh
sbResult.Append("{");
sbResult.Append("\"colspan\":\"1\",");
sbResult.Append("\"col_class\":\"ovh col9\",");
sbResult.Append("\"col_id\":\"9\",");
sbResult.Append("\"title\":\"" + model.madonvi + "\",");
sbResult.Append("\"col_value\":\"" + model.tendonvi + "\"");
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("}");
////chucdanh
//sbResult.Append("{");
//sbResult.Append("\"colspan\":\"1\",");
//sbResult.Append("\"col_class\":\"ovh col11\",");
//sbResult.Append("\"col_id\":\"11\",");
//sbResult.Append("\"type\":\"hidden\",");
//sbResult.Append("\"col_value\":\"" + model.mataikhoan + "\"");
//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);
}
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_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 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);
}
