示例#1
0
    protected DataTable GetAllTransInfoByReferenceCode()
    {
        List <string> ssReferenceCodeFINAL = new List <string>();

        ssReferenceCodeFINAL = (List <string>)Session["ssReferenceCode"];
        string stReferenceCode1 = string.Empty;
        string stReferenceCode2 = string.Empty;

        for (int i = 0; i < ssReferenceCodeFINAL.Count; i++)
        {
            if (i == 0)
            {
                stReferenceCode2 = stReferenceCode1.ToString() + ssReferenceCodeFINAL[i].ToString();
            }
            else
            {
                stReferenceCode2 = stReferenceCode1.ToString() + "," + ssReferenceCodeFINAL[i].ToString();
            }
            stReferenceCode1 = stReferenceCode2;
        }
        dt = new DataTable();
        dt = sqlTRANSProvider.GetAllTransInfoByReferenceCodeForReport(stReferenceCode1);
        return(dt);
    }
示例#2
0
 protected DataTable GetAllTransInfoByReferenceCode()
 {
     dt = new DataTable();
     dt = sqlTRANSProvider.GetAllTransInfoByReferenceCodeForReport(txtReferenceCode.Text);
     return(dt);
 }
示例#3
0
 protected DataTable GetAllTransInfoByReferenceCode()
 {
     dt = new DataTable();
     dt = sqlTRANSProvider.GetAllTransInfoByReferenceCodeForReport("11AFS140,11AFS141,11AFS142");
     return(dt);
 }