常用

常用代码

代码

JavaScript

Jq.Ajax请求

  $.ajaxjson(actionUrl + "?action=Delete", "moduleId=" + row.Id, function (obj) {
        if (obj.Success) {
            msg.ok("删除成功！");
            grid.reload();
        } else {
            msg.error(obj.Message);
        }
    });

UTF-8 转码

HttpUtility.UrlEncode(frameName, System.Text.Encoding.UTF8)  

浏览器乱码

使用 escape(value) 方法

INPUT 只能输入汉字

onkeyup="value=value.replace(/[^\d]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))" 

通过ajax 直接调用返回参数

$.ajax({ url: actionUrl + "?Action=RemarkNum", timeout: 3000, cache: false, async: false }).responseText;

上传Excel

function UploadExcel() {
    $.ajaxFileUpload({
        url: actionUrl+"?Action=Upload",//服务器端程序
        secureuri: false,
        fileElementId: 'uploadFile',//input框的ID
        dataType: 'json',//返回数据类型
        success: function (data,statu) {//上传成功
            if (data.Success == true) {
                alert("更新成功"+data.Message);
            } else {
                alert("更新失败",data.Message);
            }
        }
    });

51通知回复模块调用方法

//页面需要引入下方资源
 <link href="/Reply/css/replycss.css" rel="stylesheet" />
 <script type="text/javascript" src="/Reply/js/lodingreply.js"></script>
//html文件需要嵌入下方div
 <div id="replyContent" style="   border: solid 1px #95B8E7;"></div>
 <div id="yc">
        <input id="ReplyId" type="hidden" />
        <input type="hidden" id="ModuleName" />
        <input type="hidden" id="ForeignerId" />
    </div>
//js 需要加入以下代码
    $("#ForeignerId").val(worksPointId);
    $("#ModuleName").val("Design");
    moduleReply(1);

Sql

游标

DECLARE name CURSOR FOR  
select 语句
OPEN name 
fetch next from name into  @Paras
while @@fetch_status<>-1
begin
--xxx 这里输入循环体语句
fetch next from name  into  @Paras
end 
close name 
deallocate name 

比较时间

DATEDIFF(day,'2014-10-10',createtime)<=0

CSharp

JsonMessage Try代码段

  var msg = new JsonMessage() {Success = true};
    try
    {
    }
    catch (DbEntityValidationException dex)
    {
        msg.Message = dex.Message;
        msg.Success = false;
        foreach (var error in dex.EntityValidationErrors)
        {
            msg.Message = string.Format("{0}\r\n:{1}", msg.Message, string.Join(";", error.ValidationErrors.Select(v => v.ErrorMessage)));
        }
    }
    catch (Exception ex)
    {
        msg.Success = false;
        var sbMsg = new StringBuilder(ex.Message);
        while (ex.InnerException != null)
        {
            sbMsg.AppendFormat(">>{0}", ex.InnerException.Message);
            ex = ex.InnerException;
        }
        msg.Message = sbMsg.ToString();
    }
    return msg;

判断排序字段是否为空

 if (string.IsNullOrEmpty(pg.Order?.OrderFields))
 {
    pg.Order = new Pagination.OrderBy()
    {
        OrderFields = "CreateTime",
        OrderType = Pagination.EOrderType.DESC
    };
 }

解决映射冲突

AutoMapper.Mapper.DynamicMap

获取配置文件

 System.Configuration.ConfigurationManager.AppSettings

获取数据库刚插入的ID

DbHelperSQL.GetSingleToString("SELECT IDENT_CURRENT('Report_TableName')");

LINQ 去除缓存

.AsNoTracking() //该字段为了去缓存

附件批量上传

   for (int i = 0; i < context.Request.Files.Count; i++)
                {
                    HttpPostedFile aFile = context.Request.Files[i];
                    if (aFile.ContentLength == 0 || String.IsNullOrEmpty(aFile.FileName))
                        continue;
                    string uploadPath = "";
                    fileName = aFile.FileName;
                    string realFileName = "";
                    //上传图片
                    {
                        uploadPath = Const.getConstructionDataUploadPath(timePath);
                        realFileName = uploadPath + fileName;
                        aFile.SaveAs(realFileName);
                        //Warterfontmark.AddTextWatermark(realFileName, realFileName, markStr);
                    }
                }

规范

系统规定

搜索条件标志

case "eq": return " 等于 ";
case "gt": return " 大于 ";
case "ge": return " 大于等于 ";
case "nu": return " 为空 ";
case "nn": return " 不为空 ";
case "lt": return " 小于 ";
case "le": return " 小于等于 ";
case "cn": return " 包含 ";
case "ncn": return " 不包含 ";
case "bw": return " 包含 ";
case "ew": return " 包含 ";
case "ne": return " 不等于 ";
case "in": return " 包含于 ";
case "ni": return " 不包含于 ";
default: return " 等于 ";

其他规定

系统主色

#3CB9F8