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); }