public IActionResult InsertCoQuan([FromBody] CoQuan coQuan) { //CoQuan coQuan = new CoQuan(); //coQuan.TinhID =Convert.ToInt32(cQ.TinhID); //coQuan.HuyenID = Convert.ToInt32(cQ.HuyenID); //coQuan.XaPhuongID = Convert.ToInt32(cQ.XaPhuongID); //coQuan.TenCoQuan = Convert.ToString(cQ.TenCoQuan); //coQuan.LoaiCoQuanID = Convert.ToInt32(cQ.LoaiCoQuanID); return(Ok(coQuanBUS.InssertCoQuan(coQuan))); }
public ActionResult ThemMoi(int?Id) { CoQuanService _coQuan = new CoQuanService(); CoQuan coQuan = new CoQuan(); if (Id.HasValue) { coQuan = _coQuan.FindByKey(Id); } return(View(coQuan)); }
public frmCoQuanAdd(CoQuan obj = null) { InitializeComponent(); _baseService = new BaseService <CoQuan>(); _obj = obj; if (obj != null) { txtID.Text = obj.ID.ToString(); txtMa.Text = obj.Ma; txtTen.Text = obj.Ten; txtDiaChi.Text = obj.DiaChi; } }
public ReturnResult <CoQuan> InsertCoQuan(CoQuan coQuan) { DbProvider provider = new DbProvider(); var result = new ReturnResult <CoQuan>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; try { provider.SetQuery("[Organ_INSERT]", CommandType.StoredProcedure) .SetParameter("OrganCode", SqlDbType.NVarChar, coQuan.OrganCode) .SetParameter("TenCoQuan", SqlDbType.NVarChar, coQuan.TenCoQuan) .SetParameter("TinhID", SqlDbType.Int, coQuan.TinhID, ParameterDirection.Input) .SetParameter("HuyenID", SqlDbType.Int, coQuan.HuyenID, ParameterDirection.Input) .SetParameter("XaPhuongID", SqlDbType.Int, coQuan.XaPhuongID, ParameterDirection.Input) .SetParameter("LoaiCoQuan", SqlDbType.Int, coQuan.LoaiCoQuanID, ParameterDirection.Input) .SetParameter("CreateBy", SqlDbType.VarChar, coQuan.CreateBy, 50) .SetParameter("Description", SqlDbType.NVarChar, coQuan.Description, 1000) .SetParameter("Notes", SqlDbType.NVarChar, coQuan.Notes, 1000) .SetParameter("AddressDetail", SqlDbType.NVarChar, coQuan.AddressDetail, 500) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .ExcuteNonQuery() .Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.Failed(outCode, outMessage); } else { result.Item = coQuan; result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
/// <summary> /// cập nhật cơ quan /// </summary> /// <param name="coQuan"></param> /// <returns></returns> public ReturnResult <CoQuan> UpdateCoQuan(CoQuan coQuan) { ReturnResult <CoQuan> result = new ReturnResult <CoQuan>();; DbProvider db; try { db = new DbProvider(); db.SetQuery("Organ_EDIT", CommandType.StoredProcedure); db.SetParameter("CoQuanID", SqlDbType.Int, coQuan.CoQuanID); db.SetParameter("OrganCode", SqlDbType.NVarChar, coQuan.OrganCode); db.SetParameter("DiaChiID", SqlDbType.Int, coQuan.DiaChiID); db.SetParameter("TenCoQuan", SqlDbType.NVarChar, coQuan.TenCoQuan, 500); db.SetParameter("LoaiCoQuan", SqlDbType.Int, coQuan.LoaiCoQuanID); db.SetParameter("AddressDetail", SqlDbType.NVarChar, coQuan.AddressDetail, 500); db.SetParameter("TinhID", SqlDbType.Int, coQuan.TinhID); db.SetParameter("HuyenID", SqlDbType.Int, coQuan.HuyenID); db.SetParameter("XaPhuongID", SqlDbType.Int, coQuan.XaPhuongID); db.SetParameter("UpdatedBy", SqlDbType.NVarChar, coQuan.UpdatedBy, 50); db.SetParameter("Description", SqlDbType.NVarChar, coQuan.Description, 1000); db.SetParameter("Notes", SqlDbType.NVarChar, coQuan.Notes, 1000); db.SetParameter("ErrorCode", SqlDbType.Int, DBNull.Value, ParameterDirection.Output); db.SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output); db.ExcuteNonQuery(); db.Complete(); db.GetOutValue("ErrorCode", out string errorCode); db.GetOutValue("ErrorMessage", out string errorMessage); if (errorCode.ToString() == "0") { result.ErrorCode = "0"; result.ErrorMessage = ""; } else { result.Failed(errorCode, errorMessage); } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
private void InitNhanXet(CoQuan coQuan, ComboBox cboNhanXet) { Result result = NhanXetKhamLamSangBus.GetNhanXetKhamLamSangist((int)coQuan); if (!result.IsOK) { MsgBox.Show(this.Text, result.GetErrorAsString("NhanXetKhamLamSangBus.GetNhanXetKhamLamSangist"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("NhanXetKhamLamSangBus.GetNhanXetKhamLamSangist")); return; } else { DataTable dtNhanXet = result.QueryResult as DataTable; DataRow newRow = dtNhanXet.NewRow(); newRow["NhanXetKhamLamSangGUID"] = Guid.Empty; newRow["NhanXet"] = string.Empty; dtNhanXet.Rows.InsertAt(newRow, 0); cboNhanXet.DataSource = dtNhanXet; } }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public ReturnResult <CoQuan> GetCoQuanById(int id) { DbProvider provider = new DbProvider(); var result = new ReturnResult <CoQuan>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; CoQuan item = new CoQuan(); try { provider.SetQuery("COQUAN_GET_BY_ID", CommandType.StoredProcedure) .SetParameter("CoQuanID", SqlDbType.Int, id, ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, ParameterDirection.Output) .GetSingle <CoQuan>(out item).Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0" || outCode == "") { result.ErrorCode = outCode; result.ErrorMessage = outMessage; } else { result.Item = item; result.ErrorCode = outCode; result.ErrorMessage = outMessage; } } catch (Exception ex) { result.Failed("-1", ex.Message); } return(result); }
private void btnEdit_Click(object sender, EventArgs e) { var x = gridView1.GetSelectedRows(); if (x.Length > 1) { MessageBox.Show("Bạn chọn quá nhiều dòng", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (x.Length <= 0) { MessageBox.Show("Bạn chưa chọn dòng nào", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { int IDObj = int.Parse(gridView1.GetRowCellValue(x[0], "ID").ToString()); CoQuan obj = new CoQuan(); obj = _baseService.GetByID(IDObj); frmCoQuanAdd frm = new frmCoQuanAdd(obj); frm.ShowDialog(); getList(); } }
public ReturnResult <CoQuan> DeleteCoQuan(int id) { DbProvider provider = new DbProvider(); var result = new ReturnResult <CoQuan>(); string outCode = String.Empty; string outMessage = String.Empty; string totalRecords = String.Empty; CoQuan item = new CoQuan(); try { provider.SetQuery("COQUAN_DELETE", CommandType.StoredProcedure) .SetParameter("CoQuanID", SqlDbType.Int, id, System.Data.ParameterDirection.Input) .SetParameter("ErrorCode", SqlDbType.NVarChar, DBNull.Value, 100, System.Data.ParameterDirection.Output) .SetParameter("ErrorMessage", SqlDbType.NVarChar, DBNull.Value, 4000, System.Data.ParameterDirection.Output) .ExcuteNonQuery().Complete(); provider.GetOutValue("ErrorCode", out outCode) .GetOutValue("ErrorMessage", out outMessage); if (outCode != "0") { result.Failed(outCode, outMessage); } else { result.ErrorCode = "0"; result.ErrorMessage = ""; } } catch (Exception ex) { throw ex; } return(result); }
protected override void Render(HtmlTextWriter writer) { StringBuilder sb = new StringBuilder(); ClientScriptManager cs = this.Page.ClientScript; #region các dữ liệu yêu cầu từ client string _ID = Request["ID"]; string _PID = Request["PID"]; string _Ten = Request["Ten"]; string _Mota = Request["Mota"]; string _ThuTu = Request["ThuTu"]; string _CQ_ID = Request["CQ_ID"]; string _UpdateList = Request["UpdateList"]; #endregion switch (subAct) { case "get": #region lấy dữ liệu cho grid List<CoQuan> ListCq = getTree(CoQuanDal.TreeByUsername(Security.Username, Request["q"])); List<jgridRow> ListRow = new List<jgridRow>(); foreach (CoQuan cq in ListCq) { ListRow.Add(new jgridRow(cq.Id.ToString(), new string[] { cq.Id.ToString() , cq.ThuTu.ToString() , cq.Ma , cq.Ten ,cq.MoTa , cq.NguoiTao , string.Format("{0} {1:dd-MM-yy}/{2} {3:dd/MM/yy}" ,cq.NguoiTao,cq.NgayTao,cq.NguoiCapNhat,cq.NgayCapNhat) ,cq.NSD.ToString() , cq.Level.ToString(), cq.PID.ToString(), "true", "false" })); } jgrid grid = new jgrid("1", "1", ListCq.Count.ToString(), ListRow); sb.Append(JavaScriptConvert.SerializeObject(grid)); break; #endregion case "getPid": #region lấy toàn bộ danh mục CoQuanCollection ListCqGetList = CoQuanDal.TreeByUsername(Security.Username,Request["q"]); sb.Append(JavaScriptConvert.SerializeObject(ListCqGetList)); break; #endregion case "del": #region xóa if (!string.IsNullOrEmpty(_ID)) { CoQuanDal.DeleteById(Convert.ToInt32(_ID)); } break; #endregion case "new": break; case "edit": #region edit if (!string.IsNullOrEmpty(_ID)) { sb.Append(JavaScriptConvert.SerializeObject(CoQuanDal.SelectById(Convert.ToInt32(_ID)))); } break; #endregion case "save": #region lưu CoQuan ItemSave = new CoQuan(); if (!string.IsNullOrEmpty(_ID)) { ItemSave = CoQuanDal.SelectById(Convert.ToInt32(_ID)); } int ThuTu = 0; if (!string.IsNullOrEmpty(_ThuTu)) { ThuTu = Convert.ToInt32(_ThuTu); } ItemSave.ThuTu = ThuTu; ItemSave.Ten = _Ten; ItemSave.MoTa = _Mota; ItemSave.PID = string.IsNullOrEmpty(_PID) ? 0 : Convert.ToInt32(_PID); ItemSave.NgayCapNhat = DateTime.Now; if (!string.IsNullOrEmpty(_ID)) { ItemSave = CoQuanDal.Update(ItemSave); } else { ItemSave.NguoiTao = Security.Username; ItemSave.RowId = Guid.NewGuid(); ItemSave.NgayTao = DateTime.Now; ItemSave.Level = 0; ItemSave.PIDList = string.Empty; ItemSave = CoQuanDal.Insert(ItemSave); } sb.Append("1"); break; #endregion case "getFunction": #region lấy quyền theo cq_id FunctionCollection ListGetFunction = FunctionDal.SelectAllByCqID(_CQ_ID); sb.Append(getTop(ListGetFunction)); break; #endregion case "upadteFunction": #region Lưu phân tính năng sb.Append(CoQuanFunctionDal.UpdateByUpdateListAndCQID(_CQ_ID, _UpdateList, Security.Username)); break; #endregion default: #region mặc định - trả về module ban đầu //<input type=""text"" class=""mdl-head-txt mdl-head-search"" /> FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId); sb.Append(@"<div class=""mdl-head""> <span class=""mdl-head-searchPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-coQuanSuper"" /> </span> <a class=""mdl-head-btn mdl-head-add"" id=""coquanSuperMdl-addBtn"" href=""javascript:coquanSuper.add();"">Thêm</a> <a class=""mdl-head-btn mdl-head-edit"" id=""coquanSuperMdl-editBtn"" href=""javascript:coquanSuper.edit();"">Sửa</a> <a class=""mdl-head-btn mdl-head-del"" id=""coquanSuperMdl-delBtn"" href=""javascript:coquanSuper.del();"">Xóa</a> </div> <table id=""coquanSupermdl-List"" class=""mdl-list""> </table> <div id=""coquanSuperMdl-Pager""></div> <div class=""sub-mdl""> <ul> <li> <a id=""coquanSuperMdl-functionmdl-subMdlBtn"" href=""#coquanSuperMdl-SubMdl-Mdl1"">Tính năng</a> </li> </ul> <div id=""coquanSuperMdl-SubMdl-Mdl1""> <div id=""coquanSuperMdl-functionmdl-coQuanFnMdl""> </div> </div> </div>"); sb.AppendFormat(@"<script src=""{0}"" type=""text/javascript""></script>" , cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.hethong.coquan.super.JScript1.js")); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn)); break; #endregion } writer.Write(sb.ToString()); base.Render(writer); }
public IActionResult UpdateCoQuan(CoQuan coQuan) { return(Ok(coQuanBUS.UpdateCoQuan(coQuan))); }
protected override void Render(HtmlTextWriter writer) { StringBuilder sb = new StringBuilder(); ClientScriptManager cs = this.Page.ClientScript; #region Tham số string _ID = Request["ID"]; string _CQ_ID = Request["CQ_ID"]; string _Username = Request["Username"]; string _Password = Request["Password"]; string _Pwd = Request["Pwd"]; string _Ten = Request["Ten"]; string _Khoa = Request["Khoa"]; string _Luong = Request["Luong"]; string _q = Request["q"]; string _Anh = Request["Anh"]; string _Loai = Request["Loai"]; string _ThuKy = Request["ThuKy"]; string _refUsername = Request["refUsername"]; string _Email = Request["Email"]; string _Captcha = Request["Captcha"]; string _Mobile = Request["Mobile"]; string _DiaChi = Request["DiaChi"]; string _MoTa = Request["MoTa"]; string _Loai_Ten = Request["Loai_Ten"]; string _CQ_Ma = Request["CQ_Ma"]; string TVDV_ID = Request["TVDV_ID"]; string _Lang = Request["Lang"]; #endregion //if (!Security.IsAuthenticated()) //{ // Response.End(); //} switch (subAct) { case "get": #region lấy danh sách if (string.IsNullOrEmpty(jgrsidx)) { jgrsidx = "ID"; } if (string.IsNullOrEmpty(jgrsord)) { jgrsord = "asc"; } Pager <Member> PagerGet = MemberDal.pagerAllChildByUsername("", false, "MEM_" + jgrsidx + " " + jgrsord, Security.Username, _CQ_ID, _q, Request["rows"]); List <jgridRow> ListRow = new List <jgridRow>(); foreach (Member item in PagerGet.List) { ListRow.Add(new jgridRow(item.ID.ToString(), new string[] { item.ID.ToString() , item.Ten , item._CoQuan.Ten , item.Loai_Ten , item.Email , item.Mobile , item.Username , item.Password.Length > 2 ? item.Password.Substring(0, item.Password.Length - 2) : "" , item.Active.ToString() , item.NguoiTao })); } jgrid grid = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage, PagerGet.TotalPages.ToString(), PagerGet.Total.ToString(), ListRow); sb.Append(JavaScriptConvert.SerializeObject(grid)); break; #endregion case "getpid": #region lấy danh sách cho autocomplete Pager <Member> PagerGetPid = MemberDal.pagerAllChildByUsername("", true, null, string.IsNullOrEmpty(Security.Username) ? "sspa" : Security.Username, null, _q, "20"); sb.Append(JavaScriptConvert.SerializeObject(PagerGetPid.List)); break; #endregion case "GetLamDichVuList": #region lấy danh sách cho autocomplete var listLamDichVu = MemberDal.SelectLamDichVu(TVDV_ID, "sspa"); sb.Append(JavaScriptConvert.SerializeObject(listLamDichVu)); break; #endregion case "getpuse": #region lấy danh sách cho autocomplete Pager <Member> PagerGetPues = MemberDal.pagerAllByUsername("", true, null, Security.Username, null, _q, "20"); sb.Append(JavaScriptConvert.SerializeObject(PagerGetPues.List)); break; #endregion case "SelectByNodeAndWfId": #region lấy danh sách cho autocomplete string Username = Security.Username; //if (Request["WF_ID"] == "4" && string.IsNullOrEmpty(Request["NODE_ID"])) //{ // sb.Append(JavaScriptConvert.SerializeObject(MemberDal.SelectLanhDaoByCQMa("1"))); //} //else //{ // if (!string.IsNullOrEmpty(_CQ_ID)) // { // MemberCollection mem = MemberDal.SelectLanhDaoByCQMa(_CQ_ID); // foreach (Member m in mem) // { // Username = m.Username; // break; // } // } sb.Append(JavaScriptConvert.SerializeObject(MemberDal.SelectByNodeAndWfId(Request["NODE_ID"], Request["WF_ID"], _q, "20", Username))); //} break; #endregion case "del": #region xóa MemberDal.DeleteByIdList(Request["ID"]); break; #endregion case "edit": #region chỉnh sửa if (!string.IsNullOrEmpty(_ID)) { sb.Append("(" + JavaScriptConvert.SerializeObject(MemberDal.SelectById(Convert.ToInt32(_ID))) + ")"); } break; #endregion case "editX": #region editX if (!string.IsNullOrEmpty(_ID)) { sb.Append(MemberDal.SelectById(Convert.ToInt32(_ID)).Loai.ToString()); } break; #endregion case "save": #region lưu Member ItemSave = new Member(); if (string.IsNullOrEmpty(_Username)) { sb.Append("0"); break; } if (!string.IsNullOrEmpty(_ID)) { ItemSave = MemberDal.SelectById(Convert.ToInt32(_ID)); } else { if (MemberDal.ValidEmailUsername(_Email, _Username) != "-1" || MemberDal.ValidEmailUsername(_Email, _Username) != (string.IsNullOrEmpty(_ID) ? "-1" : _ID)) { sb.Append("0"); break; } } ItemSave.Luong = Convert.ToDouble(_Luong); ItemSave.Anh = _Anh; ItemSave.CQ_ID = Convert.ToInt32(_CQ_ID); ItemSave.DiaChi = string.Empty; ItemSave.Email = _Email; ItemSave.Ho = string.Empty; ItemSave.Khoa = Convert.ToBoolean(_Khoa); ItemSave.Loai = Convert.ToInt32("0"); ItemSave.Mobile = _Mobile; ItemSave.Mota = string.Empty; ItemSave.NgayCapNhat = DateTime.Now; ItemSave.NguoiTao = Security.Username; ItemSave.RefUsername = _refUsername; ItemSave.Ten = _Ten; ItemSave.Loai_Ten = _Loai_Ten; ItemSave.ThuKy = Convert.ToBoolean(_ThuKy); ItemSave.XacNhan = false; if (!string.IsNullOrEmpty(_ID)) { if (!string.IsNullOrEmpty(_Password)) { //ItemSave.Password = maHoa.EncryptString(_Password, _Username); ItemSave.Password = maHoa.MD5Encrypt(_Password); } ItemSave = MemberDal.Update(ItemSave); } else { ItemSave.NgayTao = DateTime.Now; //ItemSave.Password = maHoa.EncryptString(_Password, _Username); ItemSave.Password = maHoa.MD5Encrypt(_Password); ItemSave.RowId = Guid.NewGuid(); ItemSave.Username = _Username; ItemSave = MemberDal.Insert(ItemSave); } sb.Append("1"); break; #endregion case "sendmail": #region gửi email if (!string.IsNullOrEmpty(_Email)) { string[] _email = _Email.Split(new char[] { ',' }); sendEmailDelegate _send = new sendEmailDelegate(sendMail); //_send.BeginInvoke(_email, _Ten, _MoTa, null, null); sb.Append("1"); } else { sb.Append("0"); } break; #endregion case "getRoles": #region lấy quyền của thành viên if (!string.IsNullOrEmpty(_Username)) { sb.AppendFormat(getRoleByUsername(_Username)); } break; #endregion case "saveRoles": #region lưu quyền if (!string.IsNullOrEmpty(_Username)) { string roleList = Request["roleList"]; if (!string.IsNullOrEmpty(roleList)) { MemberRoleDal.UpdateRoleListUsername(roleList, _Username); } } break; #endregion case "SelectLanhDaoByCQID": #region lấy lãnh đạo theo cơ quan if (!string.IsNullOrEmpty(_CQ_ID)) { MemberCollection PG = MemberDal.SelectLanhDaoByCQID(_CQ_ID); sb.Append(JavaScriptConvert.SerializeObject(PG)); } break; #endregion case "SelectLanhDaoVanBanDi": #region lấy lãnh đạo theo cơ quan MemberCollection _SelectLanhDaoVanBanDi = MemberDal.SelectLanhDaoVanBanDi(); sb.Append(JavaScriptConvert.SerializeObject(_SelectLanhDaoVanBanDi)); break; #endregion case "SelectLanhDaoByMaCQ": #region tim lanh dao theo ma co quan MemberCollection _SelectLanhDaoByMaCoQuan = MemberDal.SelectLanhDaoByCQMa(_CQ_Ma); sb.Append(JavaScriptConvert.SerializeObject(_SelectLanhDaoByMaCoQuan)); break; #endregion case "ValidateEmail": #region tim lanh dao theo ma co quan if (!string.IsNullOrEmpty(_Email)) { if (MemberDal.ValidEmail(_Email)) { sb.Append("1"); } else { sb.Append("0"); } } break; #endregion case "ValidateCaptcha": #region tim lanh dao theo ma co quan if (!string.IsNullOrEmpty(_Captcha)) { if (Session["capcha"] != null) { if (Session["capcha"].ToString() == _Captcha) { sb.Append("1"); } else { sb.Append("0"); } } else { sb.Append("0"); } } else { sb.Append("0"); } break; #endregion case "cungDonVi": #region cungDonVi : Lấy thành viên cùng đơn vị sb.Append(JavaScriptConvert.SerializeObject(MemberDal.SelectCungDonVi(Security.Username))); break; #endregion case "dangKyCaNhan": #region dangKyCaNhan using (SqlConnection con = DAL.con()) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { CoQuan ItemCq = CoQuanDal.SelectByMa(tran, "RAOVAT"); //Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.EncryptString(_Pwd, _Email)); Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.MD5Encrypt(_Password)); MemberRole ItemMR = MemberRoleDal.InsertDangKyCaNhan(tran, ItemCq.ID, _Email); Security.Login(_Email, "true"); sb.Append("1"); tran.Commit(); } catch (Exception ex) { tran.Rollback(); Security.LogOut(); sb.Append(ex.ToString()); } finally { con.Close(); } } break; #endregion case "dangKyGh": #region dangKyGh using (SqlConnection con = DAL.con()) { con.Open(); SqlTransaction tran = con.BeginTransaction(); try { CoQuan ItemCqP = CoQuanDal.SelectByMa(tran, "GIANHANG"); CoQuan ItemCq = CoQuanDal.Insert(tran, ItemCqP.ID, _Ten, _Email); //Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.EncryptString(_Pwd, _Email)); Member ItemMe = MemberDal.Insert(tran, ItemCq.ID, _Ten, _Email, _Mobile, _DiaChi, maHoa.MD5Encrypt(_Pwd)); MemberRoleDal.InsertDangKyGianHang(tran, ItemCq.ID, _Email, _Ten, _Lang); //LienHe itemLH = LienHeDal.InsertLH(tran, ItemMe.RowId.ToString()); Security.Login(_Email, "true"); sb.Append("1"); tran.Commit(); } catch (Exception ex) { tran.Rollback(); Security.LogOut(); sb.Append(ex.ToString()); } finally { con.Close(); } } break; #endregion case "scpt": #region Nạp js sb.AppendFormat(@"{0}" , cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.hethong.thanhvien.JScript1.js")); break; #endregion default: //Session["capcha"] #region nạp FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId); sb.Append(@"<div class=""mdl-head""> <span class=""mdl-head-searchPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-thanhvien"" /> </span> <a class=""mdl-head-btn mdl-head-add"" id=""thanhvienmdl-addBtn"" href=""javascript:thanhvien.add();"">Thêm</a> <a class=""mdl-head-btn mdl-head-edit"" id=""thanhvienmdl-editBtn"" href=""javascript:thanhvien.edit();"">Sửa</a> <a class=""mdl-head-btn mdl-head-del"" id=""thanhvienmdl-delBtn"" href=""javascript:thanhvien.del();"">Xóa</a> <a class=""mdl-head-btn mdl-head-sendmail"" id=""thanhvienmdl-emailBtn"" href=""javascript:thanhvien.sendmail();"">Email</a> <a class=""mdl-head-btn mdl-head-resetPwd"" id=""thanhvienmdl-reSendPwdBtn"" href=""javascript:thanhvien.resendPwd();"">Cấp mật khẩu</a> <span class=""mdl-head-filterPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" _value="""" class=""mdl-head-filter mdl-head-filterThanhVienByCQID""/> </span> </div> <table id=""thanhvienmdl-List"" class=""mdl-list""> </table> <div id=""thanhvienmdl-Pager""></div><div class=""sub-mdl""><ul><li><a id=""thanhvienmdl-rolemdl-subMdlBtn"" href=""#mdl-1"">Quyền</a></li></ul><div id=""mdl-1""> <div class=""sub-mdl-list"" id=""thanhvienmdl-rolemdl-mdl""></div> </div></div>"); sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>" , cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.hethong.thanhvien.JScript1.js") , "{thanhvien.loadgrid();}"); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn)); break; #endregion } writer.Write(sb.ToString()); base.Render(writer); }
public ReturnResult <CoQuan> UpdateCoQuan(CoQuan coQuan) { return(coQuanDAL.UpdateCoQuan(coQuan)); }
public ReturnResult <CoQuan> InssertCoQuan(CoQuan coQuan) { return(coQuanDAL.InsertCoQuan(coQuan)); }
protected override void Render(HtmlTextWriter writer) { StringBuilder sb = new StringBuilder(); ClientScriptManager cs = this.Page.ClientScript; #region các dữ liệu yêu cầu từ client string _ID = Request["ID"]; string _PID = Request["PID"]; string _Ten = Request["Ten"]; string _Mota = Request["Mota"]; string _ThuTu = Request["ThuTu"]; string _CQ_ID = Request["CQ_ID"]; string _UpdateList = Request["UpdateList"]; #endregion switch (subAct) { case "get": #region lấy dữ liệu cho grid List <CoQuan> ListCq = getTree(CoQuanDal.TreeByUsername(Security.Username, Request["q"])); List <jgridRow> ListRow = new List <jgridRow>(); foreach (CoQuan cq in ListCq) { ListRow.Add(new jgridRow(cq.ID.ToString(), new string[] { cq.ID.ToString() , cq.ThuTu.ToString() , cq.Ma , cq.Ten , cq.MoTa , cq.NguoiTao , string.Format("{0} {1:dd-MM-yy}/{2} {3:dd/MM/yy}" , cq.NguoiTao, cq.NgayTao, cq.NguoiCapNhat, cq.NgayCapNhat) , cq.NSD.ToString() , cq.Level.ToString(), cq.PID.ToString(), "true", "false" })); } jgrid grid = new jgrid("1", "1", ListCq.Count.ToString(), ListRow); sb.Append(JavaScriptConvert.SerializeObject(grid)); break; #endregion case "getPid": #region lấy toàn bộ danh mục CoQuanCollection ListCqGetList = CoQuanDal.TreeByUsername(Security.Username, Request["q"]); sb.Append(JavaScriptConvert.SerializeObject(ListCqGetList)); break; #endregion case "del": #region xóa if (!string.IsNullOrEmpty(_ID)) { CoQuanDal.DeleteById(Convert.ToInt32(_ID)); } break; #endregion case "new": break; case "edit": #region edit if (!string.IsNullOrEmpty(_ID)) { sb.Append(JavaScriptConvert.SerializeObject(CoQuanDal.SelectById(Convert.ToInt32(_ID)))); } break; #endregion case "save": #region lưu CoQuan ItemSave = new CoQuan(); if (!string.IsNullOrEmpty(_ID)) { ItemSave = CoQuanDal.SelectById(Convert.ToInt32(_ID)); } int ThuTu = 0; if (!string.IsNullOrEmpty(_ThuTu)) { ThuTu = Convert.ToInt32(_ThuTu); } ItemSave.ThuTu = ThuTu; ItemSave.Ten = _Ten; ItemSave.MoTa = _Mota; ItemSave.PID = string.IsNullOrEmpty(_PID) ? 0 : Convert.ToInt32(_PID); ItemSave.NgayCapNhat = DateTime.Now; if (!string.IsNullOrEmpty(_ID)) { ItemSave = CoQuanDal.Update(ItemSave); } else { ItemSave.NguoiTao = Security.Username; ItemSave.RowId = Guid.NewGuid(); ItemSave.NgayTao = DateTime.Now; ItemSave.Level = 0; ItemSave.PIDList = string.Empty; ItemSave = CoQuanDal.Insert(ItemSave); } sb.Append("1"); break; #endregion case "getFunction": #region lấy quyền theo cq_id FunctionCollection ListGetFunction = FunctionDal.SelectAllByCqID(_CQ_ID); sb.Append(getTop(ListGetFunction)); break; #endregion case "upadteFunction": #region Lưu phân tính năng sb.Append(CoQuanFunctionDal.UpdateByUpdateListAndCQID(_CQ_ID, _UpdateList, Security.Username)); break; #endregion default: #region mặc định - trả về module ban đầu //<input type=""text"" class=""mdl-head-txt mdl-head-search"" /> FunctionCollection ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId); sb.Append(@"<div class=""mdl-head""> <span class=""mdl-head-searchPnl ui-state-default ui-corner-all""> <a href=""javascript:;"" class=""mdl-head-clearSearch""></a> <input type=""text"" class=""mdl-head-txt mdl-head-search mdl-head-search-coQuanSuper"" /> </span> <a class=""mdl-head-btn mdl-head-add"" id=""coquanSuperMdl-addBtn"" href=""javascript:coquanSuper.add();"">Thêm</a> <a class=""mdl-head-btn mdl-head-edit"" id=""coquanSuperMdl-editBtn"" href=""javascript:coquanSuper.edit();"">Sửa</a> <a class=""mdl-head-btn mdl-head-del"" id=""coquanSuperMdl-delBtn"" href=""javascript:coquanSuper.del();"">Xóa</a> </div> <table id=""coquanSupermdl-List"" class=""mdl-list""> </table> <div id=""coquanSuperMdl-Pager""></div> <div class=""sub-mdl""> <ul> <li> <a id=""coquanSuperMdl-functionmdl-subMdlBtn"" href=""#coquanSuperMdl-SubMdl-Mdl1"">Tính năng</a> </li> </ul> <div id=""coquanSuperMdl-SubMdl-Mdl1""> <div id=""coquanSuperMdl-functionmdl-coQuanFnMdl""> </div> </div> </div>"); sb.AppendFormat(@"<script src=""{0}"" type=""text/javascript""></script>" , cs.GetWebResourceUrl(typeof(Class1), "docsoft.plugin.hethong.coquan.super.JScript1.js")); sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn)); break; #endregion } writer.Write(sb.ToString()); base.Render(writer); }
private void DisplayInfo(DataRow drKetQuaLamSang) { try { _ketQuaLamSang.KetQuaLamSangGUID = Guid.Parse(drKetQuaLamSang["KetQuaLamSangGUID"].ToString()); dtpkNgay.Value = Convert.ToDateTime(drKetQuaLamSang["NgayKham"]); CoQuan coQuan = (CoQuan)Convert.ToInt32(drKetQuaLamSang["CoQuan"]); bool normal = Convert.ToBoolean(drKetQuaLamSang["Normal"]); bool abnormal = Convert.ToBoolean(drKetQuaLamSang["Abnormal"]); string nhanXet = drKetQuaLamSang["Note"].ToString(); string para = string.Empty; if (drKetQuaLamSang["PARA"] != null && drKetQuaLamSang["PARA"] != DBNull.Value) { para = drKetQuaLamSang["PARA"].ToString(); } string phuKhoaNote = string.Empty; if (drKetQuaLamSang["PhuKhoaNote"] != null && drKetQuaLamSang["PhuKhoaNote"] != DBNull.Value) { phuKhoaNote = drKetQuaLamSang["PhuKhoaNote"].ToString(); } DateTime ngayKinhChot = DateTime.Now; if (drKetQuaLamSang["NgayKinhChot"] != null && drKetQuaLamSang["NgayKinhChot"] != DBNull.Value) { chkKinhChot.Checked = true; ngayKinhChot = Convert.ToDateTime(drKetQuaLamSang["NgayKinhChot"]); } else { chkKinhChot.Checked = false; } string soiTuoiHuyetTrang = string.Empty; if (drKetQuaLamSang["SoiTuoiHuyetTrang"] != null && drKetQuaLamSang["SoiTuoiHuyetTrang"] != DBNull.Value) { soiTuoiHuyetTrang = drKetQuaLamSang["SoiTuoiHuyetTrang"].ToString(); } switch (coQuan) { case CoQuan.Mat: raMat.Checked = true; chkNormal_Mat.Checked = normal; chkAbnormal_Mat.Checked = abnormal; txtNhanXet_Mat.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.TaiMuiHong: raTaiMuiHong.Checked = true; chkNormal_TaiMuiHong.Checked = normal; chkAbnormal_TaiMuiHong.Checked = abnormal; txtNhanXet_TaiMuiHong.Text = nhanXet; //_isNgoaiKhoa = true; _type = 0; break; case CoQuan.RangHamMat: raRangHamMat.Checked = true; chkNormal_RangHamMat.Checked = normal; chkAbnormal_RangHamMat.Checked = abnormal; txtNhanXet_RangHamMat.Text = nhanXet; //_isNgoaiKhoa = true; _type = 0; break; case CoQuan.HoHap: raHoHap.Checked = true; chkNormal_HoHap.Checked = normal; chkAbnormal_HoHap.Checked = abnormal; txtNhanXet_HoHap.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.TimMach: raTimMach.Checked = true; chkNormal_TimMach.Checked = normal; chkAbnormal_TimMach.Checked = abnormal; txtNhanXet_TimMach.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.TieuHoa: raTieuHoa.Checked = true; chkNormal_TieuHoa.Checked = normal; chkAbnormal_TieuHoa.Checked = abnormal; txtNhanXet_TieuHoa.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.TietNieuSinhDuc: raTietNieuSinhDuc.Checked = true; chkNormal_TietNieuSinhDuc.Checked = normal; chkAbnormal_TietNieuSinhDuc.Checked = abnormal; txtNhanXet_TietNieuSinhDuc.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.CoXuongKhop: raCoXuongKhop.Checked = true; chkNormal_CoXuongKhop.Checked = normal; chkAbnormal_CoXuongKhop.Checked = abnormal; txtNhanXet_CoXuongKhop.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.DaLieu: raDaLieu.Checked = true; chkNormal_DaLieu.Checked = normal; chkAbnormal_DaLieu.Checked = abnormal; txtNhanXet_DaLieu.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.ThanKinh: raThanKinh.Checked = true; chkNormal_ThanKinh.Checked = normal; chkAbnormal_ThanKinh.Checked = abnormal; txtNhanXet_ThanKinh.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.NoiTiet: raNoiTiet.Checked = true; chkNormal_NoiTiet.Checked = normal; chkAbnormal_NoiTiet.Checked = abnormal; txtNhanXet_NoiTiet.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.Khac: raCacCoQuanKhac.Checked = true; txtNhanXet_CoQuanKhac.Text = nhanXet; //_isNgoaiKhoa = false; _type = 1; break; case CoQuan.KhamPhuKhoa: raKhamPhuKhoa.Checked = true; txtPARA.Text = para; dtpkNgayKinhChot.Value = ngayKinhChot; txtKetQuaKhamPhuKhoa.Text = nhanXet; txtPhuKhoaNote.Text = phuKhoaNote; txtSoiTuoiHuyetTrang.Text = soiTuoiHuyetTrang; chkNormal_KhamPhuKhoa.Checked = normal; chkAbnormal_KhamPhuKhoa.Checked = abnormal; //_isNgoaiKhoa = false; _type = 2; break; } DisplayBacSi(); cboDocStaff.SelectedValue = drKetQuaLamSang["DocStaffGUID"].ToString(); if (drKetQuaLamSang["CreatedDate"] != null && drKetQuaLamSang["CreatedDate"] != DBNull.Value) { _ketQuaLamSang.CreatedDate = Convert.ToDateTime(drKetQuaLamSang["CreatedDate"]); } if (drKetQuaLamSang["CreatedBy"] != null && drKetQuaLamSang["CreatedBy"] != DBNull.Value) { _ketQuaLamSang.CreatedBy = Guid.Parse(drKetQuaLamSang["CreatedBy"].ToString()); } if (drKetQuaLamSang["UpdatedDate"] != null && drKetQuaLamSang["UpdatedDate"] != DBNull.Value) { _ketQuaLamSang.UpdatedDate = Convert.ToDateTime(drKetQuaLamSang["UpdatedDate"]); } if (drKetQuaLamSang["UpdatedBy"] != null && drKetQuaLamSang["UpdatedBy"] != DBNull.Value) { _ketQuaLamSang.UpdatedBy = Guid.Parse(drKetQuaLamSang["UpdatedBy"].ToString()); } if (drKetQuaLamSang["DeletedDate"] != null && drKetQuaLamSang["DeletedDate"] != DBNull.Value) { _ketQuaLamSang.DeletedDate = Convert.ToDateTime(drKetQuaLamSang["DeletedDate"]); } if (drKetQuaLamSang["DeletedBy"] != null && drKetQuaLamSang["DeletedBy"] != DBNull.Value) { _ketQuaLamSang.DeletedBy = Guid.Parse(drKetQuaLamSang["DeletedBy"].ToString()); } _ketQuaLamSang.Status = Convert.ToByte(drKetQuaLamSang["Status"]); if (!_allowEdit) { btnOK.Enabled = _allowEdit; groupBox1.Enabled = _allowEdit; } } catch (Exception e) { MsgBox.Show(this.Text, e.Message, IconType.Error); Utility.WriteToTraceLog(e.Message); } }