/// <summary>
///[SearchPageSet]表查询实体的方法
/// </summary>
public static SearchPageSet getSearchPageSetById(int id)
{
SearchPageSet searchpageset = null;
string sql = "select * from SearchPageSet where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
searchpageset = new SearchPageSet();
foreach (DataRow dr in dt.Rows)
{
searchpageset.Id = Convert.ToInt32(dr["id"]);
searchpageset.Ownersid = Convert.ToInt32(dr["ownersid"]);
searchpageset.Pagenum = Convert.ToString(dr["pagenum"]);
searchpageset.Pageitem = Convert.ToInt32(dr["pageitem"]);
searchpageset.Pagecount = Convert.ToInt32(dr["pagecount"]);
}
}
return(searchpageset);
}
protected void mgbtnreset_Click(object sender, ImageClickEventArgs e)
{
string sqlstr = "";
Session["query"] = null;
LoginInfo login = (LoginInfo)Session["login"];
string ids = LoginDataLimitManager.GetLimit(login.Id);
if (string.IsNullOrEmpty(ids))
{
sqlstr += " and madefrom = " + login.Id;
}
else
{
sqlstr += " and madefrom in (" + ids + "," + login.Id + ")";
}
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 010);
if (sps == null)
{
Data data = new Data();
DataSet ds = data.DataPage("Company", "Id", "*", sqlstr, "Id", true, 5, 5, pages);
comList.DataSource = ds;
comList.DataBind();
}
else
{
Data data = new Data();
DataSet ds = data.DataPage("Company", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages);
comList.DataSource = ds;
comList.DataBind();
}
}
protected void imgbtnsave_Click(object sender, ImageClickEventArgs e)
{
LoginInfo login = (LoginInfo)Session["login"];
string pagenum = Request.QueryString["pagenum"].ToString();
SearchPageSet pageset = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, Convert.ToInt32(pagenum));
SearchPageSet sps = new SearchPageSet();
sps.Ownersid = ((LoginInfo)Session["login"]).Id;
sps.Pagecount = Convert.ToInt32(this.tbxcount.Text.ToString());
sps.Pageitem = Convert.ToInt32(this.tbxitem.Text.ToString());
sps.Pagenum = pagenum;
if (pageset == null)
{
int count = SearchPageSetManager.addSearchPageSet(sps);
if (count > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "", true);
}
}
else
{
sps.Id = pageset.Id;
int count = SearchPageSetManager.updateSearchPageSet(sps);
if (count > 0)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "", true);
}
}
}
private void bindDatasource()
{
string sqlstr = "";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
string ids = LoginDataLimitManager.GetLimit(login.Id);
if (string.IsNullOrEmpty(ids))
{
sqlstr += " and invoiceCMan = " + login.Id;
}
else
{
sqlstr += " and invoiceCMan in (" + ids + "," + login.Id + ")";
}
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 016);
if (sps == null)
{
Data data = new Data();
DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, 5, 5, pages);
rpInvoice.DataSource = ds;
rpInvoice.DataBind();
}
else
{
Data data = new Data();
DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages);
rpInvoice.DataSource = ds;
rpInvoice.DataBind();
}
}
///// <summary>
///// 加载收款单位
///// </summary>
//private void LoadColUnit()
//{
// this.collectUnit.Items.Clear();
// this.collectUnit.Items.Add(new ListItem("——请选择——", "0"));
// IList<Customer> customers = CustomerManager.getCustomerAll();
// foreach (Customer customer in customers)
// {
// ListItem adItem = new ListItem();
// adItem.Value = customer.Id.ToString();
// adItem.Text = customer.CusshortName;
// this.collectUnit.Items.Add(adItem);
// }
//}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadInvoiceRecordList()
{
LoginInfo login = Session["login"] as LoginInfo;
string sql = " ";
sql += Session["query"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
AspNetPager1.RecordCount = data.GetCount("InvoiceRecord", sql);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 032);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("InvoiceRecord", "makeDate", "asc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);
this.payRepeater.DataSource = dt;
this.payRepeater.DataBind();
}
/// <summary>
/// 绑定收款列表
/// </summary>
private void Load_IncomeList()
{
double zje = 0;
string sqlstr = "";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 035);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("To_Income", sqlstr);
DataTable dt = data.GetList("To_Income", "comeDate", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
inList.DataSource = dt;
inList.DataBind();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
zje += dt.Rows[i]["comeMoney"].ToString() == "" ? 0.00 : Convert.ToDouble(dt.Rows[i]["comeMoney"]);
}
}
this.zje.Text = zje.ToString("0.00");
}
/// <summary>
/// 订单列表
/// </summary>
private void OrderListBind()
{
string sqlstr = "";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
sqlstr += " and inputerID = " + login.Id;
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 013);
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("ViewOrder", sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("ViewOrder", "makerTime", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
cuslist.DataSource = dt;
cuslist.DataBind();
LoadZtreeData();
}
/// <summary>
/// 绑定付费列表数据
/// </summary>
private void BindPaymentList()
{
LoginInfo login = (LoginInfo)Session["login"];
string sqlstr = "";
sqlstr += FilterSql;
string ids = LoginDataLimitManager.GetLimit(login.Id);
if (string.IsNullOrEmpty(ids))
{
sqlstr += " and makerID = " + login.Id;
}
else
{
sqlstr += " and makerID in (" + ids + ")";
}
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 017);
Data data = new Data();
if (sps == null)
{
DataSet ds = data.DataPage("View_PaymentList", "id", "*", sqlstr, "requestDate", true, 10, 5, pages);
RpPaymentList.DataSource = ds;
RpPaymentList.DataBind();
}
else
{
DataSet ds = data.DataPage("View_PaymentList", "id", "*", sqlstr, "requestDate", true, sps.Pageitem, sps.Pagecount, pages);
RpPaymentList.DataSource = ds;
RpPaymentList.DataBind();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static SearchPageSet GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,ownersid,pagenum,pageitem,pagecount from SearchPageSet ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
SearchPageSet model = new SearchPageSet();
DataTable tbl = DBHelper.GetDataSet(strSql.ToString(), parameters);
if (tbl.Rows.Count > 0)
{
model.Id = int.Parse(tbl.Rows[0]["id"].ToString());
model.Ownersid = int.Parse(tbl.Rows[0]["ownersid"].ToString());
model.Pagenum = tbl.Rows[0]["pagenum"].ToString();
model.Pageitem = int.Parse(tbl.Rows[0]["pageitem"].ToString());
model.Pagecount = int.Parse(tbl.Rows[0]["pagecount"].ToString());
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadOrderList()
{
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = Session["login"] as LoginInfo;
if (Session["cutPay"].ToString() != "")
{
string sql = " collectStatus='完成收款' ";
sql += Session["cutPay"].ToString();
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 033);
if (sps != null)
{
this.j_pagesize.Value = sps.Pageitem.ToString();
this.j_pagecount.Value = sps.Pagecount.ToString();
}
this.payRepeater.DataSource = To_OrderInfoManager.GetViewOrderAndCollect("*", sql);
this.payRepeater.DataBind();
}
}
}
/// <summary>
/// 加载数据
/// </summary>
private void LoadData()
{
string sqlstr = " ";
string tablename = this.cbxFileShow.Checked ? "ViewOrderCollectAmountFile": "ViewOrderCollectAmount";
sqlstr += Session["CollectAmountQuery"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 032);
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount(tablename, sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList(tablename, "cusId", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
rptdata.DataSource = dt;
rptdata.DataBind();
//计算金额合计
StringBuilder sqlSelect = new StringBuilder();
sqlSelect.Append("select sum(money) as shouldAmount,sum(collectAmount) as collectAmount,sum(syAmount) as syAmount,sum(countNum) as countamount,sum(adultNum) as adultamount ");
string tblname = tablename;
DataTable dtSum = data.GetSumMoney(sqlSelect.ToString(), tblname, sqlstr);
if (dtSum.Rows.Count > 0)
{
DataRow dr = dtSum.Rows[0];
shouldamount.InnerText = Convert.IsDBNull(dr["shouldAmount"]) ? "" : Convert.ToDouble(dr["shouldAmount"]).ToString("N2");
hasamount.InnerText = Convert.IsDBNull(dr["collectAmount"]) ? "" : Convert.ToDouble(dr["collectAmount"]).ToString("N2");
syamount.InnerText = Convert.IsDBNull(dr["syAmount"]) ? "" : Convert.ToDouble(dr["syAmount"]).ToString("N2");
countamount.InnerText = Convert.IsDBNull(dr["countamount"]) ? "" : Convert.ToDouble(dr["countamount"]).ToString("N2");
adultamount.InnerText = Convert.IsDBNull(dr["adultamount"]) ? "" : Convert.ToDouble(dr["adultamount"]).ToString("N2");
}
//double a = 0;
//double b = 0;
//double c = 0;
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// a += Convert.IsDBNull(dt.Rows[i]["money"]) ? 0 : Convert.ToDouble(dt.Rows[i]["money"]);
// b += Convert.IsDBNull(dt.Rows[i]["collectAmount"]) ? 0 : Convert.ToDouble(dt.Rows[i]["collectAmount"]);
// c += Convert.IsDBNull(dt.Rows[i]["syAmount"]) ? 0 : Convert.ToDouble(dt.Rows[i]["syAmount"]);
//}
//this.shouldamount.InnerText = a.ToString("F2");
//this.hasamount.InnerText = b.ToString("F2");
//this.syamount.InnerText = c.ToString("F2");
}
private void ExpenseListBind()
{
string sqlstr = " 1=1 ";
sqlstr += Session["query"].ToString();
DataTable dt0 = initializeDataTable().Copy();
DataRow[] rows = dt0.Select(sqlstr);
DataTable dt = dt0.Clone();
foreach (DataRow row in rows)
{
dt.ImportRow(row);
}
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 210);
AspNetPager1.RecordCount = dt.Rows.Count;
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
rptexpens.DataSource = SplitDataTable(dt, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize);
rptexpens.DataBind();
#region
//string sqlstr = "";
//if (!string.IsNullOrEmpty(Request.QueryString["bankid"]))
// sqlstr += " and comebankid = " + Request.QueryString["bankid"];
//sqlstr += Session["query"].ToString();
//LoginInfo login = (LoginInfo)Session["login"];
//SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 210);
//Data data = new Data();
//AspNetPager1.RecordCount = data.GetCount("ViewExpense", sqlstr);
//if (sps == null)
//{
// AspNetPager1.NumericButtonCount = 10;
// AspNetPager1.PageSize = 10;
//}
//else
//{
// AspNetPager1.NumericButtonCount = sps.Pagecount;
// AspNetPager1.PageSize = sps.Pageitem;
//}
//DataTable dt = data.GetList("ViewExpense", "comedate", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
//rptexpens.DataSource = dt;
//rptexpens.DataBind();
#endregion
}
/// <summary>
/// 加载订单数据
/// </summary>
private void LoadOrderCollect()
{
if (Session["MyOrderQuery"].ToString() != "")
{
string sqlstr = " and iscancel='N'";//0510 修改作废的订单不显示
sqlstr += Session["MyOrderQuery"].ToString();
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = (LoginInfo)Session["login"];
//string ids = LoginDataLimitManager.GetLimit(login.Id);
//if (string.IsNullOrEmpty(ids))
// sqlstr += " and salemanid = " + login.Id;
//else
// sqlstr += " and salemanid in (" + ids + ")";
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 034);
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("View_OrderAndClollect", sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("View_OrderAndClollect", "outTime", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
orderRepeater.DataSource = dt;
orderRepeater.DataBind();
//计算合计
DataTable dtsum = To_OrderInfoManager.GetViewOrderAndCollect(" sum(adultNum) as adult_sum,sum(childNum) as child_sum,sum(withNum) as with_sum,sum(pNum) as pnum_sum,sum(lirun) as lirun_sum,sum(money) as money_sum ", " 1=1 " + sqlstr);
if (dtsum.Rows.Count > 0)
{
this.adult_sum.InnerHtml = dtsum.Rows[0]["adult_sum"].ToString();
this.child_sum.InnerHtml = dtsum.Rows[0]["child_sum"].ToString();
this.with_sum.InnerHtml = dtsum.Rows[0]["with_sum"].ToString();
this.pnum_sum.InnerHtml = dtsum.Rows[0]["pnum_sum"].ToString();
this.lirun_sum.InnerHtml = dtsum.Rows[0]["lirun_sum"].ToString();
this.money_sum.InnerHtml = dtsum.Rows[0]["money_sum"].ToString();
}
}
}
else
{
orderRepeater.DataSource = null;
orderRepeater.DataBind();
this.adult_sum.InnerHtml = this.child_sum.InnerHtml = this.with_sum.InnerHtml = this.pnum_sum.InnerHtml = this.lirun_sum.InnerHtml = this.money_sum.InnerHtml = "";
}
}
/// <summary>
///[SearchPageSet]表添加的方法
/// </summary>
public static int addSearchPageSet(SearchPageSet searchpageset)
{
string sql = "insert into SearchPageSet([ownersid],[pagenum],[pageitem],[pagecount]) values (@ownersid,@pagenum,@pageitem,@pagecount)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@ownersid", searchpageset.Ownersid),
new SqlParameter("@pagenum", searchpageset.Pagenum),
new SqlParameter("@pageitem", searchpageset.Pageitem),
new SqlParameter("@pagecount", searchpageset.Pagecount)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[SearchPageSet]表修改的方法
/// </summary>
public static int updateSearchPageSetById(SearchPageSet searchpageset)
{
string sql = "update SearchPageSet set ownersid=@ownersid,pagenum=@pagenum,pageitem=@pageitem,pagecount=@pagecount where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", searchpageset.Id),
new SqlParameter("@ownersid", searchpageset.Ownersid),
new SqlParameter("@pagenum", searchpageset.Pagenum),
new SqlParameter("@pageitem", searchpageset.Pageitem),
new SqlParameter("@pagecount", searchpageset.Pagecount)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
/// 取原有的数据
/// </summary>
private void GetData()
{
LoginInfo login = (LoginInfo)Session["login"];
string pagenum = Request.QueryString["pagenum"].ToString();
SearchPageSet pageset = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, Convert.ToInt32(pagenum));
if (pageset == null)
{
this.tbxitem.Text = "";
this.tbxcount.Text = "";
}
else
{
this.tbxcount.Text = pageset.Pagecount.ToString();
this.tbxitem.Text = pageset.Pageitem.ToString();
}
}
/// <summary>
/// 加载数据
/// </summary>
private void LoadData()
{
string unitID = Request.QueryString["unit"]; //付款单位id
string sqlstr = " and iscancel = 'N' ";
sqlstr += this.cbxFileShow.Checked ? "" : " and fileStatus=0 ";
sqlstr += " and factid=" + unitID;
sqlstr += Session["payDetailQuery"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 033);
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("View_OrderPayAndReturn", sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("View_OrderPayAndReturn", "outTime", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
rptdata.DataSource = dt;
rptdata.DataBind();
thissqlstr = sqlstr + " order by outTime desc";
//计算金额合计
StringBuilder sqlSelect = new StringBuilder();
sqlSelect.Append("select sum(money) as shouldAmount,sum(payAmount) as payAmount,sum(syAmount) as syAmount ");
string tblname = "View_OrderPayAndReturn";
DataTable dtSum = data.GetSumMoney(sqlSelect.ToString(), tblname, sqlstr);
if (dtSum.Rows.Count > 0)
{
DataRow dr = dtSum.Rows[0];
shouldamount.InnerText = Convert.IsDBNull(dr["shouldAmount"]) ? "" : Convert.ToDouble(dr["shouldAmount"]).ToString("N2");
hasamount.InnerText = Convert.IsDBNull(dr["payAmount"]) ? "" : Convert.ToDouble(dr["payAmount"]).ToString("N2");
syamount.InnerText = Convert.IsDBNull(dr["syAmount"]) ? "" : Convert.ToDouble(dr["syAmount"]).ToString("N2");
}
}
/// <summary>
/// 绑定收款单据列表数据
/// </summary>
private void BindRpList()
{
double zje = 0;
if (Session["login"] == null)
{
Response.Redirect("~/Login.aspx", true);
}
else
{
LoginInfo login = Session["login"] as LoginInfo;
AspNetPager1.RecordCount = To_CollectingManager.GetTotalCount(FilterSql, login.Id);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 019);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
if (HttpContext.Current.Request.QueryString["page"] != null)
{
AspNetPager1.CurrentPageIndex = int.Parse(HttpContext.Current.Request.QueryString["page"]);
}
collectingList = To_CollectingManager.GetListByPage(FilterSql, login.Id, AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
//5.31 增加总计的计算
if (collectingList.Count > 0 && collectingList != null)
{
foreach (To_Collecting cl in collectingList)
{
zje += cl.ReceiptAmount.ToString() == "" ? 0.00 : Convert.ToDouble(cl.ReceiptAmount.ToString());
}
}
RpList.DataSource = collectingList;
RpList.DataBind();
this.zje.Text = "￥" + zje.ToString("0.00");
}
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
public static SearchPageSet getSearchPageSetBySql(string sql)
{
SearchPageSet searchpageset = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
searchpageset = new SearchPageSet();
foreach (DataRow dr in dt.Rows)
{
searchpageset.Id = Convert.ToInt32(dr["id"]);
searchpageset.Ownersid = Convert.ToInt32(dr["ownersid"]);
searchpageset.Pagenum = Convert.ToString(dr["pagenum"]);
searchpageset.Pageitem = Convert.ToInt32(dr["pageitem"]);
searchpageset.Pagecount = Convert.ToInt32(dr["pagecount"]);
}
}
return(searchpageset);
}
/// <summary>
/// 绑定
/// </summary>
private void bindData()
{
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 027);
if (sps == null)
{
EtNet_BLL.DataPage.Data data = new Data();
DataSet ds = data.DataPage("LoginInfo", "id", "*", str, "loginid", false, 10, 10, pages);
rploginUser.DataSource = ds;
rploginUser.DataBind();
}
else
{
EtNet_BLL.DataPage.Data data = new Data();
DataSet ds = data.DataPage("LoginInfo", "id", "*", str, "loginid", false, sps.Pageitem, sps.Pagecount, pages);
rploginUser.DataSource = ds;
rploginUser.DataBind();
}
}
/// <summary>
///根据SQL语句获取集合
/// </summary>
public static IList <SearchPageSet> getSearchPageSetsBySql(string sql)
{
IList <SearchPageSet> list = new List <SearchPageSet>();
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
SearchPageSet searchpageset = new SearchPageSet();
searchpageset.Id = Convert.ToInt32(dr["id"]);
searchpageset.Ownersid = Convert.ToInt32(dr["ownersid"]);
searchpageset.Pagenum = Convert.ToString(dr["pagenum"]);
searchpageset.Pageitem = Convert.ToInt32(dr["pageitem"]);
searchpageset.Pagecount = Convert.ToInt32(dr["pagecount"]);
list.Add(searchpageset);
}
}
return(list);
}
/// <summary>
/// 绑定标的属性列表（repeater控件）
/// </summary>
private void RpPropertyBindData(int targetTypeId)
{
TargetPropertyManager tpManager = new TargetPropertyManager();
string where = string.Format("TargetTypeId = {0}", targetTypeId);
AspNetPager1.RecordCount = tpManager.GetRecordCount(where);
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 011);
if (sps != null)
{
AspNetPager1.PageSize = sps.Pageitem;
AspNetPager1.NumericButtonCount = sps.Pagecount;
}
else
{
AspNetPager1.PageSize = 10;
AspNetPager1.NumericButtonCount = 10;
}
rpTargetProperty.DataSource = tpManager.GetListByPage(where, "TargetTypeId", AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
rpTargetProperty.DataBind();
}
/// <summary>
/// 加载付款申请数据
/// </summary>
private void LoadPayList()
{
LoginInfo login = Session["login"] as LoginInfo;
if (!string.IsNullOrEmpty(Session["payQuery"].ToString()) || !string.IsNullOrEmpty(Session["query"].ToString()))//--0429 更改
{
//}
//if (Session["payQuery"].ToString() != "" || Session["query"].ToString() != "")//原方法报错
//{
string sql = " and auditstatus = '04' ";
sql += Session["payQuery"];
sql += Session["query"];
EtNet_BLL.DataPage.Data data = new EtNet_BLL.DataPage.Data();
AspNetPager1.RecordCount = data.GetCount("View_PaymentList", sql);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 040);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
//0429 修改 为了排序顺序
// DataTable dt = new EtNet_BLL.RegReimbursementManager().GetListpage(" auditstatus = '04'" + Session["payQuery"] + Session["query"], "regType asc,confirmDate DESC", AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
DataTable dt = data.GetpageList("View_PaymentList", " regType asc,confirmDate DESC ", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);
// DataTable dt = data.GetList("View_PaymentList", "isConfirm", "asc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sql);//原方法
this.payRepeater.DataSource = dt;
this.payRepeater.DataBind();
}
else
{
this.payRepeater.DataSource = null;
this.payRepeater.DataBind();
}
}
/// <summary>
/// 绑定
/// </summary>
private void dataBind()
{
string sqlstr = "";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
//string ids = LoginDataLimitManager.GetLimit(login.Id);
//if (string.IsNullOrEmpty(ids))
//{
// sqlstr += " and madefrom = " + login.Id;
//}
//else
//{
// sqlstr += " and madefrom in (" + ids + "," + login.Id + ")";
//}
//sqlstr += " AND (madefrom = " + login.Id + " OR ";
//sqlstr += " ',' + viewidlist + ',' like " + "'%," + login.Id + ",%' )";
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 013);
if (sps == null)
{
Data data = new Data();
DataSet ds = data.DataPage("ViewCustomer", "Id", "*", sqlstr, "Id", true, 10, 15, pages);
cuslist.DataSource = ds;
cuslist.DataBind();
}
else
{
Data data = new Data();
DataSet ds = data.DataPage("ViewCustomer", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages);
cuslist.DataSource = ds;
cuslist.DataBind();
}
}
/// <summary>
/// 订单列表
/// </summary>
private void OrderListBind()
{
string sqlstr = this.checkfile.Checked ? " " : " and fileStatus=0 ";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
string ids = LoginDataLimitManager.GetLimit(login.Id);
if (string.IsNullOrEmpty(ids))
{
sqlstr += " and (markid = " + login.Id + " or inputerId= " + login.Id + ") ";
}
else
{
sqlstr += " and (inputerId in (" + ids + ") or markid= " + login.Id + ") ";//0419修改，将查看数据权限更改为可查看操作员数据
}
//sqlstr += " or inputerID = " + login.Id; //操作员也能看到其对应的订单信息
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 013);
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("ViewOrder", sqlstr);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dt = data.GetList("ViewOrder", "makerTime", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
cuslist.DataSource = dt;
cuslist.DataBind();
LoadZtreeData();
}
private void dataBind()
{
LoginInfo currentLogin = Session["login"] as LoginInfo;
int pitem = 0;
int pcount = 0;
SearchPageSet set = SearchPageSetManager.getSearchPageSetByLoginId(currentLogin.Id, 024);
if (set != null)
{
pitem = set.Pageitem;
pcount = set.Pagecount;
}
else
{
pitem = 10;
pcount = 10;
}
EtNet_BLL.DataPage.Data data = new Data();
DataSet ds = data.DataPage("IncomeType", "id", "*", "", "id", true, pitem, pcount, pages);
typeList.DataSource = ds;
typeList.DataBind();
}
/// <summary>
/// 加载通讯录数据
/// </summary>
private void LoadAddressList()
{
string sqlstr = "";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 002);
if (sps == null)
{
Data data = new Data();
DataSet ds = data.DataPage("ViewAddressList", "Id", "*", sqlstr, "Id", true, 5, 5, pages);
rptdata.DataSource = ds;
rptdata.DataBind();
}
else
{
Data data = new Data();
DataSet ds = data.DataPage("ViewAddressList", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages);
rptdata.DataSource = ds;
rptdata.DataBind();
}
}
/// <summary>
/// 加载数据
/// </summary>
private void RpPolicyBindData()
{
AspNetPager1.RecordCount = To_PolicyManager.GetCount(FilterSql, (Session["login"] as LoginInfo).Id) ?? 0;
LoginInfo login = Session["login"] as LoginInfo;
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 015);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable dtPolicy = To_PolicyManager.GetListByPage(null, (Session["login"] as LoginInfo).Id, "", FilterSql, AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
RpPolicy.DataSource = dtPolicy;
RpPolicy.DataBind();
}
protected void mgbtnreset_Click1(object sender, ImageClickEventArgs e)
{
string sqlstr = "";
sqlstr += Session["query"].ToString();
LoginInfo login = (LoginInfo)Session["login"];
string ids = LoginDataLimitManager.GetLimit(login.Id);
if (string.IsNullOrEmpty(ids))
{
sqlstr += " and invoiceCMan = " + login.Id;
}
else
{
sqlstr += " and invoiceCMan in (" + ids + "," + login.Id + ")";
}
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 016);
if (sps == null)
{
Data data = new Data();
DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, 5, 5, pages);
rpInvoice.DataSource = ds;
rpInvoice.DataBind();
}
else
{
Data data = new Data();
DataSet ds = data.DataPage("to_Invoice", "Id", "*", sqlstr, "Id", true, sps.Pageitem, sps.Pagecount, pages);
rpInvoice.DataSource = ds;
rpInvoice.DataBind();
}
this.txtBeginDate.Value = ""; this.txtEndDate.Value = ""; this.txtInvoiceID.Value = ""; this.txtPrice.Value = ""; this.txtUnit.Value = "";
}
/// <summary>
/// 绑定收款单据列表数据
/// </summary>
private void BindRpList()
{
LoginInfo login = Session["login"] as LoginInfo;
AspNetPager1.RecordCount = To_CollectingManager.GetTotalCountByLimit(FilterSql + " AND confirmReceipt=1 ", login.Id);
SearchPageSet sps = SearchPageSetManager.getSearchPageSetByLoginId(login.Id, 018);
if (sps == null)
{
AspNetPager1.NumericButtonCount = 5;
AspNetPager1.PageSize = 5;
}
else
{
AspNetPager1.NumericButtonCount = sps.Pagecount;
AspNetPager1.PageSize = sps.Pageitem;
}
DataTable data = To_CollectingManager.GetListByLimit(FilterSql + " AND confirmReceipt=1 ", login.Id, AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
RpList.DataSource = data;
RpList.DataBind();
}
