public void GetBind()
{
Remove();
if (Request.QueryString["flag"] != "" && Request.QueryString["flag"] != null)
{
string flag = Request.QueryString["flag"].ToString();
if (flag == "cInv")
{
GetcInv();
}
else if (flag == "cCus")
{
GetcCus();
}
}
GridViewDataColumn column1 = ASPxGridViewSel.Columns[0] as GridViewDataColumn;
for (int i = 0; i < ASPxGridViewSel.VisibleRowCount; i++)
{
CheckBox chk = (CheckBox)ASPxGridViewSel.FindRowCellTemplateControl(i, column1, "CheckBox1");
if (chk != null)
{
chk.Attributes.Add("onchange", "javascript:CheckBoxChange('" + chk.ClientID + "')");
}
}
}
public void GetcCus()
{
sSQL = "select cCusCode as iID, cCusName as iName from viewCus where 1=1 ";
if (ASPxTextBox1.Text != "")
{
sSQL = sSQL + " and (cCusCode like '%" + ASPxTextBox1.Text + "%' or cCusName like '%" + ASPxTextBox1.Text + "%')";
}
ASPxGridViewSel.DataSource = clsSQLCommond.ExecQuery(sSQL);
ASPxGridViewSel.DataBind();
}
public void GetcInv()
{
sSQL = "select cInvCCode as iID, cInvCName as iName from viewInvClass where 1=1 ";
if (ASPxTextBox1.Text != "")
{
sSQL = sSQL + " and (cInvCCode like '%" + ASPxTextBox1.Text + "%' or cInvCName like '%" + ASPxTextBox1.Text + "%')";
}
sSQL = sSQL + " and ((len(cInvCCode)=4 and cInvCCode like '02%') or cInvCCode='04' ) group by cInvCCode,cInvCName";
ASPxGridViewSel.DataSource = clsSQLCommond.ExecQuery(sSQL);
ASPxGridViewSel.DataBind();
}
protected void ASPxGridViewSel_PageIndexChanged(object sender, EventArgs e)
{
GridViewDataColumn column1 = ASPxGridViewSel.Columns[0] as GridViewDataColumn;
for (int i = 0; i < ASPxGridViewSel.VisibleRowCount; i++)
{
CheckBox chk = (CheckBox)ASPxGridViewSel.FindRowCellTemplateControl(i, column1, "CheckBox1");
if (chk != null)
{
chk.Attributes.Add("onchange", "javascript:CheckBoxChange('" + chk.ClientID + "')");
}
}
}
