C#sql语句规范

互联网 2021/10/13 19:17:30

using CodeReading.Entity; using CodeReading.Entity.Comm; using CodeReading.Entity.History; using System; using System.Collections.Generic; using System.Configuration; using System.Data.SqlClient; using System.Linq; using System.Text;namespace CodeRead…
using CodeReading.Entity;
using CodeReading.Entity.Comm;
using CodeReading.Entity.History;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Text;namespace CodeReading.View.DAL
{
    public class HistoryDAL
    {
        // 数据取得
        private static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionStrings"].ConnectionString;

    
        public SearchResult Search(SearchConditions searchConditions)
        {
            using (var conn = new SqlConnection(connectionString))
            using (var cmd = new SqlCommand())
            {
                cmd.Connection = conn;

                // SQL参数生成
                StringBuilder sql = new StringBuilder();
                // SELECT DbId,OtherID,Signed,TagCode,ScanDate,Pass,FileName FROM dbo.Used
                sql.AppendLine(" SELECT ");
                sql.AppendLine("    ,DbId");                                                             // 表单类型
                sql.AppendLine("    ,FileName");                                                         // 图片名
                sql.AppendLine("  FROM   ");
                sql.AppendLine("      dbo.Used ");                                                       // Used表
                sql.AppendLine("  Where   ");
                sql.AppendLine("       ScanDate >= @hsDtpFrom ");                  // 扫描开始时刻
                sql.AppendLine("   And ScanDate <= @hsDtpTo ");                    // 扫描结束时刻
                cmd.Parameters.Add("@hsDtpFrom", searchConditions.HsDtpFrom);         // 扫描开始时刻 赋值
                cmd.Parameters.Add("@hsDtpTo", searchConditions.HsDtpTo);             // 扫描结束时刻 赋值
                // "表单类型"有值时
                if (!string.IsNullOrEmpty(searchConditions.HsDbId))
                {
                    sql.AppendLine("   And  DbId = @hsDbId ");                      // 表单类型
                    cmd.Parameters.Add("@hsDbId", searchConditions.HsDbId);           // 表单类型 赋值
                }// 数据取得
                cmd.CommandText = sql.ToString();
                using (SqlDataAdapter reader = new SqlDataAdapter(cmd))
                {
                    var result = new SearchResult();
                    result.Suceeded = true;
                    var errorInfo = new ErrorInfo();
                    result.ErrorInfo = errorInfo;

                    var dt = new HistoryDataSet.SearchListDataTable();
                    reader.Fill(dt);
                    result.SearchData = dt;
                    reusing CodeReading.Entity;

             return result;
....

 

随时随地学软件编程-关注百度小程序和微信小程序
关于找一找教程网

本站文章仅代表作者观点,不代表本站立场,所有文章非营利性免费分享。
本站提供了软件编程、网站开发技术、服务器运维、人工智能等等IT技术文章,希望广大程序员努力学习,让我们用科技改变世界。
[C#sql语句规范]http://www.zyiz.net/tech/detail-240963.html

上一篇:C# generic "where constraint" with "any generic type" definition?

下一篇:C# linq left join 操作表和datatable

赞(0)
关注微信小程序
程序员编程王-随时随地学编程

扫描二维码或查找【程序员编程王】

可以随时随地学编程啦!

技术文章导航 更多>
扫一扫关注最新编程教程