public List <KeHoachForCombobox> SelectKeHoachForCombobox(KeHoachModels clParam)
{
logger.Start("SelectKeHoachForCombobox");
List <KeHoachForCombobox> lstResult = new List <KeHoachForCombobox>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
IList ilist = sqlMap.ExecuteQueryForList("cv_kehoach.SelectKeHoachForCombobox", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList <KeHoachForCombobox>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectKeHoachForCombobox");
return(lstResult);
}
public ActionResult Create(KeHoachModels model)
{
//check login
if (!IsLogged())
{
return(BackToLogin());
}
#region Set Param
M_KeHoach clParamSuKien = new M_KeHoach();
clParamSuKien.noidungmuctieu = model.noidungmuctieu;
clParamSuKien.ghichu = model.ghichu;
clParamSuKien.makehoach = makehoach;
clParamSuKien.ngaybatdau = FunctionsDateTime.ConvertDate(FunctionsDateTime.ConvertStringToDate(model.ngaybatdau));
clParamSuKien.ngayketthuc = FunctionsDateTime.ConvertDate(FunctionsDateTime.ConvertStringToDate(model.ngayketthuc));
clParamSuKien.nguoitao = Session["userid"].ToString();
clParamSuKien.nguoithuchien = model.nguoithuchien;
clParamSuKien.makehoachgoc = model.makehoachgoc;
clParamSuKien.tytrong = model.tytrong;
clParamSuKien.chitieunam = model.chitieunam;
clParamSuKien.ngaytao = "GETDATE()";
clParamSuKien.nguoihieuchinh = Session["userid"].ToString();
clParamSuKien.ngayhieuchinh = "GETDATE()";
if (GetPhongBanDonVi() != null)
{
clParamSuKien.madonvi = GetPhongBanDonVi().madonvi;
}
#endregion
KeHoachServices services = new KeHoachServices();
if (makehoach.Trim() == "")
{
services.InsertRow(clParamSuKien, Session["manhansu"].ToString());
}
else
{
services.UpdateRow(clParamSuKien);
}
makehoach = "";
return(RedirectToAction("Index", "Milestones"));
}
public KeHoachModels RowDetail(KeHoachModels clparam)
{
logger.Start("RowDetail");
KeHoachModels vbResult = new KeHoachModels();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
IList ilist = sqlMap.ExecuteQueryForList("cv_kehoach.RowDetail", param);
CastDataType cast = new CastDataType();
vbResult = cast.AdvanceCastDataToList <KeHoachModels>(ilist)[0];
}
catch (Exception ex)
{
logger.Error(ex.Message);
vbResult = new KeHoachModels();
}
logger.End("RowDetail");
return(vbResult);
}
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);
}
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));
}
