protected void Page_Load(object sender, EventArgs e) { //DateTime time=new DateTime(2013,12,10); //DateTime d=Libs.VSDateTime.getPreBusinessDay(time, 3); StockTaiSanReport ts = new StockTaiSanReport("094K002555","N"); this.lbName.Text=ts.TenTaiKhoan; ts.dailyReport(new DateTime(2013, 8,31), new DateTime(2013, 9, 30)); GridView1.DataSource = ts.TaiSan; GridView1.DataBind(); GridView2.DataSource = ts.No; GridView2.DataBind(); GridView3.DataSource = ts.TaiSanKhac; GridView3.DataBind(); this.lbTSRongTN.Text = ts.taiSanRongTN().ToString(); this.lbTSRongDN.Text = ts.taiSanRongDN().ToString(); GridView4.DataSource = ts.getDataForAYear(new DateTime(2013,11,6)) ; GridView4.DataBind(); }
public DataTable getDataForAYear(DateTime todate) { DataTable yearly = new DataTable(); yearly.Columns.Add("ten"); yearly.Columns.Add("taisan"); yearly.Columns.Add("no"); yearly.Columns.Add("taisanrong"); StockTaiSanReport taisan = new StockTaiSanReport(this.MaTk,this.Type); for (int i = 11; i >= 0; i--) { DateTime time = new DateTime(todate.Year, todate.Month, 1).AddMonths(-i).AddDays(-1); taisan.dailyReport(time, time); yearly.Rows.Add(new object[] { "Tháng "+ time.Month.ToString("00") + "-" + time.Year, taisan.tongTaiSanTN(), taisan.tongNoTN(), taisan.tongTaiSanTN() - taisan.tongNoTN() }); } return yearly; }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Redirect("login.aspx"); } this.ctr_taisan_result.Visible = false; if (Request["acccode"]!=null) { this.maTk = Request["acccode"]; //DateTime time=new DateTime(2013,12,10); if (Request["txtDateTn"] != null) { try { string datetn=Request["txtDateTn"]; dateTn = DateTime.ParseExact(datetn, "dd/MM/yyyy", CultureInfo.CurrentCulture); } catch (Exception ex) { //this.ctr_taisan_result.builreport = false; this.txtMessageError.Text = "Ngày nhập vào không hợp lệ"; return; } } if (Request["txtDateDn"] != null) { try { string datedn = Request["txtDateDn"]; dateDn = DateTime.ParseExact(datedn, "dd/MM/yyyy", CultureInfo.CurrentCulture); } catch (Exception ex) { //this.ctr_taisan_result.builreport = false; this.txtMessageError.Text = "Ngày nhập vào không hợp lệ"; return; } } if (this.dateTn > this.dateDn) { this.txtMessageError.Text = "Ngày cuối kỳ phải lớn hơn ngày đầu kỳ"; return; } string query = "SELECT * FROM [dbo].[TradingAccount] WHERE [CustomerId] = '" + Session["username"].ToString().Replace("'", "\\'") + "' and AccountId = '" + Request["acccode"] + "'"; DataTable tbl = VSDBConnection.getDataTable(query, VSDBConnection.CSVSFServices); if (tbl.Rows.Count == 0) { this.txtMessageError.Text = "Tài khoản không hợp lệ!"; return; } //DateTime d=Libs.VSDateTime.getPreBusinessDay(time, 3); string type="N"; if(Request["type"]=="Y") type="Y"; StockTaiSanReport ts = new StockTaiSanReport(Request["acccode"], type); //this.ctr_taisan_result.MaTK = ""; this.ctr_taisan_result.TenTk=ts.TenTaiKhoan; if (!ts.exisAcc) { this.txtMessageError.Text = "Không tìm thấy tài khoản"; return; } this.ctr_taisan_result.report = ts; //if (this.ctr_taisan_result.builreport) //{ this.ctr_taisan_result.DateTn = dateTn; this.ctr_taisan_result.DateDn = dateDn; this.ctr_taisan_result.loadContent(); //} //ts.dailyReport(new DateTime(2013, 8, 31), new DateTime(2013, 9, 30)); //GridView1.DataSource = ts.TaiSan; //GridView1.DataBind(); //GridView2.DataSource = ts.No; //GridView2.DataBind(); //GridView3.DataSource = ts.TaiSanKhac; //GridView3.DataBind(); //this.lbTSRongTN.Text = ts.taiSanRongTN().ToString(); //this.lbTSRongDN.Text = ts.taiSanRongDN().ToString(); //GridView4.DataSource = ts.getDataForAYear(new DateTime(2013, 11, 6)); //GridView4.DataBind(); this.ctr_taisan_result.Visible = true; } }