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