问题记录

1、阻止按钮响应回车事件

$(document).keydown(function (event) {
                switch (event.keyCode) {
                    case 13: return false;
                }
            });

2、js往id为filelis的div添加一个input

var addli = document.getElementById("filelis");
var inpu = document.createElement("input");
inpu.value = "sss";
inpu.classList.add("inputfile");  //添加class属性
inpu.id = "input";
inpu.name = "input";
inpu.readOnly = true;
addli.appendChild(inpu);

3、input失去焦点（离开input时）触发该事件

 $("input").blur(function(){
    $("input").css("background-color","#D6D6FF");
  });

4、获取第一个button的text

document.getElementsByTagName("BUTTON")[0].textContent;

  var protypeval = document.getElementById("protype");
  var prostr = protypeval[protypeval.value].textContent; //这样获取到的就是option选定的第几项的text
  var prostr = protypeval.textContent;   //这样的话就是全部option的text
  

5、js获取年月日

 var date = new Date();
 var year = date.getFullYear();
 var month = date.getMonth() + 1;
 var strDate = date.getDate();

6、js将字符串转换成int

parseInt("1234blue");  //returns  1234 

7、sqlserver设置id自增

8、sqlserver获取自增id的下一个值(注意里面的是表名)

SELECT IDENT_CURRENT('TableName') + IDENT_INCR('TableName');

9、sqlserver时间字段默认当前时间

10、layer的success事件优先于window.load和document.ready事件，导致从success传到input然后再获取无数据，通过调用父窗口函数获取数据也是无数据，无奈只能通过延时执行那段js才能获取了

setTimeout("getclassy()", "2000");  

11、页面渲染效果

如果是再document.ready里面，页面初始化时添加效果可以用innerHtml，但是如果是在页面已经加载完后再动态改变页面，则需要用appendChild来添加标签
12、oracle
需要添加System.Data.OracleClient.dll，得使用安装包来安装，sql语句不要加上 ；
并且生成为 x86平台（32位）
13、oracle的分页以及高效率模糊查询

SELECT oea01,oea02,oea72,oea14,gen02,oea032

  FROM (SELECT tt.*, ROWNUM AS rowno

          FROM (  SELECT t.*

                    FROM oea_file t

                    where instr(oea032, '碧') > 0

                ORDER BY oea02 DESC) tt

         WHERE ROWNUM <= 100) table_alias 
         inner join(select gen02,gen01 from gen_file)b on b.gen01=table_alias.oea14
 WHERE table_alias.rowno >= 50;

14、sqlserver的高效分页语句

select * from (select ROW_NUMBER() OVER(order by acceptdate desc) as px,* from ExternalPlatform) as a where a.px between 0 and 1

    SELECT *

  FROM (SELECT tt.oea01,oea02, ROWNUM AS rowno

          FROM (  SELECT t.*

                    FROM oea_file t
                    
                    where TO_CHAR(oea02, 'YYYY-MM-DD') BETWEEN '2019-07-01' AND '2019-07-31'
               ) tt
         WHERE ROWNUM <= 100) table_alias 
         inner join(select oeb01,oeb12,oeb24,oeb04 from oeb_file)b on b.oeb01=oea01
         inner join(select ima01,imaud01,ima02 from ima_file)c on c.ima01=b.oeb04
 WHERE table_alias.rowno >= 0  order BY imaud01;

15、启动线程获取数据，并且启动加载线程（进度条之类的）

 private void countdata() {
            try
            {
                #region  加载控件线程启动
                Thread t = new Thread(new ThreadStart(CreateUI));    //启动加载方法，这个方法可以更新processbar或者其他
                t.IsBackground = true;
                t.Start();


                #endregion
                var task1 = new Task(() =>
                {
                    int ss = 0;
                    for (int i = 0; i < 10000; i++)       //这里是花时间做的事件
                    {
                        ss += i;
                        Thread.Sleep(10);

                    }

                    this.Invoke((MethodInvoker)(() =>
                    {
                      
                        // cmd.HideOpaqueLayer();
                        disop_thread(t);    //完成事件后杀掉加载函数进程

                        MessageBox.Show(""+ss);    //完事后提示
                    }));
                });
                task1.Start();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                cmd.HideOpaqueLayer();
            }

        
        }

16、panel里显示页面

baobiao form = new baobiao();
form.FormBorderStyle = FormBorderStyle.None; //隐藏子窗体边框（去除最小花，最大化，关闭等按钮）
form.TopLevel = false; //指示子窗体非顶级窗体
this.panel5.Controls.Add(form);//将子窗体载入panel
form.Show();

17、自己创建的进程不能直接访问主线程创建的控件(通过委托来进行访问)
(1)开启刷新进度条线程

  Thread t = new Thread(new ThreadStart(UpdataUIStatus));
  t.IsBackground = true;
  t.Start();

(2)线程函数

   #region 更新
        //申明一个委托对象
        public delegate void Action2<in T>(T t);
        private void UpdataUIStatus()
        {
            while (true)  //单独做一个线程来刷新进度条
            {
                if (Convert.ToInt32(this.progressBar1.Value.ToString()) >= Convert.ToInt32(this.progressBar1.Maximum.ToString())-1)
                {
                    return;
                }

               string ss = this.progressBar1.Value.ToString() + "/" + this.progressBar1.Maximum.ToString();

                Action2<string> a = new Action2<string>(Action2Test);
                Invoke(a, ss);
                Thread.Sleep(500);

               
            }
        }
        public void Action2Test(string t)   //在这里进行更新进度条，nowjindu是private变量，需要在for循环遍历时进行更新
        {
           
            int step = nowjindu;
            this.progressBar1.Value = step;
            this.label2.Text = t;
        }
        #endregion

18、postman生成的code不能直接用

这是postman生成的

var client = new RestClient("http://localhost/login/login");
var request = new RestRequest(Method.POST);
request.AddHeader("Postman-Token", "a5ac7e0e-17e9-451e-b6fb-16cd2f7906cb");
request.AddHeader("cache-control", "no-cache");
request.AddHeader("Content-Type", "application/x-www-form-urlencoded");
request.AddParameter("undefined", "user=userss&password='%20or%20'1'%3D'1'", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);

需要改成这样，把undefined修改

var client = new RestClient("http://localhost/login/login");
var request = new RestRequest(Method.POST);
request.AddHeader("cache-control", "no-cache");
request.AddHeader("Content-Type", "application/x-www-form-urlencoded");
request.AddParameter("application/x-www-form-urlencoded", "user=userss&password='%20or%20'1'%3D'1'", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);