jxjjljf
博客园 \| 首页 \| 发新随笔 \| 发新文章 \| 联系 \| 订阅 \| 管理	随笔：11 文章：1 评论：6 引用：0

2006年1月26日

今天我对公司的WEB系统终于有了一个比较完美的交代!

        今天把分页做成了存储过程,使得取出数据更快,效率更高.

        其实这个分页存储过程来之不易,我比较笨,花了4天才写成,因为是第一次写存储过程,又是"量身定做",所以走过很多弯路.

        以前是在DATALIST控件下的.CS页面里写的分页功能,那么如果数据库里有10万条数据以上时就会很慢,当时打开页面大概至少要25秒之多,因为是全部取出来然后分页,所以公司领导感觉不爽,我作为做技术的感觉也不爽,今天我利用存储分页使得取出的速度有质的提高,现在只要1秒不到就OK了,很有成就感和征服感,呵呵,见笑了.

        我的成功离不开大伙出谋献策,所以在此我要特别对CSDN里C#版的斑竹bitsbird表示感谢,是在他的帮助下使我茅塞顿开,让我最感动的是他并不认为我很笨,非常有耐心的教导我,激发我,鼓励我,使我深受感动和鼓舞,现在总算让我见识到了CSDN里斑竹的风采了,他们不光是技术的先锋,还是教导的良师.

        同时也感谢CSDN里支持和帮助过我的好心人,还有也要感谢我的众多QQ好友,他们都是NET高手,给我的帮助很大.

        最后祝大家新年快乐,事业更上一层楼,来年发大财.

posted @ 2006-01-26 16:35 jxjjljf 阅读(438) | 评论 (1) | 编辑

动态查询条件,分页存储,正反向排序(亲身体验)

摘要: <%@ Page language="c#" src="remark_xp.aspx.cs" AutoEventWireup="false" Inherits="src.Mainlist" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ><HTML><HEAD><... 阅读全文

posted @ 2006-01-26 15:35 jxjjljf 阅读(711) | 评论 (0) | 编辑

2006年1月13日

DATALIST正反向排序,带▲和▼提示的(亲身体验)

<%@ 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;
   }
  }
}
public class Mainlist : System.Web.UI.Page
{
  protected System.Web.UI.WebControls.HyperLink HyperLink1;
  protected System.Data.SqlClient.SqlConnection sqlConnection2;
  protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;
  protected System.Web.UI.WebControls.Label LblManagers,pono,vendor;
  protected System.Web.UI.WebControls.Label lblRecordCount;
  protected System.Web.UI.WebControls.Label lblCurrentPage;
  protected System.Web.UI.WebControls.Label lblPageCount;
  protected System.Web.UI.WebControls.Panel Panel1;
  protected System.Web.UI.WebControls.TextBox TextBox1;
  protected System.Web.UI.WebControls.HyperLink lnkPrev;
  protected System.Web.UI.WebControls.HyperLink lnkNext;
  protected System.Web.UI.WebControls.Label LblB;
  protected System.Web.UI.WebControls.Label Label1;
  protected System.Web.UI.WebControls.DropDownList DropDownList1;
  protected System.Web.UI.WebControls.DataList DL_Main;
  int PageSize,CurrentPage,PageCount;
        public string navigation;
  public TextBox    txtIndex;
  public DataRow dr,dr1;
  public int a,d;
  string SortField;
        protected System.Web.UI.WebControls.LinkButton LinkButton1,LinkButton2,LinkButton3,LinkButton4,LinkButton5;
  protected System.Web.UI.WebControls.Button Button1,Button2,Button3,Button4,Button5,Button6,Button7,Button8,Button9;

protected System.Web.UI.HtmlControls.HtmlInputRadioButton RadSelected;
protected System.Web.UI.HtmlControls.HtmlInputHidden rd;

  public static string add1(string s,string ss,string s1)
  {
                               string str="" ;
                               if (s1!=""&&s1!=null)
                               {
    str=" and "+s+ss+"'"+s1+"' ";
                               }
                              return str;
  }
  public static string add2(string s,string s1,string s2)
  {
                               string str="" ;
                               if (s1!=""&&s1!=null){
                                if(s2!=""&&s2!=null)
                               {
    str=" and "+s+">='"+s1+"' and "+s+"<='"+s2+"' ";
                               }
                                else
                               {
    str=" and "+s+"='"+s1+"' ";
                               }
                              }
                              return str;
  }
  public void BindGrid(string str)
  {

     //if(!Page.IsPostBack)
     //{
    int BID,SID;
    if ((Request.QueryString["BID"]==null)||(Request.QueryString["SID"]==null))
    {
     BID=1;
     SID=200;
    }
    else
    {
     BID=System.Convert.ToInt32(Request.QueryString["BID"]);
     SID=System.Convert.ToInt32(Request.QueryString["SID"]);
    }
                PageSize=System.Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["MainList"]);
    CurrentPage = 0;
    //计算总共有多少记录
                               string str1,str2,str3;

if( Session["status1"]==null && Request.QueryString["status1"]!=null)
{
string status1=Request.QueryString["status1"];
Session["status1"]=status1;
}
else if(Request.QueryString["status1"]!=null)
{
string status1=Request.QueryString["status1"];
Session["status1"]=status1;
}

if ((Session["status1"]!="" && Session["status1"]!=null && Session["upower"].ToString()=="3") || ( Session["status1"]!="" && Session["status1"]!=null && Session["upower"].ToString()=="4") || ( Session["status1"]!="" && Session["status1"]!=null && Session["upower"].ToString()=="1"))
{

str1="SELECT COUNT(*) as co from pur where P_ID<>'' and status3='1' and depno='"+Session["section"]+"' ";
str2="select * from pur where P_ID<>'' and status3='1' and depno='"+Session["section"]+"' ";
str3="select pono as 采購單號,vendor as 供應商,part as 料號,specification as 料品名稱規格,unit as 單位,qty as 數量,recqty as 驗收總數,unprc as 單价,left(convert(varchar(10),precdate,120),10) as 交貨日期,orderno as 訂單號碼,left(convert(varchar(10),indate,120),10) as 下單日期,left(convert(varchar(10),signdate,120),10) as 簽回日期,(case status when 0 then '新單' when 1 then '再協商' when 2 then '已簽回' when 3 then '已驗貨' when 4 then '已收貨' when 5 then '已結案' when 6 then '已作廢' end) as 狀態 from pur where P_ID<>'' and status3='1' and depno='"+Session["section"]+"' ";

    DateTime t=DateTime.Now;
                DateTime tnow= t.AddDays(-1);
    DateTime tttnow= t.AddDays(+2);
string ttnow=t.Year.ToString()+"-"+t.Month.ToString()+"-"+t.Day.ToString();
string bnow=tnow.Year.ToString()+"-"+tnow.Month.ToString()+"-"+tnow.Day.ToString();
string ttttnow=tttnow.Year.ToString()+"-"+tttnow.Month.ToString()+"-"+tttnow.Day.ToString();

//Session["status"]=Request.QueryString["status"];

                               if ((string)Session["status1"]=="0")
                                {
                     str1+=" and status='"+Session["status1"]+"' ";
                     str2+=" and status='"+Session["status1"]+"' ";
      str3+=" and status='"+Session["status1"]+"' ";
        }
                               else if ((string)Session["status1"]=="6")
                                {
                     str1+=" and status='"+Session["status1"]+"' and cancletime >='"+ bnow+"' ";
                     str2+=" and status='"+Session["status1"]+"' and cancletime >='"+ bnow+"' ";
      str3+=" and status='"+Session["status1"]+"' and cancletime >='"+ bnow+"' ";
        }
                               else if ((string)Session["status1"]=="2")
                                {
                     str1+=" and status='"+Session["status1"]+"' and signdate >= '"+ bnow +"' ";
                     str2+=" and status='"+Session["status1"]+"' and signdate >= '"+ bnow +"' ";
      str3+=" and status='"+Session["status1"]+"' and signdate >= '"+ bnow +"' ";
                                }
          else if ((string)Session["status1"]=="1")
                                {
                     str1+=" and status='"+Session["status1"]+"' ";
                     str2+=" and status='"+Session["status1"]+"' ";
      str3+=" and status='"+Session["status1"]+"' ";
                                }
          else if ((string)Session["status1"]=="22")
                                {
                     str1+=" and status='2' and precdate <= '"+ ttttnow +"' ";
                     str2+=" and status='2' and precdate <= '"+ ttttnow +"' ";
      str3+=" and status='2' and precdate <= '"+ ttttnow +"' ";
                                }
if(str!="") //这里是正反向排序
{
if(Session["flag"]=="")
    {
  Session["flag"]="false";
}
if (Session["flag"]=="false") //不能用ViewState,只能用Session
{
str2=str2+ " order by "+str+" desc ";
str3=str3+ " order by "+str+" desc ";
  Session["flag"]="true";
}
else
{
str2=str2+ " order by "+str+" asc ";
str3=str3+ " order by "+str+" asc ";
  Session["flag"]="false";
}
}

else
{
str2+= " order by indate desc,pono desc " ;
str3+= " order by indate desc,pono desc " ;
}
                              Session["str1"]=str1;
                              Session["str2"]=str2;
         Session["str3"]=str3;
}

else if ((Session["status1"]!="" && Session["status1"]!=null && Session["upower"].ToString()!="3") || ( Session["status1"]!="" && Session["status1"]!=null && Session["upower"].ToString()!="4") || ( Session["status1"]!="" && Session["status1"]!=null && Session["upower"].ToString()!="1"))
{

str1="SELECT COUNT(*) as co from pur where P_ID<>'' and status3='1' ";
str2="select * from pur where P_ID<>'' and status3='1' ";
str3="select pono as 采購單號,vendor as 供應商,part as 料號,specification as 料品名稱規格,unit as 單位,qty as 數量,recqty as 驗收總數,unprc as 單价,left(convert(varchar(10),precdate,120),10) as 交貨日期,orderno as 訂單號碼,left(convert(varchar(10),indate,120),10) as 下單日期,left(convert(varchar(10),signdate,120),10) as 簽回日期,(case status when 0 then '新單' when 1 then '再協商' when 2 then '已簽回' when 3 then '已驗貨' when 4 then '已收貨' when 5 then '已結案' when 6 then '已作廢' end) as 狀態 from pur where P_ID<>'' and status3='1' ";

    DateTime t=DateTime.Now;
                DateTime tnow= t.AddDays(-1);
    DateTime tttnow= t.AddDays(+2);
string ttnow=t.Year.ToString()+"-"+t.Month.ToString()+"-"+t.Day.ToString();
string bnow=tnow.Year.ToString()+"-"+tnow.Month.ToString()+"-"+tnow.Day.ToString();
string ttttnow=tttnow.Year.ToString()+"-"+tttnow.Month.ToString()+"-"+tttnow.Day.ToString();

                               if ((string)Session["status1"]=="0")
                                {
                     str1+=" and status='"+Session["status1"]+"' ";
                     str2+=" and status='"+Session["status1"]+"' ";
      str3+=" and status='"+Session["status1"]+"' ";
        }
                               else if ((string)Session["status1"]=="6")
                                {
                     str1+=" and status='"+Session["status1"]+"' and cancletime >='"+ bnow+"' ";
                     str2+=" and status='"+Session["status1"]+"' and cancletime >='"+ bnow+"' ";
      str3+=" and status='"+Session["status1"]+"' and cancletime >='"+ bnow+"' ";
        }
                               else if ((string)Session["status1"]=="2")
                                {
                     str1+=" and status='"+Session["status1"]+"' and signdate >= '"+ bnow +"' ";
                     str2+=" and status='"+Session["status1"]+"' and signdate >= '"+ bnow +"' ";
      str3+=" and status='"+Session["status1"]+"' and signdate >= '"+ bnow +"' ";
                                }
          else if ((string)Session["status1"]=="1")
                                {
                     str1+=" and status='"+Session["status1"]+"' ";
                     str2+=" and status='"+Session["status1"]+"' ";
      str3+=" and status='"+Session["status1"]+"' ";
                                }
          else if ((string)Session["status1"]=="22")
                                {
                     str1+=" and status='2' and precdate <= '"+ ttttnow +"' ";
                     str2+=" and status='2' and precdate <= '"+ ttttnow +"' ";
      str3+=" and status='2' and precdate <= '"+ ttttnow +"' ";
                                }
if(str!="" && str=="pono") //这里是正反向排序
{
if(Session["flag"]=="")
    {
  Session["flag"]="false";
}
if (Session["flag"]=="false" && str=="pono") //不能用ViewState,只能用Session
{
str2=str2+ " order by "+str+" desc ";
str3=str3+ " order by "+str+" desc ";
pono.Text = "▲";
  Session["flag"]="true";
}
else
{
str2=str2+ " order by "+str+" asc ";
str3=str3+ " order by "+str+" asc ";
pono.Text = "▼";
  Session["flag"]="false";
}
}

else if(str!="" && str=="vendor") //这里是正反向排序
{
if(Session["flag"]=="")
    {
  Session["flag"]="false";
}
if (Session["flag"]=="false" && str=="vendor") //不能用ViewState,只能用Session
{
str2=str2+ " order by "+str+" desc ";
str3=str3+ " order by "+str+" desc ";
vendor.Text = "▲";
  Session["flag"]="true";
}
else
{
str2=str2+ " order by "+str+" asc ";
str3=str3+ " order by "+str+" asc ";
vendor.Text = "▼";
  Session["flag"]="false";
}
}

else
{
str2+= " order by indate desc,pono desc " ;
str3+= " order by indate desc,pono desc " ;
}
                              Session["str1"]=str1;
                              Session["str2"]=str2;
         Session["str3"]=str3;
}
else
{
str1=Session["str1"].ToString();
str2=Session["str2"].ToString();
str3=Session["str3"].ToString();
}

    int RecordCount = DBOperate.CalculateQRecord(BID, SID,str1);
    lblRecordCount.Text = RecordCount.ToString();
    //计算总共有多少页
    PageCount = (RecordCount+PageSize-1)/PageSize;
    if (PageCount<=0)
     PageCount=1;
    lblPageCount.Text = PageCount.ToString();
    //获取页面参数
    if (Request.QueryString["Page"] != null)
     CurrentPage=Convert.ToInt32(Request.QueryString["Page"]);
    else
     CurrentPage=1;
    if (PageCount<CurrentPage)
     CurrentPage=PageCount;
    if (CurrentPage<=0)
     CurrentPage=1;

    //ListBind();
    //设定导入的起终地址
    int StartIndex = (CurrentPage-1)*PageSize;
                  string tablestr="pur";
    //this.DL_Main.DataSource= DBOperate.SelectFormForum(sqlstr,StartIndex,PageSize,tablestr);
                           DataTable dt=DBOperate.SelectFormForum(str2,StartIndex,PageSize,tablestr);
                           this.DL_Main.DataSource=dt;
    this.Page.DataBind();
    lnkNext.Enabled = true;
    lnkPrev.Enabled = true;
    if(CurrentPage==(PageCount))
    {
     lnkNext.Enabled = false;
    }
    else
     lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?BID="+ BID.ToString()+"&SID="+ SID.ToString()+"&Page="+Convert.ToString(CurrentPage+1);
    if(CurrentPage==1)
     lnkPrev.Enabled = false;
    else
     lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?BID="+ BID.ToString()+"&SID="+ SID.ToString()+"&Page="+Convert.ToString(CurrentPage-1);
    lblCurrentPage.Text = CurrentPage.ToString();
    //}
  }

  public void SubmitBtn_Click5(object sender, System.EventArgs e)
  {
   Response.Redirect( "remark.aspx?Page="+TextBox1.Text);
  }

private void Page_Load(object sender, System.EventArgs e)
{

            if (!this.IsPostBack)
   {
    BindGrid("");
   }

  }

  override protected void OnInit(EventArgs e)
  {
   InitializeComponent();
   base.OnInit(e);
        }

  private void InitializeComponent()
  {
      this.Button1.Click += new System.EventHandler(this.Button1_Click);
        this.Button2.Click += new System.EventHandler(this.Button2_Click);
            this.Button3.Click += new System.EventHandler(this.Button3_Click);
        this.Button4.Click += new System.EventHandler(this.Button4_Click);
            this.Button6.Click += new System.EventHandler(this.Button6_Click);
        this.Button7.Click += new System.EventHandler(this.Button7_Click);
      this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
      this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
      this.LinkButton3.Click += new System.EventHandler(this.LinkButton3_Click);
      this.LinkButton4.Click += new System.EventHandler(this.LinkButton4_Click);
      this.LinkButton5.Click += new System.EventHandler(this.LinkButton5_Click);
      this.Load += new System.EventHandler(this.Page_Load);
   this.DL_Main.ItemDataBound += new System.Web.UI.WebControls.DataListItemEventHandler(this.DL_Main_ItemDataBound);
   }

        private void DL_Main_ItemDataBound(object sender, System.Web.UI.WebControls.DataListItemEventArgs e)
        {
  }

    private void LinkButton1_Click(object sender, System.EventArgs e)
  {
   BindGrid("pono");
  }
   }
}

posted @ 2006-01-13 15:53 jxjjljf 阅读(953) | 评论 (1) | 编辑

根据数字来判断显示多少个星星(亲身体验)

aspx:

<asp:Label id="lbl1" runat="server" Visible="True"></asp:Label>

cs:

string s1="SELECT COUNT(*) as co from pur where status='2' and signdate >='"+ bnow+"' ";

int Num=int.Parse(CalculateQRecord(s1).ToString());
//string imgStr;
for (int i=1; i <= (Num / 100);i++)
{
   for (int j=1;j <= i;j++)
   {
      imgStr=imgStr+"<img src=images/ratingzero.gif border=0>";
   }
}

this.lbl1.Text=CalculateQRecord(s1).ToString()+imgStr;

posted @ 2006-01-13 15:52 jxjjljf 阅读(301) | 评论 (0) | 编辑

时间格式等问题的解决方案(亲身体验)

<%# Convert.ToDateTime(DataBinder.Eval

(Container.DataItem,"varAnswer")).Year+"-"+Convert.ToDateTime(DataBinder.Eval

(Container.DataItem,"varAnswer")).Month+"-"+Convert.ToDateTime(DataBinder.Eval

(Container.DataItem,"varAnswer")).Day%>

<asp:BoundColumn DataField="jj_time" DataFormatString="{0:yyyy-MM-dd}" HeaderText="交

货日期" ReadOnly="True">里面可以做样式</asp:BoundColumn>

<%# DateTime.Now.ToString().Replace("-","").Replace(":","").Replace(" ","")%>

<asp:textbox id="caigoudanhao" value='<%# DateTime.Now.ToString().Replace(" ","")%>'

runat="server"/>

<%# DateTime.Now.ToString("yyyyMMddhhmm")%>

car_usedate.Text=Convert.ToDateTime(dr2["car_usedate"]).ToShortDateString();

采购单号：<asp:textbox id="caigoudanhao" value='<%# DateTime.Now.ToString().Replace

("-","").Replace(":","").Replace(" ","")%>' runat="server"/>--<%#

DateTime.Now.ToString("yyyyMMddHHmm")%>--<%# DateTime.Now.ToString("yyyyMMddhhmm")%>

<asp:textbox id="car_factleavetime" width="106" value='<%# DateTime.Now.ToString

("yyyy-MM-dd HH:mm")%>' runat="server" style="font-family:verdana;font-size:8pt;text

-align=center;border:1px #DDE3EC solid"/>
得到2005-11-25 16:07不要秒

警告：在page_load里边一定不能少了Page.DataBind();
否则上面的都显示不出来

<%# DateTime.Now.Date.ToShortDateString()%>

<%# DateTime.Now.ToString().Replace("-","").Replace(":","").Replace(" ","")%>

<asp:textbox id="caigouriqi" value="<%#DataBinder.Eval

(Container.DataItem,"ItemName","{0:yyyy-MM-dd}")%>" runat="server"/>

<%=FormatString(dr["xuqiuriqi"].ToString(),"{0:yyyy-MM-dd}").ToString()%>

caigouriqi.Text=Convert.ToDateTime(dr["caigouriqi"].ToString()).Year.ToString()

+"-"+Convert.ToDateTime(dr["caigouriqi"].ToString()).Month.ToString()

+"-"+Convert.ToDateTime(dr["caigouriqi"].ToString()).Day.ToString();
只要年月日

car_leavetime.Text=Convert.ToDateTime(dr2["car_leavetime"].ToString()).Year.ToString

()+"-"+Convert.ToDateTime(dr2["car_leavetime"].ToString()).Month.ToString()

+"-"+Convert.ToDateTime(dr2["car_leavetime"].ToString()).Day.ToString()+"

"+Convert.ToDateTime(dr2["car_leavetime"].ToString()).Hour.ToString()

+":"+Convert.ToDateTime(dr2["car_leavetime"].ToString()).Minute.ToString();
只要年月日时分，不要秒

if(int.Parse(shuliang.Text)==int.Parse(shuliang1.Text))
    {
     radio1.Text="已收?";
    }
    else
    {
    }
一个判断语句，等号是==，另外要双引号。

格式字符串设置成{0:d}
string str ="time";str = str.ToString("yyyy-MM-dd");
在绑定中设置{0:yyyy-MM-dd}
ToString("yyyy-MM-dd")
Dim da As Date = Now()Console.WriteLine(da.ToShortDateString())

DIM FFF AS STRING FFF="yyyy-MM-dd" dim myinsertquery as string="insert into

liaopin(jiandangriqi,pandianriqi)values( " & "#" & DATETIME.Now.TOSTRING(FFF) &"#,#"&

DATETIME.Now.TOSTRING(FFF) & "# )"注意大小写

<%=String.Format("{0:yyyy-MM-dd hh:mm}" , dr["car_leavetime"])%>

posted @ 2006-01-13 15:50 jxjjljf 阅读(822) | 评论 (0) | 编辑

2个字段的内容相加后显示出来，用SQL(亲身体验)

SELECT car_code+car_remark as car_code FROM lw_car where car_attribute='"+Session["attribute2"]+"'

posted @ 2006-01-13 15:47 jxjjljf 阅读(534) | 评论 (1) | 编辑

无刷新2级联动(亲身体验)

<%@ Page Inherits="www.MyCodeBehind" Src="add2.cs" %>
<html>
<head>
<title>部門主管管理</title>
<script LANGUAGE="javascript">
subcity = new Array();      //定义一个数组，存放所有区县信息
<asp:Literal id="ltlsubcity" runat="server"/>
   //这里使用了literal控件输出所有区县信息
function mychange(provalue)
{
     //proValue参数传入客户选中的省份编号
  document.myform.DropDownList3.length = 0;    //将city下拉框先清空
  document.myform.DropDownList3.options[0] = new Option('請選擇主管所屬部門','');//先添加第0行
  var i;
  for (i=0;i < subcity.length; i++) // subcity.length表示数组长度，为5
   {
    if (subcity[i][0] == provalue) //判断是否属于所选省份
    {
    //下面语句将在city下拉框最下边添加一个新项
     document.myform.DropDownList3.options[document.myform.DropDownList3.length] = new Option(subcity[i][1],subcity[i][2]);
    }
   }
}
</script>
</head>
<link rel="stylesheet" href="Style.css" type="text/css">
<body topmargin=30 >
<%# DateTime.Now.Date.ToShortDateString()%>
<center>

<table width="100%" border="0" align="center">
<tr><td colspan="2" align=center><font size=4>增加部門主管</font></td></tr>

<tr>
   <td align=right>主管所屬公司：</td><td align=left>
   <asp:DropDownList id="DropDownList2" width="150" runat="server">
     <asp:ListItem Value="" Text="請選擇主管所屬公司"/>
      </asp:DropDownList>
   </td>
    </tr>

<tr>
   <td align=right>主管所屬部門：</td><td align=left>
   <asp:DropDownList id="DropDownList3" width="150" runat="server">
  <asp:ListItem Value="" Text="請選擇主管所屬部門"/>
   </asp:DropDownList>
   </td>
    </tr>

<tr>
   <td align=right>部門主管名稱：</td><td align=left><asp:textbox id="managername" width="145" runat="server"/></td>
</tr>

<tr>
      <td colspan="2" align=center><input type=button id="Button1" value="增加" OnServerClick="Button1_Click" runat="server"></td>
</tr>
</table>
<table>
<tr>
      <td colspan="1">
        <div align="center"> <asp:Label id="Label1" ForeColor="Red" runat="server"/>
        </div>
      </td>
    </tr>
</table>
<tr>
   <td align=right></td><td align=left><asp:textbox id="tb" type="hidden" width="1" runat="server" style="text-align:center;border:1px solid #ffffff"/></td>
</tr>
</form>
</center>
</body>
</html>
------------------------------------------
using System;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;

namespace www
{
public class MyCodeBehind : Page
{
  public System.Web.UI.WebControls.DropDownList upower;
     public System.Web.UI.WebControls.DropDownList DropDownList2,DropDownList3;
  public DataGrid MyList;
        protected System.Web.UI.WebControls.Button Button3,Button4;
        public System.Web.UI.WebControls.TextBox managername,departmentname;
        public System.Web.UI.WebControls.Label Label1;
     public HtmlInputFile File1;
        public HtmlInputButton Button1;
  public DataRow dr2;
  public TextBox   TextBox3,tb;
  public Literal ltlsubcity;

       public void Page_Load(Object sender, EventArgs e)
    {
     if(!IsPostBack)
     {
            string nowDSN=ConfigurationSettings.AppSettings["car1"];
            OleDbConnection conn =new OleDbConnection(nowDSN);
    OleDbDataAdapter adp = new OleDbDataAdapter("Select * From lw_company", conn);
    DataSet ds = new DataSet();
    adp.Fill(ds, "lw_company");
    for (int I=0;I<=ds.Tables["lw_company"].Rows.Count-1;I++)
    {
  DataRow dr = ds.Tables["lw_company"].Rows[I];
  DropDownList2.Items.Add(new ListItem(dr["companyname"].ToString(), dr["companycode"].ToString()));
}

adp = new OleDbDataAdapter("Select * From lw_department", conn);
adp.Fill(ds, "lw_department");
for (int I=0;I<=ds.Tables["lw_department"].Rows.Count-1;I++)
{
  DataRow dr = ds.Tables["lw_department"].Rows[I];
  ltlsubcity.Text += "subcity[" + I + "] = new Array(\"" + dr["companycode"].ToString() + "\",\"" + dr["departmentname"].ToString() + "\",\"" + dr["departmentcode"].ToString() + "\");";
} DropDownList2.Attributes.Add("onchange","javascript:mychange(this.options[this.selectedIndex].value);");
                DropDownList3.Attributes.Add("onChange","javascript:document.myform.tb.value=this.options[this.selectedIndex].text;");   //这里是让DropDownList3的值显示到<asp:textbox id="tb"里面，那么tb.Text.ToString()就可以取出DropDownList3的值。
      Page.DataBind();
     }
     DataBind();
    }

  public void Button1_Click(Object Source, EventArgs e)
  {
   if (managername.Text=="")
   {
    Response.Write ("<script>window.alert('部門主管名稱不能空，按確定返回')</script>");
    //Label1.Text="部門主管名稱不能空";
   }
   else
   {
            string nowDSN=ConfigurationSettings.AppSettings["car1"];
            OleDbConnection myConnection =new OleDbConnection(nowDSN);
            OleDbCommand myCommand=new OleDbCommand("insert into lw_manager (company,department,managername)values('"+DropDownList2.SelectedItem.Text+"','"+tb.Text.ToString()+"','"+managername.Text.ToString()+"')" , myConnection);
            myCommand.Connection=myConnection;
            myCommand.Connection.Open();
            myCommand.ExecuteNonQuery();
            myCommand.Connection.Close();
            Response.Write("<script language='javascript'>window.opener.location.href = window.opener.location.href;window.close();</script>");
   }
  }
}
}

posted @ 2006-01-13 15:45 jxjjljf 阅读(836) | 评论 (2) | 编辑

修改数据库的拥有者(亲身体验)

选Security-->选Logins-->在右边的权限名上按右键，选内容-->选Database Access-->选要更改拥有者的数据库名字，在下面的db_owner打上勾即可。

因为在数据库上按右键后，Owner（拥有者）可能不是数据库的使用者（即数据库的用户名）

posted @ 2006-01-13 15:44 jxjjljf 阅读(323) | 评论 (0) | 编辑

DATAGRID分页，排序，有▲和▼标示的排序(亲身体验)

摘要: DATAGRID分页，排序，有▲和▼标示的排序<%@ Page Inherits="www.MyCodeBehind" Src="result.cs" %> <html><head><title>查找派車單</title><meta http-equiv="Content-Type" content="text/html; char... 阅读全文

posted @ 2006-01-13 15:41 jxjjljf 阅读(461) | 评论 (0) | 编辑

DATAGRID固定表头(亲身体验)

<%@ Page Inherits="www.MyCodeBehind" Src="result.cs" %>

<html>
<head>
<title>查找日工作報告&計劃</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

table {
table-layout: fixed;
border-collapse: collapse;
background-color: "#718BD6";
}

div#tbl-container table th {
width: 100px;
}

thead th, thead th.locked {
font-size: 12px;
font-weight: bold;
text-align: left;
background-color: navy;
color: white;
border-right: 0px solid silver;
position:relative;
cursor: default;
}

thead th {
top: expression(document.getElementById("tbl-container").scrollTop-2); /* IE5+ only */
z-index: 20;
}
</style>

<div id="tbl-container">
          <table id="tbl" border=1>
    <thead>
    <tr>
    <th>項次</th>
    <th>查看詳情</th>
    <th>報告人</th>
    <th>部門</th>
    <th>日工作報告</th>
    <th>日工作計劃</th>
    <th>填寫時間</th>
    <th>最後修改時間</th>
    <th>修改</th>
    <th>删除</th>
    </tr>
    </thead>

<asp:TemplateColumn HeaderText="項次">
<ItemTemplate>
<%# Container.ItemIndex+1+this.MyList.CurrentPageIndex*this.MyList.PageSize%>
</ItemTemplate>
</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="查看詳情">
<ItemTemplate>
<asp:HyperLink Text='查看日工作報告&計劃' imageurl="images/file.gif" NavigateUrl='<%# "javascript:newwin(\"look.aspx?repday_id="+DataBinder.Eval(Container.DataItem,"repday_id").ToString()+"\");" %>' runat="server"/>
</ItemTemplate>
</asp:TemplateColumn>

<asp:BoundColumn HeaderText="報告人" DataField="repday_name" />
<asp:BoundColumn ItemStyle-Width="100px" HeaderText="部門" DataField="departmentname" />

<asp:TemplateColumn HeaderText="日工作報告">
<ItemTemplate>
<%# SubStr(DataBinder.Eval(Container.DataItem,"repday_body").ToString())%>
</ItemTemplate>
</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="日工作計劃">
<ItemTemplate>
<%# SubStr(DataBinder.Eval(Container.DataItem,"proday_body").ToString())%>
</ItemTemplate>
</asp:TemplateColumn>

<asp:BoundColumn SortExpression="repday_indate" HeaderText="填寫時間" DataFormatString="{0:yyyy-MM-dd HH:mm}" DataField="repday_indate" />

<asp:BoundColumn SortExpression="repday_editdate" HeaderText="最後修改時間" DataFormatString="{0:yyyy-MM-dd HH:mm}" DataField="repday_editdate" />

<asp:TemplateColumn HeaderText="修改">
<ItemTemplate>
<asp:HyperLink Text='修改' Enabled='<%#(Convert.ToString(DataBinder.Eval(Container.DataItem,"repday_name")).Trim()==Session["name"].ToString())%>' NavigateUrl='<%# "javascript:newwin2(\"edit.aspx?repday_id="+DataBinder.Eval(Container.DataItem,"repday_id").ToString()+"\");" %>' runat="server"/>
</ItemTemplate>
</asp:TemplateColumn>

<asp:HyperLinkColumn Text="删除" HeaderText="删除" DataNavigateUrlField="repday_id" DataNavigateUrlFormatString="javascript:del({0})"></asp:HyperLinkColumn>

</Columns>
</asp:DataGrid>

</td>
</tr></tbody></table></div>

</form>
</body>
</html>

posted @ 2006-01-13 15:39 jxjjljf 阅读(1025) | 评论 (0) | 编辑

2009年7月

日

一

二

三

四

五

六

与我联系

发短消息

搜索

常用链接

留言簿

随笔档案

2006年1月 (11)

相册

龙卷风

2006年1月26日

2006年1月13日

与我联系

搜索

常用链接

留言簿

随笔档案

相册

最新评论

阅读排行榜

评论排行榜