public void Danhsach_Yeucau()
{
string where = " Loai = 2 ";
if (!String.IsNullOrEmpty(this.hdnValue.Value.ToString().Trim()))
{
where += " AND Ma_Khachhang = " + string.Format(hdnValue.Value.ToString()) + " ";
}
if (!String.IsNullOrEmpty(this.txt_Noidung.Text.Trim()))
{
where += " AND TenQuangCao like N'%" + this.txt_Noidung.Text.Trim() + "%'";
}
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.YeucauDAL _yeucauDAL = new HPCBusinessLogic.DAL.YeucauDAL();
DataSet _ds;
_ds = _yeucauDAL.BindGridT_Yeucauquangcao(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 = _yeucauDAL.BindGridT_Yeucauquangcao(pages.PageIndex - 1, pages.PageSize, where);
}
grdList.DataSource = _ds.Tables[0];
grdList.DataBind();
_ds.Clear();
hdnValue.Value = "";
pages.TotalRecords = curentPages.TotalRecords = TotalRecords;
curentPages.TotalPages = pages.CalculateTotalPages();
curentPages.PageIndex = pages.PageIndex;
Session["PageIndex"] = pages.PageIndex;
}
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
HPCBusinessLogic.DAL.YeucauDAL objDAL = new HPCBusinessLogic.DAL.YeucauDAL();
if (e.CommandArgument.ToString().ToLower() == "edit")
{
int cusID = Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString());
Response.Redirect("~/Phathanh/YeucauPHEdit.aspx?Menu_ID=" + Page.Request["Menu_ID"].ToString() + "&ID=" + cusID);
}
if (e.CommandArgument.ToString().ToLower() == "isstatus")
{
double _ID = Convert.ToDouble(this.grdList.DataKeys[e.Item.ItemIndex].ToString());
Int16 _check = objDAL.GetOneFromT_YeuCauByID(_ID).Trangthai;
if (_check == 0)
{
objDAL.UpdateinfoT_Yeucau(" [Trangthai] = 1 where ID = " + _ID.ToString());
action.Thaotac = "[Cập nhật trạng thái bảng T_Yeucau][ID:" + _ID.ToString() + " ][Trangthai = 1]";
Danhsach_Yeucau();
}
if (_check == 1)
{
bool _bool;
_bool = IsHopdongExsits(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString()));
if (_bool == false)
{
objDAL.UpdateinfoT_Yeucau(" [Trangthai] = 0 where ID = " + _ID.ToString());
action.Thaotac = "[Cập nhật trạng thái bảng T_Yeucau][ID:" + _ID.ToString() + " ][Trangthai = 0]";
}
else
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('Yêu cầu này đã làm hợp đồng!');", true);
return;
}
Danhsach_Yeucau();
}
}
if (e.CommandArgument.ToString().ToLower() == "delete")
{
bool _bool;
_bool = IsHopdongExsits(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString()));
if (_bool == false)
{
objDAL.DeleteFromT_YeuCauQCByID(Convert.ToInt32(this.grdList.DataKeys[e.Item.ItemIndex].ToString()));
action.Thaotac = "[Thao tác Xóa Trong Bảng T_Yeucau][ID:" + this.grdList.DataKeys[e.Item.ItemIndex].ToString() + " ]";
Danhsach_Yeucau();
}
else
{
return;
}
}
}
private void GetItem(double _id)
{
T_Yeucau _objYeucau = new T_Yeucau();
HPCBusinessLogic.DAL.YeucauDAL _yeucauDAL = new HPCBusinessLogic.DAL.YeucauDAL();
_objYeucau = _yeucauDAL.GetOneFromT_YeuCauByID(_id);
if (_id > 0)
{
this.ddl_TenKH.SelectedIndex = UltilFunc.GetIndexControl(ddl_TenKH, _objYeucau.Ma_Khachhang.ToString());
this.ddl_TenKH.Enabled = false;
}
this.txt_Tieude.Text = _objYeucau.TenQuangCao;
this.ckeNoidung.Text = _objYeucau.NoidungQC;
}
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;
}
HopdongDAL _hopdongDAL = new HopdongDAL();
T_Hopdong _hopdong = SetItem();
int menuID = 0;
if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty)
{
menuID = int.Parse(Request["ID"].ToString());
}
int _return = _hopdongDAL.InsertT_Hopdong(_hopdong);
if (Page.Request.Params["id"] == null)
{
#region Update T_Yeucau khi da co hop dong --> Trangthai = 2
HPCBusinessLogic.DAL.YeucauDAL _yeucauDAL = new HPCBusinessLogic.DAL.YeucauDAL();
_yeucauDAL.UpdateinfoT_Yeucau(" [Trangthai] = 2 where ID = " + ddl_Yeucau.SelectedValue.ToString());
#endregion
action.Thaotac = "[Thêm mới hợp đồng]-->[mã hợp đồ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();
BindCombo();
return;
}
if (Page.Request.Params["id"] != null)
{
action.Thaotac = "[Sửa hợp đồng]-->[Mã hợp đồng:" + 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();
BindCombo();
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;
}
HPCBusinessLogic.DAL.YeucauDAL _cvDAL = new HPCBusinessLogic.DAL.YeucauDAL();
T_Yeucau _yc = SetItem();
int menuID = 0;
if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty)
{
menuID = int.Parse(Request["ID"].ToString());
}
double _return = _cvDAL.InsertT_YecauQuangCao(_yc);
if (Page.Request.Params["id"] == null)
{
action.Thaotac = "[Thêm mới yêu cầu phát hành]-->[mã yêu cầu:" + _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();
BindCombo();
return;
}
if (Page.Request.Params["id"] != null)
{
action.Thaotac = "[Sửa nội dung yêu cầu phát hành]-->[Mã yêu cầu:" + 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();
BindCombo();
return;
}
}
