DATALIST正反向排序,带▲和▼提示的【转一】

来源：互联网发布：免费的婚恋软件编辑：程序博客网时间：2024/05/16 01:35

<%@ Page language="c#" src="remark.aspx.cs" AutoEventWireup="false" Inherits="src.Mainlist" %>
<HTML>
<HEAD> </HEAD>
<body leftMargin="0" topMargin="0" rightMargin="0" width="190%">
   <form id="Form1" method="post" runat="server">
        <table width="190%" border="0" cellpadding="0" cellspacing="1" >
     <tr>

      <td bgcolor="#ffffff">

</tr>
</table>

<asp:datalist id="DL_Main" runat="server" OnSortCommand="MyDataGrid_Sort" AllowSorting="true" Width="100%">
<AlternatingItemStyle BackColor="#ececec"></AlternatingItemStyle>
<HeaderTemplate>

</HeaderTemplate> <ItemTemplate>
        <table style="TABLE-LAYOUT: fixed; WORD-BREAK: break-all" bordercolor="#ffffff" height="22"
          cellspacing="1" cellpadding="1" width="100%">
          <tr>

            <td width="80" align="center">
<input size="9" value="<%# DataBinder.Eval(Container.DataItem, "pono")%>" readonly="true" tabindex="2" style="text-align=center;border:1px solid # 999999">

            </td>

          </tr>
        </table>
         </ItemTemplate>
</asp:datalist>

<table height="10" cellSpacing="2" cellPadding="0" width="100%" bgColor="#718BD6" border="0">
<tr>
<td align="center" width="80"><a href="datagrid2.aspx">轉到EXCEL</a></td>
<td align="center" width="60"><asp:Button id="Button1" Visible='<%# Session["UPower"].ToString()=="1"%>' runat="server" Text="發送" Height="24px"></asp:Button><asp:Button id="Button2" runat="server" Width="0px" ></asp:Button></td>
<td align="center" width="100">所有發送<input type="checkbox" name="chkall" value="on" onclick="CheckAll(this.form)" title='選中/取消所有'></td>
<td align="left">共有
<asp:label id="lblRecordCount" runat="server" ForeColor="red"></asp:label>條記錄 當前為
<asp:label id="lblCurrentPage" runat="server" ForeColor="red"></asp:label>/
<asp:label id="lblPageCount" runat="server" ForeColor="red"></asp:label>頁
<asp:HyperLink id="lnkPrev" runat="server">上一頁</asp:HyperLink>
<asp:HyperLink id="lnkNext" runat="server">下一頁</asp:HyperLink>轉到第
<asp:textbox id="TextBox1" runat="server" Width="25px">1</asp:textbox>頁
<asp:button id="Button5" OnClick="SubmitBtn_Click5" runat="server" Width="20px" Text="轉"></asp:button>
</td>

</tr>
</table>

</td>
</tr>
</table>
</form>
</body>
</HTML>
------------------------------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Configuration;

namespace src
{
/// <summary>
/// Mainlist 的摘要说明。
/// </summary>
        public class DBOperate
{
   public DBOperate()
   {
    //
    // TODO: 在此处添加构造函数逻辑
    //
   }

   //输入SELECT语句，获得返回数据集
   public static DataTable SelectFormForum(string sql,int start,int size,string tablename)
   {
    try
    {
     SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["data"]);
     SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConnection);
     DataSet returns = new DataSet();
     sqlAdapter1.Fill(returns,start,size,tablename);

                          string status;
                          for(int i=0;i<returns.Tables[0].Rows.Count;i++)
                          {
                          status=returns.Tables[0].Rows[i]["status"].ToString().Trim();
                           if (status=="2")
                           {
                           returns.Tables[0].Rows[i]["status"]="已簽回";
                           }
                           if (status=="1")
                           {
                           returns.Tables[0].Rows[i]["status"]="再協商";
                           }
                           if (status=="0")
                           {
                           returns.Tables[0].Rows[i]["status"]="新單";
                           }
                  if (status=="3")
                           {
                           returns.Tables[0].Rows[i]["status"]="已驗貨";
                           }
                  if (status=="4")
                           {
                           returns.Tables[0].Rows[i]["status"]="已收貨";
                           }
                  if (status=="5")
                           {
                           returns.Tables[0].Rows[i]["status"]="已結案";
                           }
                  if (status=="6")
                           {
                           returns.Tables[0].Rows[i]["status"]="已作廢";
                           }
                          }
                          string status3;
                          for(int i=0;i<returns.Tables[0].Rows.Count;i++)
                          {
                          status3=returns.Tables[0].Rows[i]["status3"].ToString().Trim();
                           if (status3=="0")
                           {
                           returns.Tables[0].Rows[i]["status3"]="未發送";
                           }
                           if (status3=="1")
                           {
                           returns.Tables[0].Rows[i]["status3"]="OK";
         //returns.Tables[0].Rows[i]["part"]="-->"+returns.Tables[0].Rows[i]["part"];
                           }
        }
           return returns.Tables[0];
    }
    catch (Exception ex)
    {
     throw (ex);
    }
   }

   public static DataTable SelectFormForum1(string sql)
   {
    try
    {
     SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["data"]);
     SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConnection);
     DataSet returns = new DataSet();
     sqlAdapter1.Fill(returns);
     return returns.Tables[0];
    }
    catch (Exception ex)
    {
     throw (ex);
    }
   }

   //返回一条记录
   public static DataRow GetDataRow(string sql,string TableName)
   {
    try
    {
     SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["data"]);
     SqlDataAdapter sqlAdapter1 = new SqlDataAdapter(sql, sqlConnection);
     DataSet product = new DataSet();
     sqlAdapter1.Fill(product, TableName);
     return product.Tables[0].Rows[0];
    }
    catch (Exception ex)
    {
     throw (ex);
    }
   }

   //执行SQL语句，如UPDATE，INSERT等
   public static void ExcSQL(string s)
   {
    SqlConnection sqlConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["data"]);
    SqlCommand sqlCmd =new SqlCommand(s,sqlConnection);
    sqlConnection.Open();
                        try
    {
     sqlCmd.ExecuteNonQuery();
    }
    catch(Exception ex)
    {
     throw (ex);
    }
     sqlConnection.Close();
   }
   //计算总共有多少条问题
   public static int CalculateQRecord(int BID,int SID,string s)
   {
    try
    {       //string purid=Request.QueryString["purid"];
     DataRow dr=GetDataRow(s,"pur");
     return System.Convert.ToInt32(dr["co"].ToString());
    }
    catch
    {
     return 0;
    }
   }
}

转自：‍http://www.cnblogs.com/jxjjljf/archive/2006/01/13/316813.html

收藏于 2010-12-06

来自于百度空间

0 0