private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); if (!string.IsNullOrEmpty(_carNumber)) { ddlCarNumber.SelectedValue = _carNumber; } if (!string.IsNullOrEmpty(_customer1)) { ddlCustomer1.SelectedValue = _customer1; } if (!string.IsNullOrEmpty(_customer2)) { ddlCustomer2.SelectedValue = _customer2; } if (!string.IsNullOrEmpty(_beginTime)) { txtBeginTime.Text = _beginTime; } if (!string.IsNullOrEmpty(_endTime)) { txtEndTime.Text = _endTime; } this.txtKeywords.Text = this.keywords; BLL.TransportOrder bll = new BLL.TransportOrder(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("transportOrder_list.aspx", "carNumber={0}&customer1={1}&customer2={2}&beginTime={3}&endTime={4}&keywords={5}&page={6}", _carNumber, _customer1, _customer2, _beginTime, _endTime, this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); if (!string.IsNullOrEmpty(_carNumber)) { ddlDriver.SelectedValue = _carNumber; } //if (!string.IsNullOrEmpty(_beginTime)) //{ // txtBeginTime.Text = _beginTime; //} //if (!string.IsNullOrEmpty(_endTime)) //{ // txtEndTime.Text = _endTime; //} this.txtKeywords.Text = this.keywords; BLL.TransportOrder bll = new BLL.TransportOrder(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("receipt_register_list.aspx", "carNumber={0}&customer1={1}&customer2={2}&keywords={3}&page={4}", _carNumber, _customer1, _customer2, this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind() { string sql = " Status = 3 "; if (!string.IsNullOrEmpty(_beginTime)) { sql += " AND FactBackTime >= '" + _beginTime + "' "; txtBeginTime.Text = _beginTime; } else { sql += " AND FactBackTime >= '" + DateTime.Now.AddMonths(-1) + "' "; txtBeginTime.Text = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(_endTime)) { sql += " AND FactBackTime <= '" + _endTime + "' "; txtEndTime.Text = _endTime; } else { sql += " AND FactBackTime <= '" + DateTime.Now + "' "; txtEndTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); } string ids = string.Empty; BLL.TransportOrder bll = new BLL.TransportOrder(); DataSet tods = bll.GetList(sql); if (tods != null && tods.Tables[0].Rows.Count > 0) { foreach (DataRow dr in tods.Tables[0].Rows) { ids += dr["Id"].ToString() + ","; totalFactRepayment += Utils.StrToDecimal(dr["FactRepayment"].ToString(), 0.00M); totalCarriage += Utils.StrToDecimal(dr["Carriage"].ToString(), 0.00M); totalAdvance += Utils.StrToDecimal(dr["Advance"].ToString(), 0.00M); } if (ids.EndsWith(",")) { ids = ids.TrimEnd(','); } } if (!string.IsNullOrEmpty(ids)) { BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataSet itemds = itemBll.GetList(" TransportOrderId IN (" + ids + ") "); if (itemds != null && itemds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in itemds.Tables[0].Rows) { totalIncome += Utils.StrToDecimal(dr["TotalPrice"].ToString(), 0.00M); } } BLL.Consumption cBll = new BLL.Consumption(); DataSet cds = cBll.GetSumList(" TransportOrderId IN (" + ids + ") "); if (cds != null && cds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in cds.Tables[0].Rows) { totalCostItem += Utils.StrToDecimal(dr["TotalMoney"].ToString(), 0.00M); costItem += "<tr><td width=\"20%\" style=\"text-align:right\">"+dr["Name"].ToString()+" : </td>"; costItem += "<td>¥" + string.Format("{0:N2}", dr["TotalMoney"]) + "</td></tr>"; } } } //throw new Exception("totalIncome:" + totalIncome.ToString() // + "totalFactRepayment:" + totalFactRepayment.ToString() // + "totalCarriage:" + totalCarriage.ToString() // + "totalAdvance:" + totalAdvance.ToString() // + "totalCostItem:" + totalCostItem.ToString() // ); totalGain = totalIncome + totalFactRepayment - totalCarriage - totalAdvance - totalCostItem; }
private void RptBind() { string sql = " Status = 3 "; if (!string.IsNullOrEmpty(_beginTime)) { sql += " AND FactBackTime >= '" + _beginTime + "' "; txtBeginTime.Text = _beginTime; } else { sql += " AND FactBackTime >= '" + DateTime.Now.AddMonths(-1) + "' "; txtBeginTime.Text = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(_endTime)) { sql += " AND FactBackTime <= '" + _endTime + "' "; txtEndTime.Text = _endTime; } else { sql += " AND FactBackTime <= '" + DateTime.Now + "' "; txtEndTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); } string ids = string.Empty; BLL.TransportOrder bll = new BLL.TransportOrder(); DataSet tods = bll.GetList(sql); if (tods != null && tods.Tables[0].Rows.Count > 0) { foreach (DataRow dr in tods.Tables[0].Rows) { ids += dr["Id"].ToString() + ","; totalFactRepayment += Utils.StrToDecimal(dr["FactRepayment"].ToString(), 0.00M); totalCarriage += Utils.StrToDecimal(dr["Carriage"].ToString(), 0.00M); totalAdvance += Utils.StrToDecimal(dr["Advance"].ToString(), 0.00M); } if (ids.EndsWith(",")) { ids = ids.TrimEnd(','); } } if (!string.IsNullOrEmpty(ids)) { BLL.TransportOrderItem itemBll = new BLL.TransportOrderItem(); DataSet itemds = itemBll.GetList(" TransportOrderId IN (" + ids + ") "); if (itemds != null && itemds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in itemds.Tables[0].Rows) { totalIncome += Utils.StrToDecimal(dr["TotalPrice"].ToString(), 0.00M); } } BLL.Consumption cBll = new BLL.Consumption(); DataSet cds = cBll.GetSumList(" TransportOrderId IN (" + ids + ") "); if (cds != null && cds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in cds.Tables[0].Rows) { totalCostItem += Utils.StrToDecimal(dr["TotalMoney"].ToString(), 0.00M); costItem += "<tr><td width=\"20%\" style=\"text-align:right\">" + dr["Name"].ToString() + " : </td>"; costItem += "<td>¥" + string.Format("{0:N2}", dr["TotalMoney"]) + "</td></tr>"; } } } //throw new Exception("totalIncome:" + totalIncome.ToString() // + "totalFactRepayment:" + totalFactRepayment.ToString() // + "totalCarriage:" + totalCarriage.ToString() // + "totalAdvance:" + totalAdvance.ToString() // + "totalCostItem:" + totalCostItem.ToString() // ); totalGain = totalIncome + totalFactRepayment - totalCarriage - totalAdvance - totalCostItem; }