public string InsertRow(ChucDanhModels clParam)
{
logger.Start("InsertRow");
string strResult = "";
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
param["seqname"] = "seq_vb_capdouutien";
string strid = sqlMap.ExecuteQueryForObject("Common.GetNextVal", param).ToString();
param["macapdouutien"] = strid;
sqlMap.Insert("m_donvi_chucdanh.InsertRow", param);
sqlMap.CommitTransaction();
strResult = param["macapdouutien"].ToString();
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
strResult = "-1";
logger.Error(ex.Message);
}
logger.End("InsertRow");
return(strResult);
}
public bool UpdateRow_chucdanh(ChucDanhModels clParam)
{
logger.Start("UpdateRow_vanphongpham");
bool bResult = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param["machucdanh"] = clParam.machucdanh;
param["tenchucdanh"] = clParam.tenchucdanh;
param["tengiaodich"] = clParam.tengiaodich;
param["ghichu"] = clParam.ghichu;
param["xoa"] = "0";
param["nguoihieuchinh"] = clParam.nguoihieuchinh;
sqlMap.Update("Danhmuc.UpdateRow_chucdanh", param);
sqlMap.CommitTransaction();
bResult = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
bResult = false;
logger.Error(ex.Message);
}
logger.End("UpdateRow_vanphongpham");
return(bResult);
}
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"));
}
//Chức danh
public string InsertRow_chucdanh(ChucDanhModels clParam)
{
logger.Start("InsertRow_chucdanh");
string strResult = "";
try
{
Hashtable param = new Hashtable();
strResult = GetSequence_All("dm_seq", "m_donvi_chucdanh");
clParam.machucdanh = int.Parse(strResult);
base.InsertData(clParam, "m_donvi_chucdanh");
}
catch (Exception ex)
{
strResult = "-1";
logger.Error(ex.Message);
}
logger.End("InsertRow_chucdanh");
return strResult;
}
public List<ChucDanhModels> SelectRows_danhmucchucdanh(ChucDanhModels clParam)
{
logger.Start("SelectRows_danhmucchucdanh");
List<ChucDanhModels> lstResult = new List<ChucDanhModels>();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
IList ilist = sqlMap.ExecuteQueryForList("Danhmuc.SelectRows_danhmucchucdanh", param);
CastDataType cast = new CastDataType();
lstResult = cast.AdvanceCastDataToList<ChucDanhModels>(ilist);
}
catch (Exception ex)
{
logger.Error("Loi ---> " + ex.Message);
}
logger.End("SelectRows_danhmucchucdanh");
return lstResult;
}
public int CountRows(ChucDanhModels clparam)
{
logger.Start("CountRows");
int iResult = 0;
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
iResult = (int)sqlMap.ExecuteQueryForObject("m_donvi_chucdanh.CountRows", param);
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
iResult = 0;
logger.Error(ex.Message);
}
logger.End("CountRows");
return(iResult);
}
public ChucDanhModels RowDetail(ChucDanhModels clparam)
{
logger.Start("RowDetail");
ChucDanhModels vbResult = new ChucDanhModels();
try
{
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clparam);
IList ilist = sqlMap.ExecuteQueryForList("m_donvi_chucdanh.RowDetail", param);
CastDataType cast = new CastDataType();
vbResult = cast.AdvanceCastDataToList <ChucDanhModels>(ilist)[0];
}
catch (Exception ex)
{
logger.Error(ex.Message);
vbResult = new ChucDanhModels();
}
logger.End("RowDetail");
return(vbResult);
}
public JsonResult SelectRows_chucvu(ChucDanhModels model)
{
ChucDanhModels param = new ChucDanhModels();
DanhmucServices service = new DanhmucServices();
List <ChucDanhModels> lstResult = service.SelectRows_chucvu(param);
StringBuilder sbResult = new StringBuilder();
StringBuilder sbRows = new StringBuilder();
if (lstResult.Count > 0)
{
string strSTT = "";
int i = 1;
foreach (var item in lstResult)
{
strSTT = i.ToString();
sbRows.Append(PrepareDataJson_chucvu(item, strSTT));
i++;
}
if (sbRows.Length > 0)
{
sbRows.Remove(sbRows.Length - 1, 1);
}
}
sbResult.Append("{");
sbResult.Append("\"isHeader\":\"" + "111" + "\",");
sbResult.Append("\"currentRow\":\"" + lstResult.Count + "\",");
sbResult.Append("\"Pages\":\"" + lstResult.Count + "\",");
if (model.machucdanh.ToString() != "0")
{
sbResult.Append("\"SubRow\":\"" + "true" + "\",");
sbResult.Append("\"RowID\":\"" + model.machucdanh + "\",");
}
sbResult.Append("\"data\":[" + sbRows.ToString() + "]");
sbResult.Append("}");
return(Json(sbResult.ToString(), JsonRequestBehavior.AllowGet));
}
public bool DeleteRows_chucdanh(ChucDanhModels clParam)
{
logger.Start("DeleteRows_chucdanh");
bool lstResult = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = new Hashtable();
param["machucdanh"] = clParam.machucdanh;
param["nguoihieuchinh"] = clParam.nguoihieuchinh;
sqlMap.Update("Danhmuc.DeleteRow_chucdanh", param);
sqlMap.CommitTransaction();
lstResult = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
logger.Error(ex.Message);
}
logger.End("DeleteRows_chucdanh");
return lstResult;
}
public bool UpdateRow(ChucDanhModels clParam)
{
logger.Start("UpdateRow");
bool bResult = false;
try
{
sqlMap.BeginTransaction();
Hashtable param = new Hashtable();
param = base.SetDataToHashtable(false, clParam);
sqlMap.Update("m_donvi_chucdanh.UpdateRow", param);
sqlMap.CommitTransaction();
bResult = true;
}
catch (Exception ex)
{
sqlMap.RollbackTransaction();
bResult = false;
logger.Error(ex.Message);
}
logger.End("UpdateRow");
return(bResult);
}
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);
}
