public void Danhsach_Khachhang()
{
string where = " Loai_KH = 1 ";
if (!String.IsNullOrEmpty(this.txtTen_Khachhang.Text.Trim()))
{
where += " " + string.Format(" Ten_KhachHang like N'%{0}%'", UltilFunc.SqlFormatText(this.txtTen_Khachhang.Text.Trim()));
}
pages.PageSize = Global.MembersPerPage;
KhachhangDAL _khachhangDAL = new KhachhangDAL();
DataSet _ds;
_ds = _khachhangDAL.BindGridT_Khachhang(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 = _khachhangDAL.BindGridT_Khachhang(pages.PageIndex - 1, pages.PageSize, where);
}
grdList.DataSource = _ds.Tables[0];
grdList.DataBind();
_ds.Clear();
pages.TotalRecords = curentPages.TotalRecords = TotalRecords;
curentPages.TotalPages = pages.CalculateTotalPages();
curentPages.PageIndex = pages.PageIndex;
Session["PageIndex"] = pages.PageIndex;
grdList.Columns[6].Visible = IsRoleDelete();
}
public void grdList_EditCommand(object source, DataGridCommandEventArgs 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
KhachhangDAL objDAL = new KhachhangDAL();
if (e.CommandArgument.ToString().ToLower() == "edit")
{
int cusID = Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString());
Response.Redirect("~/Phathanh/KhachHangEdit.aspx?Menu_ID=" + Page.Request["Menu_ID"].ToString() + "&ID=" + cusID);
}
if (e.CommandArgument.ToString().ToLower() == "delete")
{
bool _bool;
_bool = IsCustomerExsits(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString()));
if (_bool == false)
{
objDAL.DeleteOneFromT_KhachHang(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString()));
action.Thaotac = "[Xóa T_KhachHang]-->[Thao tác Xóa Trong Bảng T_KhachHang][ID:" + this.grdList.DataKeys[e.Item.ItemIndex].ToString() + " ]";
this.Danhsach_Khachhang();
}
else
{
return;
}
}
//if (e.CommandArgument.ToString().ToLower() == "sort")
//{
// if (this.ViewState["SortExp"] == null)
// {
// this.ViewState["SortExp"] = e.CommandArgument.ToString();
// this.ViewState["SortOrder"] = "ASC";
// }
// else
// {
// if (this.ViewState["SortExp"].ToString() == e.CommandArgument.ToString())
// {
// if (this.ViewState["SortOrder"].ToString() == "ASC")
// this.ViewState["SortOrder"] = "DESC";
// else
// this.ViewState["SortOrder"] = "ASC";
// }
// else
// {
// this.ViewState["SortOrder"] = "ASC";
// this.ViewState["SortExp"] = e.CommandArgument.ToString();
// }
// }
Danhsach_Khachhang();
}
protected string TenKhachHang(string _Id)
{
string strReturn = "";
T_KhachHang _kh = new T_KhachHang();
KhachhangDAL _dal = new KhachhangDAL();
if (!String.IsNullOrEmpty(_Id) && Convert.ToInt32(_Id) > 0)
{
_kh = _dal.GetOneFromT_KhachHangByID(Convert.ToInt32(_Id));
strReturn = _kh.Ten_KhachHang;
}
else
{
strReturn = "";
}
return(strReturn);
}
private void GetItem(int _id)
{
T_KhachHang _obj = new T_KhachHang();
KhachhangDAL _objDAL = new KhachhangDAL();
_obj = _objDAL.GetOneFromT_KhachHangByID(_id);
this.txt_TenKH.Text = _obj.Ten_KhachHang;
this.txt_Diachi.Text = _obj.DiaChi;
this.txt_Dienthoai.Text = _obj.SoDienThoai;
this.txt_Email.Text = _obj.Email;
this.txt_Fax.Text = _obj.FAX;
this.txt_Masothue.Text = _obj.MaSoThue;
this.txt_Mota.Text = _obj.Ghichu;
this.txt_Nguoidaidien.Text = _obj.NguoiDaiDien;
this.txt_Taikhoan.Text = _obj.TaiKhoan;
this.txt_Tendaydu.Text = _obj.Tendaydu;
}
private void GetItem(int _id)
{
T_KhachHang _obj = new T_KhachHang();
KhachhangDAL _objDAL = new KhachhangDAL();
_obj = _objDAL.GetOneFromT_KhachHangByID(_id);
this.txt_TenKH.Text = _obj.Ten_KhachHang;
this.txt_Diachi.Text = _obj.DiaChi;
this.txt_Dienthoai.Text = _obj.SoDienThoai;
this.txt_Email.Text = _obj.Email;
this.txt_Fax.Text = _obj.FAX;
this.txt_Masothue.Text = _obj.MaSoThue;
this.txt_Mota.Text = _obj.Ghichu;
this.txt_Nguoidaidien.Text = _obj.NguoiDaiDien;
this.txt_Taikhoan.Text = _obj.TaiKhoan;
this.txt_Tendaydu.Text = _obj.Tendaydu;
//ddl_LoaiKH.SelectedIndex = UltilFunc.GetIndexControl(ddl_LoaiKH, _obj.Loai_KH.ToString());
}
protected void Save_Click(object sender, EventArgs 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
this.Page.Validate(vs_Themmoi.ValidationGroup);
if (!Page.IsValid)
{
return;
}
KhachhangDAL _KhachHangDAL = new KhachhangDAL();
T_KhachHang _KhachHang = SetItem();
int menuID = 0;
if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty)
{
menuID = int.Parse(Request["ID"].ToString());
}
int _return = _KhachHangDAL.InsertT_Khachhang(_KhachHang);
if (Page.Request.Params["id"] == null)
{
action.Thaotac = "[Thêm mới khách hàng]-->[mã khách hàng:" + _return.ToString() + " ]";
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + Global.RM.GetString("VALIDATE_ADDNEWS") + "');", true);
actionDAL.InserT_Lichsu_Thaotac_Hethong(action);
Clear();
return;
}
if (Page.Request.Params["id"] != null)
{
action.Thaotac = "[Sửa thông tin khách hàng]-->[Mã KH:" + Page.Request["id"].ToString() + " ]";
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + Global.RM.GetString("UpdateSuccessfully") + "');", true);
actionDAL.InserT_Lichsu_Thaotac_Hethong(action);
Clear();
return;
}
}
protected void Save_Click(object sender, EventArgs 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
this.Page.Validate(vs_Themmoi.ValidationGroup);
if (!Page.IsValid)
{
return;
}
KhachhangDAL _KhachHangDAL = new KhachhangDAL();
T_KhachHang _KhachHang = SetItem();
int menuID = 0;
if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty)
{
menuID = int.Parse(Request["ID"].ToString());
}
int _return = _KhachHangDAL.InsertT_Khachhang(_KhachHang);
if (Page.Request.Params["id"] == null)
{
action.Thaotac = "[Thêm mới khách hàng]-->[mã khách hàng:" + _return.ToString() + " ]";
actionDAL.InserT_Lichsu_Thaotac_Hethong(action);
Clear();
return;
}
if (Page.Request.Params["id"] != null)
{
action.Thaotac = "[Sửa thông tin khách hàng]-->[Mã KH:" + Page.Request["id"].ToString() + " ]";
actionDAL.InserT_Lichsu_Thaotac_Hethong(action);
Clear();
return;
}
}
public void ProcessRequest(HttpContext context)
{
string prefixText = context.Request.QueryString["q"];
StringBuilder sb = new StringBuilder();
KhachhangDAL _DAL = new KhachhangDAL();
DataSet _ds;
_ds = _DAL.Select_Loai_KhachHang(prefixText);
// sb.Append(string.Format("{0}|{1}", "Tên", "0")).Append(Environment.NewLine);
if (_ds.Tables[0].Rows.Count > 0)
{
for (int _i = 0; _i < _ds.Tables[0].Rows.Count; _i++)
{
sb.Append(string.Format("{0}|{1}", _ds.Tables[0].Rows[_i]["Ten_KhachHang"].ToString(), _ds.Tables[0].Rows[_i]["Ma_KhachHang"].ToString())).Append(Environment.NewLine);//(_ds.Tables[0].Rows[_i]["Ten_KhachHang"].ToString()).Append(Environment.NewLine);
}
}
else
{
sb.Append(string.Format("{0}|{1}", "No records to display", "0")).Append(Environment.NewLine);//(_ds.Tables[0].Rows[_i]["Ten_KhachHang"].ToString()).Append(Environment.NewLine);
}
context.Response.Write(sb.ToString());
}
public void grdList_EditCommand(object source, DataGridCommandEventArgs 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
KhachhangDAL objDAL = new KhachhangDAL();
if (e.CommandArgument.ToString().ToLower() == "edit")
{
int cusID = Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString());
Response.Redirect("~/Danhmuc/EditKhachHang.aspx?Menu_ID=" + Page.Request["Menu_ID"].ToString() + "&ID=" + cusID);
}
if (e.CommandArgument.ToString().ToLower() == "delete")
{
objDAL.DeleteOneFromT_KhachHang(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString()));
action.Thaotac = "[Xóa T_KhachHang]-->[Thao tác Xóa Trong Bảng T_KhachHang][ID:" + this.grdList.DataKeys[e.Item.ItemIndex].ToString() + " ]";
this.Danhsach_Khachhang();
}
}