/// <summary>
/// 加载金额预算信息
/// </summary>
private void LoadMoney()
{
decimal zje = 0; //总金额
decimal zyzf = 0; //总已支付金额
decimal zkzf = 0; //总可支付金额
this.pages.Visible = true;
DataTable tbl = Exists();
sqlstr += Session["query"].ToString();
int pitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet set = data.DataPage("DepartMoney", "ID", "*", sqlstr, "ID", true, pitem, pcount, pages);
this.moneylist.DataSource = set;
this.moneylist.DataBind();
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
zje += set.Tables[0].Rows[i]["amount"].ToString() == "" ? 0 : Convert.ToDecimal(set.Tables[0].Rows[i]["amount"]); //累加总金额
zyzf += set.Tables[0].Rows[i]["haspay"].ToString() == "" ? 0 : Convert.ToDecimal(set.Tables[0].Rows[i]["haspay"]); //累加总可支付金额
}
zkzf = zje - zyzf;
this.zzje.Text = zje.ToString("0.00");
this.zyzf.Text = zyzf.ToString("0.00");
this.zkzf.Text = zkzf.ToString("0.00");
}
/// <summary>
/// 查询显示报销单的数据
/// </summary>
private void LoadReimbursementFormData()
{
this.pages.Visible = true;
DataTable tbl = Exists();
string str = "";
int login = ((EtNet_Models.LoginInfo)Session["login"]).Id;
string strlist = EtNet_BLL.LoginDataLimitManager.GetLimit(login);
if (strlist == null || strlist.Trim() == "")
{
str = " AND founderid in(" + login + ")";
}
else
{
str = " AND founderid in(" + login + "," + strlist + ")";
}
str += Session["query"].ToString();
int pitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet set = data.DataPage("ViewAusRottenInfo", "id", "*", str, "id", true, pitem, pcount, pages);
this.rptdata.DataSource = set;
this.rptdata.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
private void BindData()
{
int count = Convert.ToInt32(ConfigurationManager.AppSettings["CMSCount"]);
int page = Convert.ToInt32(ConfigurationManager.AppSettings["CMSPage"]);
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet ds = data.DataPage("ViewAusRottenInfo", "id", "*", "", "id", true, count, page, pages);
rpPoliy.DataSource = ds;
rpPoliy.DataBind();
}
/// <summary>
/// 加载订单收款信息
/// </summary>
private void LoadOrderInfo()
{
//CutPayList cList = (CutPayList)Context.Handler;
string id = Request.QueryString["id"];
id = "(" + id + ")";
string sort = Request.QueryString["sort"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
switch (sort)
{
case "0":
this.czy.Visible = false;
string sql = " and collectId in " + id;
DataSet ds = data.DataPage("View_OrderAndClollect", "collectId", "*", sql, "orderNum", false, 5, 5, pages);
payRepeater.DataSource = ds;
payRepeater.DataBind();
sql = " 1=1 " + sql;
DataTable dt0 = To_OrderInfoManager.GetViewOrderAndCollect("sum(adultNum)+sum(childNum) as num,sum(lirun) as lirun", sql);
if (dt0.Rows.Count > 0)
{
this.sumNum.InnerText = dt0.Rows[0]["num"].ToString();
this.sumlirun.InnerText = dt0.Rows[0]["lirun"].ToString();
}
break;
case "1":
this.ywy.Visible = false;
string str = " and id in " + id;
DataSet dt = data.DataPage("To_orderInfo", "id", "*", str, "orderNum", false, 5, 5, pages);
czyRepeater.DataSource = dt;
czyRepeater.DataBind();
str = " 1=1 " + str;
DataTable dt1 = To_OrderInfoManager.getList("sum(inputerTc) as inputerTc", str);
if (dt1.Rows.Count > 0)
{
this.suminputerTc.InnerText = dt1.Rows[0]["inputerTc"].ToString();
}
break;
}
}
/// <summary>
/// 加载订单信息
/// </summary>
private void LoadOrderInfo()
{
string id = Request.QueryString["id"];
id = "(" + id + ")";
string sql = " and orderid in " + id;
sql += Session["invoiceQuery"]; //收款单位
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet ds = data.DataPage("View_OrderAndClollect", "orderid", "*", sql, "orderNum", false, 5, 5, pages);
payRepeater.DataSource = ds;
payRepeater.DataBind();
}
/// <summary>
/// 加载综合比率信息
/// </summary>
public void LoadRate()
{
this.pages.Visible = true;
DataTable tbl = Exists(); //页面设置信息
string sql = "";
sql += Session["query"].ToString();
int pitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet ds = data.DataPage("LoginProdRate", "id", "*", sql, "id", false, pitem, pcount, pages);
this.ratelist.DataSource = ds;
this.ratelist.DataBind();
}
/// <summary>
/// 查询显示所有报销明细数据
/// </summary>
private void LoadAllAusDetial()
{
this.pages.Visible = true;
double zje = 0;
DataTable tbl = Exists();
string str = "";
int login = ((LoginInfo)Session["login"]).Id;
string strlist = LoginDataLimitManager.GetLimit(login);
if (strlist == null || strlist.Trim() == "")
{
str = " AND founderid in (" + login + ")";
}
else
{
str = " AND founderid in (" + login + "," + strlist + ")";
}
str += Session["query"];
int pitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
int pcount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
DataSet set = data.DataPage("View_AllAusDetial", "bxdh", "*", str, "applydate", true, pitem, pcount, pages);
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
zje += set.Tables[0].Rows[i]["ausmoney"].ToString() == "" ? 0.00 : Convert.ToDouble(set.Tables[0].Rows[i]["ausmoney"]);
}
this.rptdata.DataSource = set;
this.rptdata.DataBind();
this.zje.Text = zje.ToString("0.00");
}