LCZCGL项目，整理近期学的、用的-不熟练的 杂七杂八的东西

1、Excel生成guid，uuid  格式：600d65bc-948a-1260-2217-fd8dfeebb1cd

=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),"-",DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),"-","4",DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"-",DEC2HEX(RANDBETWEEN(8,11)),DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"-",DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)))

2、

将一个 JSON 字符串转换为对象
    var jsondata = JSON.parse(data);

延时方法
setTimeout(function () {
                loadcolor()
            }, 100);

 replace替换方法
            var key = "/";
            a= a(new RegExp (key,'g'),"~");

字符串截取
substr(start,[length])

多行添加颜色
$("#customTbody").find("#tr_0").find("#0-2").css("color", "red")；
function loadcolor() {
            var length = customTableList.length;//获取多行行数
            for (var i = 0; i < length; i++) {
    //添加颜色
                $("#customTbody").find("#tr_" + i).find("#" + i + "-2").css("color", "darkblue");
            }
        }

 
var num = /(^[1-9]\d*(\.\d{1,2})?$)|(^0(\.\d{1,2})?$)/;//金额验证正则表达式
        var money = $("#ZCDISPOSE_VALUE-M-KT").val();
         if (num.test(money)) {
             var sign = true;
         }
 var tel = /^0\d{2,3}-?\d{7,8}$/;//联系方式
 var phone = /^(((13[0-9]{1})|(15[0-9]{1})|(18[0-9]{1}))+\d{8})$/;

      //清空多行表中数据
        window.frames["ifm"].customTableList.splice(0);
        window.frames["ifm"].getPageCustomTable(window.frames["ifm"].curPage);

多行必填验证
if (!window.frames["ifm"].checkRequired()) {
                return false;
            }

点击确定，关闭本页面（×按钮已被隐藏）
layer.alert("该资产已发起过资产处置流程，请勿重复发起!",
                    { closeBtn: 0 },
                    function (index) {
                        window.close();
                    });

下拉列表自动赋值，退回后依旧有值
动态下拉列表
    //省市获取
    $.ajax({
        type: "POST",
        url: IISPath + "EAM/ZCReceive_Computer/Handler/Handler.ashx",
        data: { fun: "GetCityInfo", ProvinceInfo: "" },
        async: false,
        success: function (data) {
            if (data != null && data != "") {
                var jsondata = JSON.parse(data);
                var nameattr = "请选择省份^choose";
                for (var i = 0; i < jsondata.Table.length; i++) {
                    nameattr += "|" + jsondata.Table[i].CityName + "^" + jsondata.Table[i].CityNum;
                }
                $("#TD-ZCREC_SF-E-BT").attr("name", nameattr);
            }
        }
    })

去边框线
$("#ZCCANC_JBRNAME-S-BT").css("border","0");

转码--解码     escape()    unescape()

获取各种时间的方法
var myDate = new Date();
var year=myDate.getYear();     //获取当前年份(2位)
var year1=myDate.getFullYear();   //获取完整的年份(4位,1970-????)
var moonth=myDate.getMonth();      //获取当前月份(0-11,0代表1月)
myDate.getDate();       //获取当前日(1-31)
myDate.getDay();        //获取当前星期X(0-6,0代表星期天)
myDate.getTime();       //获取当前时间(从1970.1.1开始的毫秒数)
myDate.getHours();      //获取当前小时数(0-23)  
myDate.getMinutes();    //获取当前分钟数(0-59)
myDate.getSeconds();    //获取当前秒数(0-59)
myDate.getMilliseconds();   //获取当前毫秒数(0-999)  
var mytime=myDate.toLocaleDateString();    //获取当前日期    //怎么是英文的
var mytime=myDate.toLocaleTimeString();    //获取当前时间
var a=myDate.toLocaleString( );       //获取日期与时间

 

 

日期差值
DateTime dt = DateTime.Now;
        DateTime dt2 = Convert.ToDateTime("2010-4-9");
        Response.Write("入职日期："+dt2.ToString());
        Response.Write("<br>");
        Response.Write("当前日期："+dt.ToString());
        Response.Write("<br>");
        Response.Write("相差年："+(dt.Year - dt2.Year).ToString());
        Response.Write("<br>");
        Response.Write("相差月：" + ((dt.Year - dt2.Year) * 12 + dt.Month - dt2.Month).ToString());
        Response.Write("<br>");
        Response.Write("相差日：" + dt.Subtract(dt2).Duration().Days.ToString());
        Response.Write("<br>");