<%@ 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">
<table width="100%" height="16" border="0" cellpadding="1" cellspacing="0" >
<tr style="color:#FFFFFF;background-color:#718BD6;">
<td align="center" width="80"><asp:LinkButton id="LinkButton1" runat="server">采購單號</asp:LinkButton><asp:label id="pono" runat="server" ForeColor="Blue"></asp:label></td>
<td align="center" width="50"><asp:LinkButton id="LinkButton2" runat="server">供應商</asp:LinkButton><asp:label id="vendor" runat="server" ForeColor="Blue"></asp:label></td>
</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" οnclick="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