datatables model

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="t1.aspx.cs" Inherits="WinForm_t1" %>

<asp:Content ID="Content1" ContentPlaceHolderID="scriptcss" Runat="Server">
     <meta name="renderer" content="webkit">
  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

      <meta charset="UTF-8">
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, minimum-scale=1.0, maximum-scale=1.0, initial-scale=1.0, user-scalable=no">

    <link rel="stylesheet" href="../Scripts/frozenui-2.0.0/release/css/frozenui.css">
    <!--  <link rel="stylesheet" type="text/css" href="../Scripts/DataTables/DataTables-1.10.16/css/dataTables.bootstrap.css  "/>
   -->

   	<link href="../Scripts/DataTables/DataTables-1.10.16/css/jquery.dataTables.css" rel="stylesheet" type="text/css"/>
     <!--  <link rel="stylesheet" type="text/css" href="../Scripts/DataTables/plugin/buttons.dataTables.min.css">
	 
	-->
       <link rel="stylesheet" type="text/css" href="../Scripts/layui/css/layui.css" media="all" />
   
  <!--   <link rel="stylesheet" type="text/css" href="../Scripts/jquery-mobile/jquery.mobile-1.4.5.min.css" media="all" />
    -->

    
    <!--   <script src="../Scripts/jquery-mobile/jquery.mobile-1.4.5.min.js"></script>   -->
  <!--   <script  type="text/javascript"  src="../Scripts/jquery1.10.2/jquery.min.js"   ></script>   -->
    <script src="../Scripts/DataTables/DataTables-1.10.16/js/jquery.dataTables.min.js"></script>
    
    <script type="text/javascript"  src="../Scripts/DataTables/DataTables-1.10.16/js/dataTables.bootstrap.js"></script>
   
     <script src="../Scripts/DataTables/plugin/handlebars-v3.0.1.js"></script> 

	   
	 <script type="text/javascript" src="../Scripts/layer/layer.js"></script>

  <script type="text/javascript" src="../Scripts/layui/layui.js"></script>

	<!-- <script type="text/javascript" language="javascript" src="../Scripts/DataTables/DataTables-1.10.16/js/jquery.dataTables.min.js"></script> -->
	
	<script type="text/javascript"  src="../Scripts/DataTables/plugin/dataTables.buttons.min.js"></script>
	<script type="text/javascript"   src="../Scripts/DataTables/plugin/jszip.min.js"></script>
	<script type="text/javascript"   src="../Scripts/DataTables/plugin/pdfmake.min.js"></script>
	<script type="text/javascript"   src="../Scripts/DataTables/plugin/vfs_fonts.js"></script>
	<script type="text/javascript"  src="../Scripts/DataTables/plugin/buttons.html5.min.js"></script>
   

    <!--代码高亮-->

     <style>
        tfoot input {
        width: 100%;
        padding: 3px;
        box-sizing: border-box;
    }
        .strip1{
             background-color: #0094ff; color: #fff;
        }

         .strip2{
             background-color: #0094ff; color: #fff;
        }
        .bk{
            background-color: #009688; color: #fff;
        }
         
       table,table tr th, table tr td { border:1px solid #0094ff; }

      tr:hover
    {
     background:RGB(163,163,163);
     } 
       tr:hover td{background:RGB(163,163,163);}

      
       table tr:nth-child(odd) {
  background-color:#F5F5F5;
}
table tr:nth-child(even) {
  background-color:#fff;
}

body .yourclass{width:420px; height:240px; background-color:dimgrey; box-shadow: none; color:#fff;}
body .yourclass .layui-layer-content{ padding:20px;}
    </style>


    <script>

        function TableEdit(code, msg, data) {
            alert("ggggg");
        }


        function laytest(edit) {
        //    $('#tong').show();
             if (edit) {
                // 取到弹出层里的元素,并把编辑的内容放进去
                $("#supply").val("uuuuuuuuuuuu");  //id
              //  $("#item_id").val(edit.item_id);  //密码

                $("#supply").attr("value", edit.supply);
                $("#item_id").attr("value", edit.item_id);
                $("#podate").attr("value", edit.podate);
                $("#qty").attr("value", edit.qty);
               // alert($("#item_id").val());
            }
            layer.open({
                type: 1,
                title: false,
                area: ['700px', '450px'],
              //  closeBtn: 0,
                btn: ['Sure', 'Cancel'],

                success: function (layero, index) {

                  //  var form = $(layero).find("btn")[0].attr("disabled", true);
                 //   var body = layui.layer.getChildFrame('body', index);
                  
                },
                yes: function (index, layero) {
                    //按钮【按钮一】的回调
                    var editdata = {
                        "refid": 3333,
                        "cmd": "Delete"
                    };
                 //  ajaxTableEdit("http://localhost/kaflow/test", editdata);



                    $.ajax({
                        url: "http://localhost/kaflow/HttpServer/ftpserver.ashx",
                        type: "post",
                        dataType: "json",
                        crossDomain: true,
                        timeout: 60000,
                        data: JSON.stringify(editdata),
                        async: true,//异步还是同步
                        beforeSend: function (XMLHttpRequest) {
                            // SetBlockUI(90000);
                            layer.load();
                        },

                        error: function (jqXHR, textStatus, errorThrown) {
                          // SetRespResult('NG;' + jqXHR.status + '  ' + jqXHR.readyState + ' ' + jqXHR.statusText + '  ' + jqXHR.status + '  ' + textStatus + '  ' + errorThrown);
                         // var al=  layer.alert("Update Fail.../"+jqXHR.status + '  ' + jqXHR.readyState + ' ' + jqXHR.statusText + '  ' + jqXHR.status + '  ' + textStatus + '  ' + errorThrown, { icon: 5 });
                          layer.open({
                              title: 'Info',
                              content: jqXHR.status + '  ' + jqXHR.readyState + ' ' + jqXHR.statusText + '  ' + jqXHR.status + '  ' + textStatus + '  ' + errorThrown,
                              yes: function (index,layero) {
                                  //do something
                                  console.log(layero.context, index);
                                  layer.close(index); //如果设定了yes回调,需进行手工关闭
                                  return true;
                              }
                          });    

                        },
                        complete: function (XMLHttpRequest, textStatus) {
                            layer.closeAll('loading');
                            //  alert(textStatus);
                        },
                        success: function (data) {
                            if (data.code == "000") {
                                layer.msg('Success');
                                setTimeout(function () {
                                    layer.close(index);
                                    table.ajax.reload();
                                }, 100);
                               
                            }
                            else {
                                layer.alert('Update fail! Error msg is'+data.msg, { icon: 6 });
                            }
                        }
                    });

                    



                 //   layer.load();
                   //此处演示关闭
                  // setTimeout(function () {
                 //      layer.closeAll('loading');
                //   }, 8000);

                   // layer.close(index);
                },
                btn2: function (index, layero) {
                    //按钮【按钮二】的回调

                   // alert("Cancel");
                    //return false 开启该代码可禁止点击该按钮关闭
                },
                cancel: function () {
                    //右上角关闭回调

                    //return false 开启该代码可禁止点击该按钮关闭
                },
                btnAlign: 'c',
                shade:0.5,
                shadeClose: true,
                skin: 'yourclass',
                content: $('#tong').html()
            });
        }
      
    </script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CH" Runat="Server">

     <input type="hidden" id="lbluserid"  runat="server" /> 
    <input type="hidden" id="lblauthority" runat="server"  />
    <input type="hidden" id="lblfuncid" runat="server"  />
    <br />
     <center>
   <div style="width:96%; text-align:center"  >

  <div id="tong" class="hide" >
     
 <div class="ui-form-item ui-border-b">
                        <label>
                            Supply:
                        </label>
                        <input type="text"   id="supply" />
                        
                    </div>
                    <div class="ui-form-item ui-form-item-link ui-border-b">
                        <label>
                            PO Date:
                        </label>
                         <input type="text"   id="podate" />
                    </div>
                    <div class="ui-form-item ui-form-item-link ui-border-b">
                        <label>
                            Qty:
                        </label>
                        <input type="text"  id="qty" />
                    </div>
                    
                     <div class="ui-form-item ui-form-item-link ui-border-b">
                        <label>
                            Item ID:
                        </label>
                        <input type="text"   id="item_id" />
                    </div>
        


  
        

  </div>    
			 
    <table id="maincontent" style="width:100%;border:1px solid #0094ff;border-collapse:collapse;"    >
       <tfoot>
            <tr>
                <th colspan="4" style="text-align:right"></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th></th>
               <th></th>
                <th></th>

                 
                
            </tr>
       </tfoot>
    </table>
       </div>
        </center>
     <script id="tpl" type="text/x-handlebars-template">
    {{#each func}}
    <button type="button" class="btn btn-{{this.type}} btn-sm" onclick="{{this.fn}}">{{this.name}}</button>
    {{/each}}
</script>
    <script src="./jstable/pohis.js"></script>
  
     <asp:UpdatePanel ID="rspbar" runat="server">
                <ContentTemplate>
                    <div id="divtool"  > 
                    </div> 
                </ContentTemplate>
            </asp:UpdatePanel>
</asp:Content>

 
    var table;
    var ActionFlag = false;
	var rowdata;
    $(document).ajaxStart(function () { SetBlockUI(90000); }).ajaxStop(function () { ClearBlockUI();});
    var columns = [

       
        { data: "refid", title: "seq", visible: true,},
      
        /*
		 {   data: null,//字段名  
                    defaultContent:'<input type="checkbox" id="checkAll">',//无默认值  
					title:"Selected",
					width: "3%",
					searchable: true,
                    orderable : false//禁用排序  
                }  ,
				*/
    { data: "supply", title: "Supply", "searchable": true, "orderable": false, },			
    {
        data: "create_time", title: "PO Date", "width": "15%",  
       
	   render : function(data,type, row, meta) {  
                        return data.substring(0,10);  
              
                    }

    },
    { data: "requser", title: "requser", visible: false, },
	  
	   { data: "qty", title: "qty", },
       {
           data: "form_id", title: "form_id", className: "bk",

        render : function(data,type, row, meta) {  
                        return '<a   style="color:#fff;" target="_blank"  href="pd100.aspx?Action=View&&form_id='+data +'">'+data +'</a>'; 
              
                    }
	   },
       { data: "cost_code", title: "cost_code", visible: false, },
		 
		{data:"item_id",  title:"item_id", name:"物料编码",
         "render":function(data,type,row,meta){
             return data; // '<a class="num" style="color:#697ECC;" href="#">'+row.item_id+'</a>';
        }

		},
        { data: "item_desc", title: "Item Name", },
        
        
       
        { data: "sum_price", title: "Total tax price", },
        {
            data: "refid", title: "Command", "width": "12%",
            render: function (data, type, row, meta) {
                // return data.substring(0, 10);
                //  return "<button type=\"button\" class=\"btn btn-xs btn-default command-edit\" data-row-id=\"" + row.id + "\"><span class=\"fa fa-pencil\"></span></button> " +
                //    "<button type=\"button\" class=\"btn btn-xs btn-default command-delete\" data-row-id=\"" + row.id + "\"><span class=\"fa fa-trash-o\"></span></button>";

                //  return "<i class=\"layui- icon\" style=\"font- size: 30px; color: #1E9FFF;\">&#xe63d;</i>";

                return " <a class=\"layui-btn layui-btn-xs\" id=\"refid\"" + data + "\"  name=\"btnedit\" lay-event=\"edit\">Edit</a>" +
                    " <a class=\"layui-btn layui-btn-danger layui-btn-xs\" name=\"btndel\" lay-event=\"del\">Delete</a>";
            }

        }
       
       
        ];
		
    $(function () {

     //   $('#start_date').datetimepicker();

        var tpl = $("#tpl").html();
        //预编译模板
        var template = Handlebars.compile(tpl);
        var obj;
        table = $('#maincontent').DataTable({
            ajax: {
                  type: "post",
                    url: "http://www.qmtec.net/KAFLow/HttpServer/poserver.ashx", 
				  dataType: "json", 
				  crossDomain: true,
				  timeout: 60000,
				  data: JSON.stringify(obj)
            },
            //  dom: 'Bfrtip',
            "orderClasses": true,
            "searchCols": [
                null,
                
                null 
                 
            ],
            "search": {
                "caseInsensitive": true   //不区分大小写
            },
            "orderMulti": false,
            // "stripeClasses": ['strip1', 'strip2'],
            buttons: [
            'copyHtml5',
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
        ],
			 lengthMenu: [5,10, 15, 20,50,100,300],
			  "lengthChange": true,//是否允许用户自定义显示数量
            "bPaginate": true, //翻页功能
            "bFilter": true, //列筛序功能
            "searching": true,//本地搜索
            "ordering": true, //排序功能
            "Info": true,//页脚信息
			
              "columns": columns,
            "columnDefs": [
                {
                   // "searchable": false,
                    //"orderable": false,
                    "targets": [0.-1]
                },
				/*
                {
                    "targets": 16,
                    "render": function (a, b, c, d) {
                        var context =
                        {
                            func: [
                                {"name": "修改", "fn": "edit(\'" + c.item_id + "\',\'" + c.item_desc + "\',\'" + c.main_code + "\',\'" + c.sub1_code + "\',\'" + c.sub2_code + "\',\'" + c.seq_code + "\',\'" + c.spec + "\',\'" + c.unit + "\',\'" + c.brand + "\',\'" + c.company + "\',\'" + c.status + "\',\'" + c.memo + "\')", "type": "primary"},
                                {"name": "删除", "fn": "del(\'" + c.item_id + "\')", "type": "danger"}
                            ]
                        };
                        var html = template(context);
                        return html;
                    }
                }*/

            ],
            "language": {
                "lengthMenu": "每页_MENU_ 条记录",
                "zeroRecords": "没有找到记录",
                "info": "第 _PAGE_ 页 ( 总共 _PAGES_ 页 )",
                "infoEmpty": "无记录",
				"sInfo": "当前显示 _START_ 到 _END_ 条,共 _TOTAL_ 条记录。",
                "sInfoEmpty": "当前显示0到0条,共0条记录",
                "sInfoFiltered": "(数据库中共为 _MAX_ 条记录)",
                "search": "Search:",
                "infoFiltered": "(从 _MAX_ 条记录过滤)",
                "paginate": {
                    "previous": "上一页",
                    "next": "下一页"
                }
            },

            "dom": "<'row'<'col-xs-2'l><'#mytool.col-xs-4'f><'col-xs-6'B>r>" +
            "t" +
            "<'row'<'col-xs-6'i><'col-xs-6'p>>",

            buttons: [
                { extend: 'copyHtml5', 'text': 'Copy',  className: "btn btn-default btn-xs" },
                { extend: 'excelHtml5', className: 'btn btn-info btn-xs' },
                { extend: 'csvHtml5', className: 'btn btn-default btn-xs' } 
            ],

            "footerCallback": function (row, data, start, end, display) {
                var api = this.api(), data;

                // Remove the formatting to get integer data for summation
                var intVal = function (i) {
                    return typeof i === 'string' ?
                        i.replace(/[\$,]/g, '') * 1 :
                        typeof i === 'number' ?
                            i : 0;
                };

                // Total over all pages
                total = api
                    .column(10)
                    .data()
                    .reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    },0);


                // Total over this page
                pageTotal = api
                    .column(10, { page: 'current' })
                    .data()
                    .reduce(function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0);

                // Update footer
                $(api.column(1).footer()).html(
                    //  '$' + pageTotal + ' ( $' + total + ' total)'
                    '$' + pageTotal.toFixed(2) + ' ( $' + total.toFixed(2) + ' total)'
                );

                
            },



            "initComplete": function () {
            //    $("#mytool").append('<button id="datainit" type="button" class="btn btn-primary btn-xs">Column</button>&nbsp');
             //  $("#mytool").append('<button type="button" class="btn btn-default btn-sm" data-toggle="modal" data-target="#myModal">添加</button>');
                 $("#mytool").append('<button type="button" class="btn btn-default btn-xs" id="btntooladd">添加</button>&nbsp');
				$("#mytool").append('<button type="button" class="btn btn-default btn-xs" id="btntooldel">Del</button>&nbsp');
				//$("#mytool").append('<button type="button" class="btn btn-info btn-xs" id="btntoolview">View</button>&nbsp');
				$("#mytool").append('<button type="button" class="btn btn-default btn-xs" id="btntoolupdate">更新</button>&nbsp');
				$("#mytool").append('<button type="button" class="btn btn-default btn-xs" id="showcol">隐藏</button>&nbsp');
				$("#mytool").append('<button type="button" class="btn btn-default btn-xs" id="btntoolcopyadd">Copy</button>&nbsp');
				$("#mytool").append('<button type="button" class="btn btn-default btn-xs" id="showt2">XXX</button>&nbsp');
				$("#mytool").append('<button type="button" class="btn btn-default btn-xs" id="showt3">XXX</button>&nbsp');
				
				
				$("#datainit").on("click", initData);
				$("#btntooladd").on("click", addnew);
				$("#btntoolview").on("click", toolview);
				$("#btntooldel").on("click", tooldel);
				$("#btntoolupdate").on("click", toolupdate);
				$("#btntoolcopyadd").on("click", toolcopyadd);
				
				InitRole();
				//addfootsearch();
            }

          


        });


       // $('#maincontent tbody tr:odd').css("backgroundColor", "#068");

        //添加序号
        //不管是排序,还是分页,还是搜索最后都会重画,这里监听draw事件即可
        table.on('draw.dt',function() {
                    table.column(0, {
                        search: 'applied',
                        order: 'applied'
                    }).nodes().each(function(cell, i) {
                        //i 从0开始,所以这里先加1
                        i = i+1;
                        //服务器模式下获取分页信息
                        var page = table.page.info();
                        //当前第几页,从0开始
                        var pageno = page.page;
                        //每页数据
                        var length = page.length;
                        //行号等于 页数*每页数据长度+行号
                      //  var columnIndex = (i+pageno*length);
                        //cell.innerHTML = columnIndex;
                    });
                }).draw();

        $("#save").click(add);
         $("#btnupdate").click(updatedata);
        $("#initData").click(initSingleData);
		
        $('#showcol').click(function () {
            $('.showul').toggle();


        




        });

        addfootsearch();
       
		 //删除选中行
        $('#maincontent tbody').on('click', 'tr a[name="btndel"]', function () {
            var $tr = $(this).parents('tr');

            var idx = table
                .row($(this).parents('tr'))
                .index();

            var dt = table
                .row($(this).parents('tr')).data();

            console.log(dt.refid);

            var jsondata = { 
                "cmd": "Delete",
                "refid": dt.refid 
            };
           // alert(idx);

            //  $tr.remove();

            if (jConfirm("Are you delete?")) {
                ajaxTableDel("http://localhost/kaflow/HttpServer/ftpserver.ashx", jsondata, idx);
            }
            else {
                AlertHit("Cancelled...");
            }
           
         //   SetBlockUI(90000);
          //  ajax(jsondata);
           // layer.msg('Delete Success');\
           // ClearBlockUI();
           

         //   table.page('next').draw('page');

      //  table.ajax.reload();
          // alert( table.row(idx).data().supply);

            //$tr.toggleClass('selected');

          //  var $tmp = $('[name=checkList]:checkbox');
          //  $('#checkAll').prop('checked', $tmp.length == $tmp.filter(':checked').length);
          //  alert($tr.tostring());
           // var data = table.row(this).data();//获取值的对象数据
            //  alert(JSON.stringify($tr));//某一行中要是用的表头值
            // var id = table.row(this).id();
          // var tt = table.row(this);
          //  var row = table.row(this);
        //   var rows = table.rows('.selected').indexes();
           var data = table.rows(1).data();

           var ttt = $(this);
           var t3 = $(this).parent();

           var table1 = document.getElementById("maincontent");
          // console.log(table1.rows[0].cells.length);
          // console.log(table1.rows[1].cells.item(2).innerHTML);

         //  console.log(table1.rows[1].cells.namedItem("qty").innerHTML);


        //   var x = document.getElementById("maincontent").rows[1].cells;
       //    x[2].innerHTML = "NEW CONTENT";

         var rows = table1.rows;//获取所有行
    /* 
   for(var i=1; i < rows.length; i++){
      var row = rows[i];//获取每一行
     var id = row.cells[2].innerHTML;//获取具体单元格
       
    }
            */
            /*
   if ($tr.hasClass('selected')) {

       $tr.removeClass('selected');
   }
   else {
       table.$('tr.selected').removeClass('selected');
       $tr.addClass('selected');

   }
            */

   var tt = table.rows('tr.selected');

   var tx = $(".selected");

   
  /* var d1 = table.rows(xx).data();

   var rowsa = table.rows(0).data();

   var tablew = $('#maincontent').DataTable();

   var x1 = tablew.rows('.selected').indexes();
   if (x1 != undefined) {
       console.log(tablew.row(x1).data());
*/
  // }
  
 //  var data = tablew
 //      .rows()
   //    .data();

   //alert('The table has ' + data.length + ' records');
          // alert('' + JSON.stringify(data));
           // alert($(this).context._DT_RowIndex); //行号)
        });

        $('#maincontent tbody').on('click', 'tr a[name="btnedit"]', function () {
            var dt = table
                .row($(this).parents('tr')).data();

            var editdata = {
                "supply": dt.supply,
                "podate": dt.create_time,
                "qty": dt.qty,
                "item_id": dt.item_id

            };

            console.log(editdata);
            laytest(editdata);
        });

        function obj2string(o) {
            var r = [];
            if (typeof o == "string") {
                return "\"" + o.replace(/([\'\"\\])/g, "\\$1").replace(/(\n)/g, "\\n").replace(/(\r)/g, "\\r").replace(/(\t)/g, "\\t") + "\"";
            }
            if (typeof o == "object") {
                if (!o.sort) {
                    for (var i in o) {
                        r.push(i + ":" + obj2string(o[i]));
                    }
                    if (!!document.all && !/^\n?function\s*toString\(\)\s*\{\n?\s*\[native code\]\n?\s*\}\n?\s*$/.test(o.toString)) {
                        r.push("toString:" + o.toString.toString());
                    }
                    r = "{" + r.join() + "}";
                } else {
                    for (var i = 0; i < o.length; i++) {
                        r.push(obj2string(o[i]))
                    }
                    r = "[" + r.join() + "]";
                }
                return r;
            }
            return o.toString();
        }
		/*
        $('#maincontent tbody').on('click', 'tr a[name="btnedit"]', function () {
            console.log(table.row(this).data());
        });
		 

        


		 $('#maincontent tfoot th').each( function () {
        var title = $('#maincontent thead th').eq( $(this).index() ).text();
        $(this).html( '<input type="text" placeholder="Search '+title+'" />' );
    } );
 
    
  //  var table = $('#maincontent').DataTable();
 
 
		
		
		
		
		
		
		
	/*	
		$('#maincontent').on( 'click', 'tr', function () {
        if ( $(this).hasClass('selected') ) {
		
		rowdata=null;
            $(this).removeClass('selected');
        }
        else {
            table.$('tr.selected').removeClass('selected');
            $(this).addClass('selected');
			//alert("selet");
		rowdata=table.row( this ).data();
		 
        }
         });
        */
		
    });

    /**
     * 初始化基础数据
     */
    function initData() {
	
        $('.showul').toggle();
    }
	
	function addfootsearch(){
	$('#maincontent tfoot th').each(function () {
            var title = $('#maincontent thead th').eq($(this).index()).text();
            $(this).html('<input type="text"    placeholder=" ' + title + '" />');
        });
		
	table.columns().eq(0).each(function (colIdx) {
            $('input', table.column(colIdx).footer()).on('keyup change', function () {
                table
                        .column(colIdx)
                        .search(this.value)
                        .draw();
            });
        });
	}
		
	function InitRole(){
	
  if( $("#CH_lblauthority").val()=='admin'){
    
	$("#showt2").hide();
	$("#showt3").hide();
	//$("#btntoolcopyadd").show();
	//$("#btntooladd").show();
    $("#btntoolcopyadd").hide();
    $("#btntooladd").hide();

	$("#btntooldel").show();
	$("#btntoolupdate").show();
	$("#showcol").hide();
	//$("#").hide();
  }
  else if($("#CH_lblauthority").val()=='view'){
	$("#showt2").hide();
	$("#showt3").hide();
	$("#btntoolcopyadd").hide();
	$("#btntooladd").hide();
	$("#btntooldel").hide();
	$("#btntoolupdate").hide();
	$("#showcol").hide();
  }
  else{
	  $("#showt2").hide();
	$("#showt3").hide();
	$("#btntoolcopyadd").hide();
	$("#btntooladd").hide();
	$("#btntooldel").hide();
	$("#btntoolupdate").hide();
	$("#showcol").hide();
  }
	  
    
	}  //end of InitRole
	
	
	
	function addnew()
	{
	 $('#txtcreate_by').hide();
	 $('#lblcreate_by').hide();
	 $('#lblcreate_time').hide();
	 $('#txtcreate_time').hide();
	 $("#save").show();
	 $("#btnupdate").hide();
	$('#myModal').modal('show');
	}

	function tooldel()
	{
	  if(rowdata==null)
	  {
	    alert("no Selected row");
	  }
	  else
	  {
	  if(jConfirm("Are you sure delete Item ID:"+rowdata.item_id+'  Item_desc: '+rowdata.item_desc)==true){
	  ActionFlag="Del";
	    del(rowdata.item_id);
		rowdata=null;
		}
	  }
	}
	
	function toolview()
	{
	  if(rowdata==null)
	  {
		window.wxc.xcConfirm("请选中一个行 \r\nPlease choose a Selected row", window.wxc.xcConfirm.typeEnum.info);

	    //alert("no Selected row");
	  }
	  else
	  {
	     $("#save").hide();
		 $("#btnupdate").hide();
        $("#myModalLabel").text("View");
        SetRowData();
        $("#myModal").modal("show");
	  }
	}
	
	function toolupdate()
	{
	    $("#save").hide();
		
		$("#btnupdate").show();
	   $("#myModalLabel").text("Update");
        SetRowData();
        $("#myModal").modal("show");
	}
	
	//复制添加
	function toolcopyadd(){
	 $("#save").show();
		 $("#btnupdate").hide();
        $("#myModalLabel").text("Copy Add");
        SetRowData();
        $("#myModal").modal("show");
	
	}
	
	
	  //显示隐藏列
        $('.toggle-vis').on('change', function (e) {
            e.preventDefault();
            console.log($(this).attr('data-column'));
            var column = table.column($(this).attr('data-column'));
			 
            column.visible(!column.visible());
        });
	
		
    /**
     * 初始化基础数据
     */
    function initSingleData() {
      //  $("#name").val("http://datatables.club");
      
    }

	
	 function jConfirm(msg) {
               if (confirm(msg)) {
                   return true;
               }
               return false;
           }
		   
		   
    /**
     * 清除
     */
    function clear() {
         
    }

    /**
     * 添加数据
     **/
    function add() {
        var addJson =GetItemData("Add");
         
        ajax(addJson);
    }
 
  /**
     * 更新数据
     **/
	
	function updatedata(){
	
	var addJson =GetItemData("Update");
        ajax(addJson);
	
	}
	
	/**
     * 删除数据
     * @param name
     */
    function del(item_id) {
     var addJson =GetItemData("Del");
	 addJson.item_id=item_id;
        ajax(addJson);
    }
	
	
    /**
     *编辑方法
     **/
    function edit( item_id,item_desc,main_code,sub1_code,sub2_code,seq_code,spec,unit,brand,company,status,memo) {
        console.log(name);
        ActionFlag = "update";
        $("#myModalLabel").text("修改");
        $("#txtitem_id").val(item_id),
            $("#txtitem_desc").val(item_desc),

         $("#txtmain_code").val(main_code),
         $("#txtsub1_code").val(sub1_code),
         $("#txtsub2_code").val(sub2_code),
         $("#txtseq_code").val(seq_code),
         $("#txtspec").val(spec),
         $("#txtunit").val(unit),
         $("#txtbrand").val(brand),
         $("#txtcompany").val(company),
         $("#txtstatus").val(status),
         $("#txtmemo").val(memo),
        $("#myModal").modal("show");
    }

    function DelCon(index, code) {
        if (code == "000") {
            AlertOK("Success");
            table
                .row(index)
                .remove()
                .draw();
        }
        else {
            AlertNG("Fail");
        }

    }

    function TableDel(index, code, msg) {
    if (code == "000") {
        AlertOK("Success");
        table
            .row(index)
            .remove()
            .draw();
    }
    else {
        AlertNG("Fail");
    }
    };



    function ajax(obj, index) {
        var url ="http://localhost/kaflow/HttpServer/ftpserver.ashx" ;
        
        $.ajax({
            url:url ,
			type: "post",
			dataType: "json", 
			crossDomain: true,
			timeout: 60000,
            data: JSON.stringify(obj), 
            async: true,//异步还是同步
            beforeSend: function (XMLHttpRequest) {
                // SetBlockUI(90000);
            },
            
            error: function (jqXHR, textStatus, errorThrown) {
                SetRespResult('NG;' + jqXHR.status + '  ' + jqXHR.readyState + ' ' + jqXHR.statusText + '  ' + jqXHR.status + '  ' + textStatus + '  ' + errorThrown);
            },
            complete: function (XMLHttpRequest, textStatus) {
               //  ClearBlockUI();
              //  alert(textStatus);
            },
			success: function (data) {
			if(data==null)
            {
                DelCon(index, "200");
			  window.wxc.xcConfirm("Server Error..", window.wxc.xcConfirm.typeEnum.error);
			}
			else
			{
			 
			  if(data.code=="000"){
              //  table.ajax.reload();
              //  $("#myModal").modal("hide");
               // $("#myModalLabel").text("新增");
               // clear();

                  DelCon(index, "000");
				}
				else
              {
                  DelCon(index, "100");
                  //alert(data.msg);
					window.wxc.xcConfirm(data.msg, window.wxc.xcConfirm.typeEnum.error);
				}
 
            }
			}
			
        });
    }

	
	function SetRowData(){
	
	     $("#txtitem_id").val(rowdata.item_id);
         $("#txtitem_desc").val(rowdata.item_desc);
         $("#txtitem_eng").val(rowdata.item_eng);
         $("#txtmain_code").val(rowdata.main_code);
         $("#txtsub1_code").val(rowdata.sub1_code);
         $("#txtsub2_code").val(rowdata.sub2_code);
         $("#txtseq_code").val(rowdata.seq_code);
         $("#txtspec").val(rowdata.spec);
         $("#txtunit").val(rowdata.unit);
         $("#txtbrand").val(rowdata.brand);
         $("#txtcompany").val(rowdata.company);
         $("#txtstatus").val(rowdata.status);
         $("#txtmemo").val(rowdata.memo);
	
	}
	
	
	function GetItemData(action){
	var jsondata = {
	
	    "action":"",
        "start_time": "",
        
        "end_time": ""
	}
	return jsondata;
	}
	

     

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

Farmwang

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值