力软敏捷开发框架前后端基础语法

(1)前台技术：ajax+Jquery+jqgrid+Bootstrap

(2)开发环境：VS2012-VS2015

(3)数据库：SQL Server，Oracle、Mysql

(5)后台技术：ASP.NET MVC，TinyIoc(IoC容器)，EF(ORM框架)，Log4Net，NPOI等

7、字典

$('#F_ContractType').lrDataItemSelect({ code: 'htpslx' });

8、js设置属性：

                $("#F_DeviceNumber").attr("readOnly",true);

                $("#F_FaultTime").attr("disabled",true);

9、获取当前用户

            //获取当前用户

            var user = learun.clientdata.get(['userinfo']).realName

            document.getElementById("F_Applyer").value = user

10、获取当前时间

            //获取当前时间

            var nowDate = new Date();

            var year = nowDate.getFullYear();

            var month = nowDate.getMonth() + 1 < 10 ? "0" + (nowDate.getMonth() + 1) : nowDate.getMonth() + 1;

            var date = nowDate.getDate() < 10 ? "0" + nowDate.getDate() : nowDate.getDate();

            var hour = nowDate.getHours() < 10 ? "0" + nowDate.getHours() : nowDate.getHours();

            var minute = nowDate.getMinutes() < 10 ? "0" + nowDate.getMinutes() : nowDate.getMinutes();

            var second = nowDate.getSeconds() < 10 ? "0" + nowDate.getSeconds() : nowDate.getSeconds();

            var now = year + "-" + month + "-" + date + " " + hour + ":" + minute + ":" + second;

            document.getElementById("F_ApplyTime").value = now;

11、获取当前用户ID

        var userID = learun.clientdata.get(['userinfo']).userId

        formData.F_ApplyerId = userID;

12、数据表显示下拉框（数据源）

$('#F_DeviceNumber').lrDataSourceSelect({ code: 'DeviceNumber', value: 'f_equipmentnumber', text: 'f_equipmentnumber' });

13、跳出提示框

learun.alert.warning("请填写搜索内容！");

14、设置表单数据为只读

            $('#F_Work')[0].ke.readonly(true);

            $('#F_Project')[0].ke.readonly(true);

15、判断gridcontrol是否为空

        var a = $('#BMS_Base_F_Work').jfGridGet("rowdatas");

        console.log(a)

        if (a == '' || a == null) {

            learun.alert.error("日常工作概要不能为空！");

            return false;

        }

循环判断：

        for (var t = 0; t < a.length; t++) {

            if (a[t].hasOwnProperty('F_col1')) {

            } else {

                learun.alert.warning("日常工作概要第" + (t + 1) + "行的工作时间(小时)不能为空！");

                return false;

            }

            if (a[t].hasOwnProperty('F_col2')) {

            } else {

                learun.alert.warning("日常工作概要第" + (t + 1) + "行的做的工作不能为空！");

                return false;

            }

            if (a[t].hasOwnProperty('F_col3')) {

            } else {

                learun.alert.warning("日常工作概要第" + (t + 1) + "行的数量不能为空！");

                return false;

            }

        }

16、附件名称同步

                //附件名称更新同步

                $('#F_DetailedList .lrUploader-input').on('DOMNodeInserted', function () {

                    var param = {};

                    param.keyValue = selectedRow.F_Id;

                    param.fileName = $("#F_DetailedList .lrUploader-input").text();

                    $.lrSetForm(top.$.rootUrl + "/LR_CodeDemo/EnquiryRequirements/SaveFileName?queryJson=" + JSON.stringify(param), function (data) {

                    });

                })

17、设置单元格显示格式

formatter: function (cellvalue) {

                            if (cellvalue == "已通过") {

                                return '<span class=\"label label-danger\">待报价</span>';

                            } else if (cellvalue == "已报价") {

                                return '<span class=\"label label-success\">已报价</span>';

                            } else if (cellvalue == "磋商中") {

                                return '<span class=\"label label-success\">磋商中</span>';

                            } else if (cellvalue == "关闭") {

                                return '<span class=\"label label-default\">关闭</span>';

                            } else if (cellvalue == "完成") {

                                return '<span class=\"label label-success\">完成</span>';

                            }

                        }},

18、拿到下拉框的值

var a = $('#F_UnitType')[0].innerText;

19、下拉框点击事件：

$('#F_UnitType').lrDataSourceSelect({ code: 'DeviceNumber', value: 'f_equipmentnumber ', text: 'f_equipmentnumber' }).on('change', function () {

            

                var a = $('#F_UnitType')[0].innerText;

                console.log(a);

                判断主语言是否重复

                learun.httpAsyncGet(top.$.rootUrl + '/LR_CodeDemo/MachineBook/GetDeviceNameByType?type=' + a, function (res) {

                    console.log(res["info"]);

                    document.getElementById("F_UnitName").value = res["info"];

                });

            });

20、获取查询到的列表值

data.BMS_Base_Purchase[0].F_WorkNumber

21、拿到文本框的值

$('#F_OrderType').children()[0].outerText;

22、查询数值赋值到单元格

       

        var equipments = $('#BMS_Base_SaleEquipment').jfGridGet('rowdatas');

        for (var j = 0; j < equipments.length; j++) {

            console.log(equipments[j].F_DeviceName);

            console.log(equipments[j].F_SpecificationsModels);

            if (!equipments[j].F_DeviceName) {

                learun.alert.error('设备名称不能为空');

                return false;

            }

            if (!equipments[j].F_SpecificationsModels) {

                learun.alert.error('设备型号不能为空');

                return false;

            }

            if (!!equipments[j].F_DeviceName && !!equipments[j].F_SpecificationsModels) {

                

                var a = learun.httpGet(top.$.rootUrl + '/LR_CodeDemo/SaleParameter/GetERP?name=' + equipments[j].F_DeviceName + '&model=' + equipments[j].F_SpecificationsModels).data.新编号;

                equipments[j].F_Code = a;

            }

        }

        $('#BMS_Base_SaleEquipment').jfGridSet('refreshdata', equipments);

23、获取部门名称

$('#F_UserDepartment')[0].lrvalue = learun.clientdata.get(['userinfo']).departmentId;

            learun.clientdata.getAsync('department', {

                key: learun.clientdata.get(['userinfo']).departmentId,

                callback: function (_data) {

                    $('#F_UserDepartment').val(_data.name);

                }

            });

24、转换

                            var a = eval（'(' + data + ')')

25、获取单选按钮的值

        var MaintenanceItem = eval（'(' + eval（postData).strbMS_Base_ProjectEntity + ')').F_MaintenanceItem;//获取单选按钮选中的值

$("input[name='F_YN']:checked").val()；获取单选选择的是哪个（获取值）

        var user = learun.clientdata.get(['userinfo']).realName;

        console.log(MaintenanceItem);

        if (MaintenanceItem == '是')

        {

            learun.alert.warning("没有选择是否为维修项目");

            return;

        }

        if (MaintenanceItem == "否") {

            if (!$("#F_Contract .lrUploader-input").text()) {

                learun.alert.warning("没有上传合同");

                return;

            }

        }

默认选中第一个：

            $('#F_YN').find('input').eq(0).trigger('click');

            $('input:radio[name="F_ParticipateStatus"][value="参加"]')[0].checked = true;

26、清空文本框的值

document.getElementById("F_WorkNumber").value = "";

27、获取返回值

                   var money = res.data[0]["f_contractmoney"];

            var contracttype = res.data[0]["f_contracttype"];

28、按钮隐藏

           $("#select_Device").attr("style", "display:none;");

29、字典

            $('#F_MarriageStatus').lrDataItemSelect({ code: 'MarriageStatus' });

30、查询语句

var strSql = new StringBuilder();

                strSql.Append("SELECT DISTINCT");

                strSql.Append(@"

                b.F_UserId ,

                b.F_RealName,

                t.F_Description,

                c.F_CompanyName,

                c.F_LastModify,

                c.F_UserCapability,

                c.F_Note,

                c.F_BusinessLicense,

                c.F_Id,

                c.F_VIP");

                strSql.Append(" FROM BMS_Base_EnquiryCustomInfo c ");

                strSql.Append(" LEFT JOIN " + non_standard_cloud.dataBase + ".dbo.[LR_Base_User] b ON c.F_ParentId=b.F_UserId");

                strSql.Append(" LEFT JOIN  (SELECT F_RequirementsSubmitter , Count(F_Id) AS F_Description FROM BMS_Base_EnquiryRequirements GROUP BY F_RequirementsSubmitter )AS t ON b.F_UserId = t.F_RequirementsSubmitter");

                strSql.Append(" WHERE 1=1 ");

                strSql.Append(" AND b.F_DeleteMark = 0");

                return this.BaseRepository("db_xiangmuguanli_test").FindTable(strSql.ToString(), pagination);

.OrderByDescending(t => t.F_CreateDate)

31、标记颜色：                         

formatter: function (cellvalue) {

                                if (cellvalue == "1") {

                                    //return '<span class=\"label label-warning\"></span>';

                                    return '<span class=\"label \" style="background-color: #32CD32;">  √  </span>';

                                }  else {

                                    return '<span>' + cellvalue + '</span>';

                                }

                            }

31、Get

        learun.httpAsyncGet(top.$.rootUrl + '/LR_LGManager/LGType/GetEntityByCode?keyValue=' + postData.F_Code, function (res) {

            //判断编辑是否更改编码

            if (res.data) {

                learun.alert.warning("编码已存在");

                return false;

            }

})；

                                        

32、Post:

learun.layerConfirm('是否确认撤销流程？', function (res, _index) {

                                            if (res) {

                                                

                                                learun.loading(true, '撤销流程...');

                                                var postData = {

                                                    processId: row.F_Id,

                                                };

                                                learun.httpAsync('Post', top.$.rootUrl + '/LR_NewWorkFlow/NWFProcess/RevokeFlow', postData, function (data) {

                                                    learun.loading(false);

                                                    refreshGirdData();

                                                });

                                                top.layer.close(_index);

                                            }

                                        });

33、post

                                    learun.httpAsync('Post', top.$.rootUrl + '/LR_CodeDemo/YPProjectMan/SaveFormProjectMan', postData, function (data) {

                                        page.initGird();

                                    });

34、截取时间

                        formatter: function (value, row, op, $cell) {

                            if (!!value) {

                                return value.substring(0, 11);

                            }

                        }

35、jfgrid点击跳转

{

                        label: "项目编号", name: "F_project_number", width: 150, align: "left",

                        formatter: function (cellvalue, row, dfop, $cell) {

                            $cell.on('click', '.start', function () {// 点击跳出界面

                                var keyValue = row.F_Id;

                                if (learun.checkrow(keyValue)) {

                                    learun.layerForm({

                                        id: 'form1',

                                        title: '查看',

                                        url: top.$.rootUrl + '/LR_CodeDemo/PurchaseInterface/Form?keyValue=' + keyValue,

                                        width: 1000,

                                        height: 800,

                                        btn: ['关闭']

                                    });

                                };

                                return false;

                            });

                            return '<span style = "color:blue;" class="label label-link start" ><ins>' + cellvalue + '</ins></span>';

                        }

                    },

36、升序排列

.OrderBy(t => t.F_ProjectNumber).AsList()

37、新界面

                if (learun.checkrow(keyValue)) {

                    var keyValue = $('#gridtable').jfGridValue('F_Id');

                    var name = $('#gridtable').jfGridValue('F_ProjectName');

                    top.learun.frameTab.open({ F_ModuleId: "edit" + keyValue, F_FullName: "编辑" + name, F_UrlAddress: top.$.rootUrl + '/LR_CodeDemo/ProjectG/FormEdit?keyValue=' + keyValue });

                }

38、排版

                    <div class="lr-layout-tool-item">

                        <span>项目编号</span>

                        <input id="F_project_number" type="text" class="form-control" style="height:28px;width:150px" />

                    </div>

                    <div class="lr-layout-tool-item">

                        <span>项目名称</span>

                        <input id="F_project_name" type="text" class="form-control" style="height:28px;width:150px" />

                    </div>

                    <div class="lr-layout-tool-item">

                        <span>采购组织</span>

                        <input id="F_purchse_organization" type="text" class="form-control" style="height:28px;width:150px" />

                    </div>

                    <div class="lr-layout-tool-item">

                        <button type="button" class=" btn btn-primary search" style="float:right">查询</button>

                    </div>

39、自定义按钮

            $('.search').on('click', function () {

                if (!$('body').lrValidform()) {

                    return false;

                }

                var groupData = $('#BMS_Base_ProjectGroup').jfGridGet('rowdatas');

                var manager = 0;

                for (var i in groupData) {

                    var F_ProjectRole = groupData[i].F_ProjectRole;

                    var F_Personnel = groupData[i].F_Personnel;

                    if (!F_ProjectRole || !F_Personnel) {

                        learun.alert.warning('团队成员表项目角色、人员不能为空！');

                        return false;

                    }

                    if (F_ProjectRole == '管理员') {

                        manager++;

                    }

                }

                if (manager != 1) {

                    learun.alert.warning('团队有且只能有一个管理员！');

                    return;

                }

                var postData = {};

                postData.strEntity = JSON.stringify($('body').lrGetFormData());

                postData.strbMS_Base_ProjectGroupList = JSON.stringify(groupData);

                postData.strbMS_Base_ProjectMissonList = JSON.stringify([]);

                //postData.strbMS_Base_SaleEquipmentList = JSON.stringify($('#BMS_Base_SaleEquipment').jfGridGet('rowdatas'));

                postData.strbMS_Base_SaleEquipmentList = JSON.stringify([]);

                $.lrSaveForm(top.$.rootUrl + '/LR_CodeDemo/ProjectG/SaveForm?keyValue=' + keyValue, postData, function (res) {

                    //learun.frameTab.close("edit" + keyValue);

                });

            });

40、传json

                                for (var index in data) {

                                    var rowData = {};

                                    rowData.F_DeviceName = data[index].F_DeviceName;

                                    rowData.F_DeviceDiretion = data[index].F_DeviceDirection;

                                    rowData.F_DeviceSingleNumber = data[index].F_DeviceQuality;

                                    rowData.F_ProjectNumber = projectnumber;

                                    rowData.F_ProjectName = projectname;

                                    rowData.F_ProjectQuantity = projectquantity;

                                    var postData = {

                                        strEntity: JSON.stringify(rowData)

                                    };

                                    console.log(postData);

                                    //$.lrSaveForm(top.$.rootUrl + '/LR_CodeDemo/YPAllProject/SaveFormDeviceWithModel?keyValue=' + keyValue, postData, function () {

                                    //    page.initData();

                                    //});

                                    learun.httpAsync('Post', top.$.rootUrl + '/LR_CodeDemo/YPAllProject/SaveFormDeviceWithModel?keyValue=' + keyValue, postData, function (data) {

                                        page.initData();

                                    });

                                    

                                }