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