工作笔记(7)

    /// <summary>
    /// 此方法把DataRow数组转成DataTable
    /// </summary>
    /// <param name="dt"></param>
    /// <param name="dr"></param>
    /// <returns></returns>
    public DataTable GetNewDataTable(DataTable dt, DataRow[] dr)
    {
        DataTable ndt = new DataTable();
        ndt = dt.Clone();
        for (int i = 0; i <= dr.Length - 1; i++)
        {
            ndt.ImportRow((DataRow)dr[i]);
        }
        return ndt;
    }

//原来数据库表新添加字段
alter table PartnerInfoT add [dummyAccount] decimal
//删字段
alter table PartnerInfoT drop column [dummyAccount]
//只可以在文本框里边输入数字
<input id="addMoneyText" type="text" runat="server" style="text-align: right" onkeypress="if (event.keyCode < 48 || event.keyCode >57) event.returnValue = false;"
                                runat="server" width="104px" maxlength="10" />
//只可以在里边输入数字加两位小数，并敲回车键
<input maxlength="13" input onkeydown="if(event.keyCode==13)event.keyCode=9" style="text-align:right" runat="server" onkeyup="if(value.match(/^\d{11}$/))value=value.replace(value,parseInt(value/10)) ;value=value.replace(/\.\d*\./g,'.')" onKeyPress="if((event.keyCode<48 || event.keyCode>57) && event.keyCode!=46 && event.keyCode!=45 || value.match(/^\d{11}$/) || /\.\d{2}$/.test(value)) {event.returnValue=false}" id="chText" name="chText">

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //如果是绑定数据行
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
             if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
            {
                ((LinkButton)e.Row.Cells[6].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除：\"" + e.Row.Cells[1].Text + "\"吗?')");
            }
        }

    }
//跳转回上一页
onclick="javascript:history.go(-1);"

string[] ckb = null;
ckb = te.Split(new char[] { ',' });


----------计算两个日期之间相隔多少天
<script language="javascript" type="text/javascript">
function DateDiff(sDate1,sDate2){ //sDate1和sDate2是年-月-日格式
var aDate,oDate1,oDate2,iDays;
aDate=sDate1.split("-");
oDate1=new Date(aDate[1]+'-'+aDate[2]+'-'+aDate[0]);//转换为月-日-年格式
aDate=sDate2.split("-");
oDate2=new Date(aDate[1] + '-'+aDate[2]+'-'+aDate[0]);
iDays=parseInt(Math.abs(oDate1-oDate2)/1000/60/60/24); //把相差的毫秒数转换为天数
alert(iDays);
}
var date,date1,date2;
date=new Date();
date1="2005-9-23";
date2=date.getFullYear()+"-"+(date.getMonth()+1)+"-"+date.getDate();
alert(date2);
DateDiff(date1,date2);
</script>