private void GetItem(int _id)
{
T_Hopdong _obj = new T_Hopdong();
HopdongDAL _objDAL = new HopdongDAL();
_obj = _objDAL.GetOneFromT_HopdongByID(_id);
if (_id > 0)
{
this.ddl_TenKH.SelectedIndex = UltilFunc.GetIndexControl(ddl_TenKH, _obj.Ma_KhachHang.ToString());
this.ddl_TenKH.Enabled = false;
ddl_Yeucau.Items.Clear();
UltilFunc.BindCombox(ddl_Yeucau, "ID", "TenQuangCao", "T_Yeucau", " Ma_Khachhang = " + _obj.Ma_KhachHang.ToString());
this.ddl_Yeucau.SelectedIndex = UltilFunc.GetIndexControl(ddl_Yeucau, _obj.Ma_Yeucau.ToString());
ddl_Yeucau.Enabled = false;
}
//else
//{
// this.ddl_TenKH.SelectedIndex = UltilFunc.GetIndexControl(ddl_TenKH, _obj.Ma_KhachHang.ToString());
// this.ddl_Yeucau.SelectedIndex = UltilFunc.GetIndexControl(ddl_Yeucau, _obj.Ma_Yeucau.ToString());
//}
this.txt_SoHD.Text = _obj.hopdongso;
this.txt_Mota.Text = _obj.Tomtatnoidung;
this.txt_Sotien.Text = _obj.Sotien.ToString();
this.lblFilePath.Text = _obj.duongdan_file;
this.txt_NgayKy.Text = _obj.ngayky.ToString("dd/MM/yyyy");
this.txt_NgayHetHan.Text = _obj.Ngayketthuc.ToString("dd/MM/yyyy");
}
public void Danhsach_Hopdong()
{
string where = " 1=1 and Loai=2 ";
if (!String.IsNullOrEmpty(this.hdnValue.Value.ToString().Trim()))
{
where += " AND Ma_KhachHang = " + string.Format(hdnValue.Value.ToString()) + " ";
}
if (!String.IsNullOrEmpty(this.txt_SoHD.Text.Trim()))
{
where += " AND hopdongso = '" + this.txt_SoHD.Text.ToString().Trim() + "' ";
}
if (!String.IsNullOrEmpty(this.txt_NgayKy.Text.Trim()))
{
where += " AND " + string.Format(" ngayky >='{0}'", UltilFunc.ToDate(this.txt_NgayKy.Text.Trim(), "dd/MM/yyyy").ToShortDateString() + " 00:00:00 ");
}
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.HopdongDAL _hopdongDAL = new HopdongDAL();
DataSet _ds;
_ds = _hopdongDAL.BindGridT_Hopdong(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 = _hopdongDAL.BindGridT_Hopdong(pages.PageIndex - 1, pages.PageSize, where);
}
if (_ds.Tables[0].Rows.Count > 0)
{
DataView DV = _ds.Tables[0].DefaultView;
if (Session["sortBy"] != null)
{
DV.Sort = Session["sortBy"].ToString();
}
GVListHopdong.DataSource = DV;
GVListHopdong.DataBind();
}
else
{
GVListHopdong.DataSource = null;
GVListHopdong.DataBind();
}
//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;
}
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 Layout(object sender, EventArgs e)
{
using (GridViewRow _row = (GridViewRow)((ImageButton)sender).Parent.Parent)
{
EID = Convert.ToInt32(GVListHopdong.DataKeys[_row.RowIndex].Value);
ViewState["ID"] = EID.ToString();
//lblMess.Text = "";
LinkButton _lblTenKH = (LinkButton)GVListHopdong.Rows[_row.RowIndex].FindControl("btnEdit");
if (_lblTenKH != null)
{
lbl_TenKH.Text = "Tên khách hàng: " + _lblTenKH.Text.Trim();
}
else
{
lbl_TenKH.Text = "";
}
Label _lblSHD = (Label)GVListHopdong.Rows[_row.RowIndex].FindControl("lblSohopdong");
if (!String.IsNullOrEmpty(_lblSHD.Text))
{
lbl_SoHD.Text = "Số hợp đồng: " + _lblSHD.Text;
}
else
{
lbl_SoHD.Text = "";
}
HopdongDAL daldh = new HopdongDAL();
SotienHD = daldh.GetOneFromT_HopdongByID(EID).Sotien;
if (SotienHD != 0)
{
lblTongtien.Text = " Tổng tiền: " + String.Format("{0:00,0}", Convert.ToDecimal(SotienHD));
}
else
{
lblTongtien.Text = " Tổng tiền: " + String.Format("{0:00,0}", "0");
}
lblMessError.Text = "";
BindDataLichSuThanhToanPhatHanh();
popup.Show();
}
}
protected void GVListHopdong_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(GVListHopdong.DataKeys[e.RowIndex].Values["ID"].ToString());
HopdongDAL _apDAL = new HopdongDAL();
_apDAL.DeleteOneFromT_Hopdong(_id);
action.Thaotac = "[Xóa hợp đồng]-->[Mã hợp đồng:" + _id.ToString() + " ]";
actionDAL.InserT_Lichsu_Thaotac_Hethong(action);
Danhsach_Hopdong();
}
protected void GVThanhtoanHD_OnRowCommand(object source, GridViewCommandEventArgs e)
{
HPCBusinessLogic.DAL.LichsuthanhtoanDAL dal = new HPCBusinessLogic.DAL.LichsuthanhtoanDAL();
if (e.CommandName.Equals("AddNew"))
{
TextBox txtsotien = (TextBox)GVThanhtoanHD.FooterRow.FindControl("txtsotien");
TextBox txtngaythu = (TextBox)GVThanhtoanHD.FooterRow.FindControl("txtngaythu");
TextBox txtnguoithanhtoan = (TextBox)GVThanhtoanHD.FooterRow.FindControl("txtnguoithanhtoan");
Label lblthongbaoSotien = (Label)GVThanhtoanHD.FooterRow.FindControl("lblthongbaoSotien");
if (txtsotien.Text.Trim() == "")
{
lblthongbaoSotien.Text = " bạn chưa nhập số tiền";
return;
}
if (txtngaythu.Text.Trim() == "")
{
lblthongbaoSotien.Text = " bạn chưa nhập ngày thu tiền";
return;
}
if (txtnguoithanhtoan.Text.Trim() == "")
{
lblthongbaoSotien.Text = " bạn chưa nhập người thanh toán";
return;
}
double Sotienthanhtoan = 0;
string Thaotac = "";
HopdongDAL daldh = new HopdongDAL();
int makh = daldh.GetOneFromT_HopdongByID(int.Parse(ViewState["ID"].ToString())).Ma_KhachHang;
T_LichsuThanhtoan obj = new T_LichsuThanhtoan();
if (ViewState["IDHD"] != null)
{
obj.ID = int.Parse(ViewState["IDHD"].ToString());
}
else
{
obj.ID = 0;
}
obj.HOPDONG_SO = int.Parse(ViewState["ID"].ToString());
obj.MA_KHACHHANG = makh;
if (txtsotien.Text.Trim() != "")
{
obj.SOTIEN = double.Parse(txtsotien.Text.Replace(",", ""));
}
else
{
obj.SOTIEN = 0;
}
obj.NGUOITHU = _user.UserID;
obj.TENNGUOINOP = txtnguoithanhtoan.Text;
obj.Loai = 2;
if (txtngaythu.Text.Length > 0)
{
obj.NGAYTHU = UltilFunc.ToDate(txtngaythu.Text.Trim(), "dd/MM/yyyy");
}
Sotienthanhtoan = Total(_DataTableThanhtoan, "SOTIEN");
if (obj.SOTIEN + Sotienthanhtoan <= SotienHD)
{
Thaotac = "Thêm mới thông tin lịch sử thanh toán quảng cáo";
dal.Sp_InsertT_LichsuThanhtoan(obj);
BindDataLichSuThanhToanPhatHanh();
if (Thaotac != "")
{
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"].ToString()), Thaotac);
}
}
else
{
GVThanhtoanHD.ShowFooter = true;
lblMessError.Text = "Số tiền thanh toán vượt quá số tiền hợp đồng";
BindDataLichSuThanhToanPhatHanh();
}
}
}
