public List <string> AutoCompleteMaDT(string MaDT) { try { List <string> result = new List <string>(); DoituongDAL _DAL = new DoituongDAL(); DataSet _ds; _ds = _DAL.Select_MaDoiTuong(MaDT); DataTable dt = _ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { result.Add(item["Ma_Doituong"].ToString()); } } else { result.Add("Mã đối tượng này chưa tồn tại !!"); } return(result); } catch (Exception) { throw; } }
public List <string> AutoCompleteStt(string Stt) { try { List <string> result = new List <string>(); DoituongDAL _DAL = new DoituongDAL(); DataSet _ds; _ds = _DAL.Select_TenDoiTuong_By_Stt(Stt); DataTable dt = _ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { result.Add(item["Ten_Doituong"].ToString()); } } else { result.Add("Số thứ tự này chưa tồn tại !!"); } return(result); } catch (Exception) { throw; } }
protected void GVDoituong_RowDeleting(object sender, GridViewDeleteEventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion int _id = Convert.ToInt32(GVDoituong.DataKeys[e.RowIndex].Values["ID"].ToString()); DoituongDAL _dtDAL = new DoituongDAL(); if (_dtDAL.CheckExists_Madoituong(_id, 1) == 1) { return; } else { _dtDAL.DeleteOneFromT_Doituong(_id); action.Thaotac = "[Xóa đối tượng]-->[Mã đối tượng:" + _id.ToString() + " ]"; actionDAL.InserT_Lichsu_Thaotac_Hethong(action); } BindList_Doituong(); }
protected void GVDoituong_RowDeleting(object sender, GridViewDeleteEventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion int _id = Convert.ToInt32(GVDoituong.DataKeys[e.RowIndex].Values["ID"].ToString()); DoituongDAL _dtDAL = new DoituongDAL(); if (_dtDAL.CheckExists_Madoituong(_id, 1) == 1) { return; } else { _dtDAL.DeleteOneFromT_Doituong(_id); lblMessError.Text = ""; action.Thaotac = "[Xóa đối tượng]-->[Mã đối tượng:" + _id.ToString() + " ]"; actionDAL.InserT_Lichsu_Thaotac_Hethong(action); } BindList_Doituong(); BinQuytrinhtheoAnPham(); UltilFunc.RunJavaScriptCode("$.fx.speeds._default = 10; var dlg = jQuery('#dialog').dialog({draggable: true, resizable: true, hide: 'scale', modal: true, width: 500 }); dlg.parent().appendTo(jQuery('form:first'));"); }
protected void GVDoituong_OnRowCommand1(object sender, GridViewCommandEventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion if (e.CommandName.Equals("AddNew")) { TextBox _ma = (TextBox)GVDoituong.FooterRow.FindControl("txt_MaDoituong"); TextBox _ten = (TextBox)GVDoituong.FooterRow.FindControl("txt_Tendoituong"); TextBox _englishname = (TextBox)GVDoituong.FooterRow.FindControl("txt_EnglishName"); TextBox _stt = (TextBox)GVDoituong.FooterRow.FindControl("txt_STT"); //Label _MaDT = (Label)GVDoituong.FooterRow.FindControl("lblMaDT_Error"); //Label _STT = (Label)GVDoituong.FooterRow.FindControl("lblSTT_Error"); int _return; DoituongDAL _doituongDAL = new DoituongDAL(); if (_doituongDAL.Check_Madoituong(0, _ma.Text.Trim()) > 0) { lblMessError.Text = "Mã đối tượng đã tồn tại"; GVDoituong.ShowFooter = true; BindList_Doituong(); } else if (_doituongDAL.Check_STT(0, Convert.ToInt32(_stt.Text.Trim())) > 0) { lblMessError.Text = "Số thứ tự đã tồn tại"; GVDoituong.ShowFooter = true; BindList_Doituong(); } else { _dt = new T_Doituong(); _dt.ID = 0; _dt.Ma_Doituong = _ma.Text.Trim(); _dt.Ten_Doituong = _ten.Text.Trim(); _dt.EnglishName = _englishname.Text.Trim(); if (!String.IsNullOrEmpty(_stt.Text.Trim())) { _dt.STT = Convert.ToInt32(_stt.Text.Trim()); } _dt.Ngaysua = DateTime.Now; _dt.Nguoitao = _user.UserID; _dt.Ngaytao = DateTime.Now; _dt.Nguoisua = _user.UserID; _return = _doituongDAL.InsertT_Doituong(_dt); action.Thaotac = "[Thêm mới đối tượng]-->[Mã mã đối tượng:" + _return.ToString() + " ]"; actionDAL.InserT_Lichsu_Thaotac_Hethong(action); BindList_Doituong(); } } }
protected void GVDoituong_RowUpdating(object sender, GridViewUpdateEventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion int _return; int _id = Convert.ToInt32(GVDoituong.DataKeys[e.RowIndex].Value.ToString()); TextBox _ma = (TextBox)GVDoituong.Rows[e.RowIndex].FindControl("txt_MaDoituong"); TextBox _ten = (TextBox)GVDoituong.Rows[e.RowIndex].FindControl("txt_Tendoituong"); TextBox _englishname = (TextBox)GVDoituong.Rows[e.RowIndex].FindControl("txt_EnglishName"); TextBox _stt = (TextBox)GVDoituong.Rows[e.RowIndex].FindControl("txt_STT"); Label _MaDT = (Label)GVDoituong.Rows[e.RowIndex].FindControl("lblMaDT_Error"); Label _STT = (Label)GVDoituong.Rows[e.RowIndex].FindControl("lblSTT_Error"); DoituongDAL _dtDAL = new DoituongDAL(); if (_dtDAL.Check_Madoituong(_id, _ma.Text.Trim()) > 0) { _MaDT.Text = "Mã đối tượng đã tồn tại"; return; } else if (_dtDAL.Check_STT(_id, Convert.ToInt32(_stt.Text.Trim())) > 0) { _STT.Text = "Số thứ tự đã tồn tại"; return; } else { _dt = new T_Doituong(); _dt.ID = _id; _dt.Ma_Doituong = _ma.Text.Trim(); _dt.Ten_Doituong = _ten.Text.Trim(); _dt.EnglishName = _englishname.Text.Trim(); if (!String.IsNullOrEmpty(_stt.Text.Trim())) { _dt.STT = Convert.ToInt32(_stt.Text.Trim()); } _dt.Ngaysua = DateTime.Now; _dt.Nguoitao = _user.UserID; _dt.Ngaytao = DateTime.Now; _dt.Nguoisua = _user.UserID; _return = _dtDAL.InsertT_Doituong(_dt); action.Thaotac = "[Sửa đối tượng]-->[Mã đối tượng:" + _return.ToString() + " ]"; actionDAL.InserT_Lichsu_Thaotac_Hethong(action); GVDoituong.EditIndex = -1; BindList_Doituong(); } }
protected void GVDoituong_OnRowCommand(object source, GridViewCommandEventArgs e) { HPCBusinessLogic.Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); if (e.CommandName.Equals("AddNew")) { TextBox _ma = (TextBox)GVDoituong.FooterRow.FindControl("txt_MaDoituong"); TextBox _ten = (TextBox)GVDoituong.FooterRow.FindControl("txt_Tendoituong"); TextBox _stt = (TextBox)GVDoituong.FooterRow.FindControl("txt_STT"); int _return; DoituongDAL _doituongDAL = new DoituongDAL(); if (_doituongDAL.Check_Madoituong(0, _ma.Text.Trim()) > 0) { lblMessError.Text = "Mã đối tượng đã tồn tại"; GVDoituong.ShowFooter = true; BindList_Doituong(); } else if (_doituongDAL.Check_STT(0, Convert.ToInt32(_stt.Text.Trim())) > 0) { lblMessError.Text = "Số thứ tự đã tồn tại"; GVDoituong.ShowFooter = true; BindList_Doituong(); } else { _dt = new T_Doituong(); _dt.ID = 0; _dt.Ma_Doituong = _ma.Text.Trim(); _dt.Ten_Doituong = _ten.Text.Trim(); if (!String.IsNullOrEmpty(_stt.Text.Trim())) { _dt.STT = Convert.ToInt32(_stt.Text.Trim()); } _dt.Ngaysua = DateTime.Now; _dt.Nguoitao = _user.UserID; _dt.Ngaytao = DateTime.Now; _dt.Nguoisua = _user.UserID; _return = _doituongDAL.InsertT_Doituong(_dt); action.Thaotac = "[Thêm mới đối tượng]-->[Mã mã đối tượng:" + _return.ToString() + " ]"; actionDAL.InserT_Lichsu_Thaotac_Hethong(action); lblMessError.Text = ""; BindList_Doituong(); BinQuytrinhtheoAnPham(); } UltilFunc.RunJavaScriptCode("$.fx.speeds._default = 10; var dlg = jQuery('#dialog').dialog({draggable: true, resizable: true, hide: 'scale', modal: true, width: 500 }); dlg.parent().appendTo(jQuery('form:first'));"); } }
public void BindList_Doituong() { string where = " 1=1 "; DoituongDAL _DAL = new DoituongDAL(); DataSet _ds; pages.PageSize = 10;//Global.MembersPerPage; _ds = _DAL.BindGridT_Doituong(pages.PageIndex, pages.PageSize, where); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0) { _ds = _DAL.BindGridT_Doituong(pages.PageIndex - 1, pages.PageSize, where); } if (_ds.Tables[0].Rows.Count > 0) { DataView _dv = _ds.Tables[0].DefaultView; if (SortExtension.Length > 1) { _dv.Sort = SortExtension + " " + SortOrder; } GVDoituong.DataSource = _dv; GVDoituong.DataBind(); GVDoituong.ShowFooter = false; } else { _ds.Tables[0].Rows.Add(_ds.Tables[0].NewRow()); GVDoituong.DataSource = _ds; GVDoituong.DataBind(); int columncount = GVDoituong.Rows[0].Cells.Count; GVDoituong.Rows[0].Cells.Clear(); GVDoituong.Rows[0].Cells.Add(new TableCell()); GVDoituong.Rows[0].Cells[0].ColumnSpan = columncount; GVDoituong.Rows[0].Cells[0].Text = "Không có bản ghi nào"; GVDoituong.ShowFooter = false; } pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["CurrentPage"] = pages.PageIndex; }
protected void GVDoituong_OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { ImageButton btnDelete = (ImageButton)e.Row.FindControl("btnDelete"); ImageButton btnAdd = (ImageButton)e.Row.FindControl("btnAdd"); if (btnAdd != null) { if (!_Role.R_Write) { btnAdd.Enabled = _Role.R_Write; } } if (btnDelete != null) { if (!_Role.R_Delete) { btnDelete.Enabled = _Role.R_Delete; } else { btnDelete.Attributes.Add("onclick", "return confirm('Bạn có chắc chắn muốn xóa?');"); } DoituongDAL _dtDAL = new DoituongDAL(); int _id = Convert.ToInt32(GVDoituong.DataKeys[e.Row.RowIndex].Value); if (_dtDAL.CheckExists_Madoituong(_id, 1) == 1) { btnDelete.Attributes.Add("onclick", "return alert(\"Đối tượng này đang được sử dụng\");"); } else { btnDelete.Attributes.Add("onclick", "return confirm(\"Bạn có chắc chắn muốn xóa không?\");"); } } Label lblSTT = (Label)e.Row.FindControl("lblSTT"); if (lblSTT != null) { lblSTT.Text = (pages.PageIndex * pages.PageSize + e.Row.RowIndex + 1).ToString(); } e.Row.Attributes.Add("onmouseover", "currColor=this.style.backgroundColor;this.style.backgroundColor='" + CommonLib.HPCOnmouseoverGrid() + "'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currColor"); } }
public void BindList_Doituong() { string where = " T_Doituong.Ma_Doituong not in (select T_Doituong_Anpham.Ma_Doituong from T_Doituong_Anpham where T_Doituong_Anpham.Ma_AnPham = " + maanpham + ") "; DoituongDAL _DAL = new DoituongDAL(); DataSet _ds; pages.PageSize = Global.MembersPerPage; _ds = _DAL.BindGridT_Doituong(pages.PageIndex, pages.PageSize, where); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0) { _ds = _DAL.BindGridT_Doituong(pages.PageIndex - 1, pages.PageSize, where); } if (_ds.Tables[0].Rows.Count > 0) { DataView _dv = _ds.Tables[0].DefaultView; GVDoituong.DataSource = _dv; GVDoituong.DataBind(); GVDoituong.ShowFooter = false; } else { _ds.Tables[0].Rows.Add(_ds.Tables[0].NewRow()); GVDoituong.DataSource = _ds; GVDoituong.DataBind(); int columncount = GVDoituong.Rows[0].Cells.Count; GVDoituong.Rows[0].Cells.Clear(); GVDoituong.Rows[0].Cells.Add(new TableCell()); GVDoituong.Rows[0].Cells[0].ColumnSpan = columncount; GVDoituong.Rows[0].Cells[0].Text = "Không có bản ghi nào"; GVDoituong.ShowFooter = false; } pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["CurrentPage"] = pages.PageIndex; }
protected void GVDoituong_RowUpdating(object source, GridViewUpdateEventArgs e) { #region GhiLog Lichsu_Thaotac_HethongDAL actionDAL = new Lichsu_Thaotac_HethongDAL(); T_Lichsu_Thaotac_Hethong action = new T_Lichsu_Thaotac_Hethong(); action.Ma_Nguoidung = _user.UserID; action.TenDaydu = _user.UserFullName; action.HostIP = IpAddress(); action.NgayThaotac = DateTime.Now; #endregion int _return; int _id = Convert.ToInt32(GVDoituong.DataKeys[e.RowIndex].Value.ToString()); TextBox txtMaDT = (TextBox)GVDoituong.Rows[e.RowIndex].FindControl("txt_MaDoituong"); TextBox txtTenDT = (TextBox)GVDoituong.Rows[e.RowIndex].FindControl("txt_Tendoituong"); TextBox txtSTT = (TextBox)GVDoituong.Rows[e.RowIndex].FindControl("txt_STT"); Label _MaDT = (Label)GVDoituong.Rows[e.RowIndex].FindControl("lblMaDT_Error"); Label _STT = (Label)GVDoituong.Rows[e.RowIndex].FindControl("lblSTT_Error"); DoituongDAL _dtDAL = new DoituongDAL(); try { int.Parse(txtSTT.Text); } catch (Exception) { lblMessError.Text = "Nhập lại số thứ tự"; throw; } if (_dtDAL.Check_Madoituong(_id, txtMaDT.Text.Trim()) > 0) { _MaDT.Text = "Mã đối tượng đã tồn tại"; return; } else if (_dtDAL.Check_STT(_id, Convert.ToInt32(txtSTT.Text.Trim())) > 0) { _STT.Text = "Số thứ tự đã tồn tại"; return; } else { _dt = new T_Doituong(); _dt.ID = _id; _dt.Ma_Doituong = txtMaDT.Text.Trim(); _dt.Ten_Doituong = txtTenDT.Text.Trim(); if (!String.IsNullOrEmpty(txtSTT.Text.Trim())) { _dt.STT = Convert.ToInt32(txtSTT.Text.Trim()); } _dt.Ngaysua = DateTime.Now; _dt.Nguoitao = _user.UserID; _dt.Ngaytao = DateTime.Now; _dt.Nguoisua = _user.UserID; _return = _dtDAL.InsertT_Doituong(_dt); action.Thaotac = "[Sửa đối tượng]-->[Mã đối tượng:" + _return.ToString() + " ]"; actionDAL.InserT_Lichsu_Thaotac_Hethong(action); lblMessError.Text = ""; GVDoituong.EditIndex = -1; BindList_Doituong(); BinQuytrinhtheoAnPham(); } UltilFunc.RunJavaScriptCode("$.fx.speeds._default = 10; var dlg = jQuery('#dialog').dialog({draggable: true, resizable: true, hide: 'scale', modal: true, width: 500 }); dlg.parent().appendTo(jQuery('form:first'));"); }