/// <summary>
/// 绑定客户列表数据
/// </summary>
private void BindRpCustomerList()
{
string where = "cusPro = 1 AND used = 1 ";
AspNetPager1.RecordCount = CustomerManager.GetTotalCount(where);
AspNetPager1.NumericButtonCount = 10;
AspNetPager1.PageSize = 10;
RpCustomerList.DataSource = CustomerManager.GetListByPage(where, AspNetPager1.StartRecordIndex, AspNetPager1.EndRecordIndex);
RpCustomerList.DataBind();
}
private void dataBind()
{
string sqlstr = "and cusPro = 1 AND used = 1";
sqlstr += FilterSql;
Data data = new Data();
DataSet ds = data.DataPage("Customer", "Id", "*", sqlstr, "Id", true, 10, 5, pages);
RpCustomerList.DataSource = ds;
RpCustomerList.DataBind();
}
private void dataBind()
{
string sqlstr = "";
sqlstr += FilterSql;
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("Factory", sqlstr);
DataTable dt = data.GetList("Factory", "Id", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
RpCustomerList.DataSource = dt;
RpCustomerList.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
private void dataBind()
{
string payid = Request.QueryString["payid"]; //付款单位id
this.hidlinkname.Value = Request.QueryString["link"]; //存储联系人的列的id
this.hidlinkid.Value = Request.QueryString["linkid"]; //存储联系人id的列的id
string sql = " and factId = " + payid;
Data data = new Data();
DataSet ds = data.DataPage("FactLinkman", "id", "*", sql, "id", true, 10, 5, pages);
RpCustomerList.DataSource = ds;
RpCustomerList.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
private void dataBind()
{
string colid = Request.QueryString["colid"]; //收款单位id
this.hidlink.Value = Request.QueryString["link"]; //存储营业部名称的列的id
this.hidlinkid.Value = Request.QueryString["linkid"]; //存储营业部id的列的id
this.hidlinkname.Value = Request.QueryString["linkname"]; //存储营业部联系人的列的id
string sql = " and customerId = " + colid;
Data data = new Data();
DataSet ds = data.DataPage("CusLinkman", "id", "*", sql, "id", true, 10, 5, pages);
RpCustomerList.DataSource = ds;
RpCustomerList.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
private void dataBind()
{
#region 控制不能选择相同单位的代码
//string cusid = Request.QueryString["Cusid"].ToString().Trim().TrimEnd(',');
//cusid = "'" + cusid + "'";
//string sqlstr = " and Id not in (" + cusid + ")";
#endregion
string sqlstr = "";
sqlstr += FilterSql;
Data data = new Data();
AspNetPager1.RecordCount = data.GetCount("Customer", sqlstr);
DataTable dt = data.GetList("Customer", "Id", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
RpCustomerList.DataSource = dt;
RpCustomerList.DataBind();
}
private void dataBind()
{
string cusname = Request.QueryString["cusName"];
if (!string.IsNullOrEmpty(cusname) && cusname == "c")
{
hidcusname.Value = "c";
}
string sqlstr = "";
sqlstr += FilterSql;
Data data = new Data();
DataTable dt = new DataTable();
AspNetPager1.RecordCount = data.GetCount("Customer", sqlstr);
dt = data.GetList("Customer", "Id", "desc", AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex, sqlstr);
RpCustomerList.DataSource = dt;
RpCustomerList.DataBind();
}
/// <summary>
/// 绑定数据
/// </summary>
private void dataBind()
{
#region 控制不能选择相同的单位代码（目前不用）
//string returnid = Request.QueryString["unit"].ToString().Trim().TrimEnd(',');
//returnid = "'" + returnid + "'";
//string sqlstr = " and id not in (" + returnid + ")";
//sqlstr += FilterSql;
//Data data = new Data();
//DataSet ds = data.DataPage("Factory", "id", "*", sqlstr, "id", true, 10, 5, pages);
//RpCustomerList.DataSource = ds;
//RpCustomerList.DataBind();
#endregion
string sqlstr = "";
sqlstr += FilterSql;
Data data = new Data();
DataSet ds = data.DataPage("Factory", "id", "*", sqlstr, "id", true, 10, 5, pages);
RpCustomerList.DataSource = ds;
RpCustomerList.DataBind();
}
