ASP.NET 数据操作与UI交互技巧-优快云博客

本文链接：https://blog.youkuaiyun.com/nothing7/article/details/1526176

* span标签中嵌入数据库记录
<span id="dutylist" runat="server"></span>

  dutylist.innerHtml=Dutylist();
  public string Dutylist()
  {
   string sqlstr1="select * from Ds_Duty";
   OleDbDataReader rd1=Database.sqlreader(sqlstr1);
   string Startid="<table cellpadding=1 cellspacing=0 border=1 width=100% bordercolorlight=/"#C0C0C0/" bordercolordark=/"#FEFEFE/" bgcolor=#EEEEEE><tr>";
   int i=0;
   while(rd1.Read())
   {   i++;
    Startid+="<td width=/"200/">"+rd1["DutyName"].ToString()+"</td>";
    if(i>=5) {Startid+="</tr><tr>"; i=0;}
   }
   rd1.Close();
   Startid+="</tr></table>";
   return Startid;
  }

* 按钮提交弹出确认窗口
Submit1.Attributes.Add("onclick","return confirm('是否已经填写完整了！');");

* 修改数组,记录不为空则更新记录
  string [] dutylist={TextBox1.Text.ToString(),TextBox2.Text.ToString(),TextBox3.Text.ToString(),TextBox4.Text.ToString(),TextBox5.Text.ToString(),
  TextBox6.Text.ToString(),TextBox7.Text.ToString(),TextBox8.Text.ToString(),TextBox9.Text.ToString(),TextBox10.Text.ToString(),
  TextBox11.Text.ToString(),TextBox12.Text.ToString(),TextBox13.Text.ToString(),TextBox14.Text.ToString(),TextBox15.Text.ToString()};

  user myadd=new user();
  int m=0;
  for(int i=0;i<15;i++)
  {
   if(dutylist[i]!="")
   {
    m++;
    myadd.editDuty(dutylist[i].ToString(),m.ToString());
   }
  }

* 下拉列表选择改变,文本框显示值
  function select()
  {
   var DropClass=document.getElementById("DropClass");
   var pindex = DropClass.selectedIndex;
   document.getElementById("TextBox2").value=DropClass.options    [pindex].text;
  }

  DropClass.Attributes.Add("onchange","return select();");

* 两个ListBox从左添加到右,若右已有记录则不添加
   bool flag;
   int count=fList.Items.Count;
   if(count==0)
    return;
   for(int i=0;i<count;i++)
   {
    if(fList.Items[i].Selected)
    {
     flag=true;
     for(int j=0;j<sList.Items.Count;j++)
     {
      if(fList.Items[i].Text==sList.Items[j].Text)
      {
       flag=false;
      }
     }
     if(flag)
     {
      sList.Items.Add(new ListItem(fList.Items       [i].Text,fList.Items[i].Value));
     }
    }
   }

* ListBox Item值向上/下移动
   int i=0;
   string temptext="";
   i=sList.SelectedIndex;
   if(i>0)
   {
    temptext=sList.Items[i].Text;
    sList.Items[i].Text=sList.Items[i-1].Text;
    sList.Items[i-1].Text=temptext;
    sList.SelectedIndex=i-1;
   }

   int count=sList.Items.Count;
   int i=0;
   string temptext="";
   i=sList.SelectedIndex;
   if(i>=0&&i<count-1)
   {
    temptext=sList.Items[i].Text;
    sList.Items[i].Text=sList.Items[i+1].Text;
    sList.Items[i+1].Text=temptext;
    sList.SelectedIndex=i+1;
   }

* html按钮
<input name="btn" onclick="onsubmitbefore('保存');" type="button" value="保存"/>
<input name="btn" onclick="document.forms[0].reset();" type="button" value="重写"/>

* 获取Request值
    public string Name
    {
        get
        {
            if (Request["dbName"] != null)
            {
                return Convert.ToString(Request["dbName"]);
            }
            else
            {
                return "";
            }
        }
    }

* DataGrid删除按钮确认
    public void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.EditItem)
        {
            ((ImageButton)e.Item.FindControl("imagebutton2")).Attributes.Add("onclick", "return confirm('您真的要删除该记录吗？');");
        }
    }

* DataGrid的排序
    protected void DataGrid1_SortCommand(object source, DataGridSortCommandEventArgs e)
    {
        SortExpression = e.SortExpression;
        ViewState["SortExpression"] = SortExpression.Trim();
        if (sort == null) sort = "ASC";
        sort = (sort == "DESC") ? "ASC" : "DESC";
        dt.DefaultView.Sort = e.SortExpression + " " + sort;
        DataGrid1.DataSource = dt;
        DataGrid1.DataBind();
        DataGrid1.DataKeyField = "编号";
    }

* 添加多个文本值
                    for (int i = 1; i <= 15; i++)
                    {
                        TextBox tb = (TextBox)this.FindControl("TextBox" + i.ToString());
                        fName = tb.Text;
                        if (fName != "")
                        {
                            type = 1;//字符类型
                            //返回ds_field表的行数
                            maxfield = edi.ReturnMaxFieldRealName(IdentityID);
                            realName = "field" + Convert.ToString(maxfield + 1);
                            newSort = maxfield + 1;
                            string sql = "insert ds_field (dataBaseID,chName,realName,dataTypeID,length,newSort) values (" + IdentityID + ",'" + fName + "','" + realName + "'," + type + ",255," + newSort + ")";
                            Database.IsExistsRecord(sql);
                        }
                    }

* 文本输入框与下拉列表CSS
    <style type="text/css">
    body{
    font-size:12px;
    }
    .InputCss {
    font-size: 9pt;
    color: #000000;
    font-family: "宋体";
    font-style: normal;
    border-color: #ffffff #ffffff #e8e8e8 #ffffff ;
    border: 1px solid;
}
.Select {
font-family: "Tahoma", "宋体";
font-size: 9pt;
color: #000000;
border: 1px #e8e8e8 solid;
background-color: #f9f9f9;
}
    </style>

* 下拉列表selectchange事件调用后台方法
    <script language=javascript>
    function selectchange()
    {
        var ddl=document.getElementById("DropDownList1")
        for(var i=0;i<ddl.options.length;i++)
        {
            if(ddl.options[i].selected)
            {
                var boo=longoa_ComInfo.DdllBind(ddl.options[i].innerText).value
                alert(boo);
            }
        }
    }
or
    function selectchange()
    {
         var ddl=document.getElementById("DropDownList1")
         var boo=longoa_ComInfo.DdllBind(ddl.options[ddl.selectedIndex].innerText).value
         alert(boo);
    }
    </script>

* Split的使用
string para="1=0,2=14,3=52,4=0,5=49,6=51,7=0,8=50,9=11,10=0,";
string [] split=para.Split(new char[]{','});//以","分割

* IM中用到的javascript
1.窗口大小:
<script language=javascript>
    window.resizeTo(450,240);
   </script>
2.键盘快捷键
    function document.onkeydown()
    {
        if(event.keyCode==13&&event.ctrlKey==1)//ctrl+Enter
        {
            document.getElementById("btnSend").click();
        }
        if(event.keycode==13)
        {
            document.getElementById("btnReply").click();
        }
    }
3.打开新窗口,父窗口关闭,打开的窗口亦关闭
     var allr="";
    function AllRecord()
    {
        if(allr=="")
        {
            allr=window.open("allrecord.aspx","allr","left=300,top=374,width=440,height=205,toolbar=no,menubar=no,scrollbars=no,locaiton=no,resizable=no,status=no");
        }
        else
        {
            allr.close();
            allr="";
        }
    }
   function window.onbeforeunload()//窗口关闭触发
    {
      if(allr!="")
      {
        allr.close();
      }
    }
4.新窗口传值给父窗口
    function SaveValue(path)
    {
        window.opener.document.all('<%=imageID %>').src=path;
        window.opener.document.all("hdnFace").value=path;
    }

* 前台数据绑定调用后台方法
    Text='<%# htmltxt( Eval("Front").ToString())%>'
    public string htmltxt(string str)
    {
        return Server.HtmlDecode(str.Replace("@", "'"));
    }

DevNote