.aspx page :
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<fieldset>
<legend>***Advance Search***</legend>
<fieldset>
<legend>****Select field****</legend>
<asp:CheckBoxList ID="CheckBoxList1" runat="server" ForeColor="Black"
BackColor="White" BorderColor="Orange" BorderWidth="2" BorderStyle="Double" RepeatColumns="3"
Width="900">
<asp:ListItem Value="Ticket_No" Text="TICKET NO."></asp:ListItem>
<asp:ListItem Value="USER_NAME" Text="USER_NAME"></asp:ListItem>
<asp:ListItem Value="ISSUE_LOG_DATE_TIME" Text="ISSUE RAISE DATE TIME"></asp:ListItem>
<asp:ListItem Value="Issue_Title" Text="ISSUE TITLE "></asp:ListItem>
<asp:ListItem Value="Issue_Detail" Text="ISSUE DETAIL"></asp:ListItem>
<asp:ListItem Value="Issue_Type" Text="ISSUE TYPE"></asp:ListItem>
<asp:ListItem Value="EXPRESS_REMARKS" Text="EXPRESS REMARKS"></asp:ListItem>
<asp:ListItem Value="Issue_Resource" Text="ISSUE RESOURCE"></asp:ListItem>
<asp:ListItem Value="ALLOCATION_DATE_TIME" Text="ALLOCATION DATE TIME "></asp:ListItem>
<asp:ListItem Value="APPLICATION_TYPE" Text="APPLICATION TYPE"></asp:ListItem>
<asp:ListItem Value="APPLICATION" Text="ALLPICATION"></asp:ListItem>
<asp:ListItem Value="RESOURCE_ACCEPT" Text="ACCEPT BY RESOURCE"></asp:ListItem>
<asp:ListItem Value="RESOURCE_ACCEPT_DATE_TIME" Text="RESOURCE ACCEPT DATETIME"></asp:ListItem>
<asp:ListItem Value="ACTION" Text="ACTION"></asp:ListItem>
<asp:ListItem Value="ACTION_DETAL" Text="ACTION DETAIL"></asp:ListItem>
<asp:ListItem Value="RESOURCE_CLOSE_ISSUE_DATETIME" Text="RESOURCE CLOSE DATE TIME"></asp:ListItem>
<asp:ListItem Value="RESOURCE_ALLOCATOR" Text="RESOURCE ALLOCATOR"></asp:ListItem>
<asp:ListItem Value="USER_CLOSE_ISSUE_DATE_TIEM" Text="ISSUE CLOSE BY USER DATE TIME "></asp:ListItem>
<asp:ListItem Value="STATUS" Text="STATUS"></asp:ListItem>
</asp:CheckBoxList>
</fieldset>
<fieldset>
<legend>***Select Perameters</legend>
<table width="100%">
<tr>
<td>
ISSUE RAISE BY USER
</td>
<td>
FROM : 
<asp:TextBox ID="txtFromDate" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtFromDate">
</asp:CalendarExtender>
  TO
 : 
<asp:TextBox ID="txtTodate" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtTodate">
</asp:CalendarExtender>
</td>
</tr>
<tr>
<td>
ISSUE CLOSE BY RESOURCE
</td>
<td>
FROM : 
<asp:TextBox ID="txtICBRF" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender3" runat="server" TargetControlID="txtICBRF">
</asp:CalendarExtender>
  TO
 : 
<asp:TextBox ID="txtICBRT" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender4" runat="server" TargetControlID="txtICBRT">
</asp:CalendarExtender>
</td>
</tr>
<tr>
<td>
ISSUE CLOSE BY USER
</td>
<td>
FROM : 
<asp:TextBox ID="txtICBUF" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender5" runat="server" TargetControlID="txtICBUF">
</asp:CalendarExtender>
  TO
 :  
<asp:TextBox ID="txtICBUT" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender6" runat="server" TargetControlID="txtICBUT">
</asp:CalendarExtender>
</td>
</tr>
<tr>
<td>
<br />
</td>
</tr>
<tr>
<td>
APPLICATION TYPE WISE
</td>
<td>
<asp:DropDownList ID="DDLAPPTYPE2" runat="server" Width="168px" Height="35px">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
APPLICATION WISE
</td>
<td>
<asp:DropDownList ID="ddlApp" runat="server" Width="169px" Height="35px">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
RESOURCE WISE
</td>
<td>
<asp:DropDownList ID="DDLRES" runat="server" Width="171px" Height="35px">
</asp:DropDownList>
</td>
</tr>
</table>
<br />
<center>
<asp:Button ID="btnShow" runat="server" Text="Show" OnClick="btnShow_Click" /></center>
</fieldset>
</fieldset>
</div>
.cs page:
protected void btnShow_Click(object sender, EventArgs e)
{
string name = "";
string str = "select ";
foreach (ListItem li in CheckBoxList1.Items)
{
if (li.Selected == true)
{
name = li.Value.ToString();
str = str + name + ",";
}
}
str = str.Substring(0, str.Length - 1);
str = str + "" + " from showissuelog where ";
string[] filld = new string[6];
string[] oper = new string[6];
string[] val = new string[6];
int k = 0;
if (txtFromDate.Text != "" && txtTodate.Text != "")
{
filld[k] = "ISSUE_LOG_DATE_TIME";
oper[k] = " between "; ;
val[k] = "'" + txtFromDate.Text + "' and '" + txtTodate.Text + "'";
k++;
}
if (txtICBRF.Text != "" && txtICBRT.Text != "")
{
filld[k] = "RESOURCE_CLOSE_ISSUE_DATETIME";
oper[k] = " between "; ;
val[k] = "'" + txtICBRF.Text + "' and '" + txtICBRT.Text + "'";
k++;
}
if (txtICBUF.Text != "" && txtICBUT.Text != "")
{
filld[k] = "USER_CLOSE_ISSUE_DATE_TIEM";
oper[k] = " between "; ;
val[k] = "'" + txtICBUF.Text + "' and '" + txtICBUT.Text + "'";
k++;
}
if (DDLAPPTYPE2.SelectedIndex > 0)
{
filld[k] = "Application_Type_Id";
oper[k] = " = "; ;
val[k] = "'" + DDLAPPTYPE2.SelectedValue + "' ";
k++;
}
if (ddlApp.SelectedIndex > 0)
{
filld[k] = "Application_id";
oper[k] = " = "; ;
val[k] = "'" + ddlApp.SelectedValue + "' ";
k++;
}
if (DDLRES.SelectedIndex > 0)
{
filld[k] = "Issue_Resource";
oper[k] = " = "; ;
val[k] = "'" + DDLRES.SelectedValue + "' ";
k++;
}
for (int i = 0; i < k; i++)
{
str = str + filld[i] + oper[i] + val[i] + " and ";
}
str = str.Substring(0, str.Length - 4);
ds = new DataSet();
ds = objcls.selectds(str);
ER.exlRet(ds);
}
No comments:
Post a Comment