DBUtility/DbHelperSQL.cs

（开头部分） 44KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.Common;
using System.Collections.Generic;
namespace Tsr.DBUtility
{
    public abstract class DbHelperSQL
    {
        //数据库连接字符串(web.config来配置)，可以动态更改connectionString支持多数据库.		
        public static string connectionString = PubConstant.ConnectionString;
        public DbHelperSQL()
        {
        }

        #region 公用方法
        public static string Getdjbh(string s_Table,string s_djName,string s_UserID)
        {
            DateTime curdate;
            string curYear;
            string curMonthx;
            string curMonth;
            int i_xhhh;
            string s_return;
            string s_Coding;
            //string s_MaxID;
            //int i_MaxID;
            SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();
            curdate =Convert.ToDateTime(new SqlCommand("select getdate()", conn).ExecuteScalar().ToString());
            curYear = curdate.Year.ToString();
            curMonthx = curdate.Month.ToString();
            if (curMonthx.Length == 1)
            {
                curMonth = "0" + curMonthx;
            }
            else
            {
                curMonth = curMonthx;
            }
            string s_sql="Select max(substring(djbh, 17, 4)) From " + s_Table + " Where substring(djbh, 1, 3)='"+ s_djName +"' And SubString(djbh,5,4)='"+ curYear+"' And substring(djbh, 10, 2)='"+ curMonth +"' And SubString(djbh,13,3)='"+ s_UserID+"'";
            s_return = new SqlCommand(s_sql, conn).ExecuteScalar().ToString();
            if (s_return == null || s_return.Length == 0)
            {
                s_return = "1";
            }
            else
            {
                i_xhhh = Convert.ToInt32(s_return)+1;
                s_return = i_xhhh.ToString();
            }
            s_Coding =GenFormat(s_return, 4, "0");
            string s_djbh= s_djName + "-" + curYear + "-" + curMonth + "-" + s_UserID + "-" + s_Coding;
            return s_djbh;
            //s_djName + "-" + curYear+"-"+ curMonth+"-"+ s_UserID +// CType((IIf(IsDBNull(MyCommand.ExecuteScalar), 0, MySqlCmd.ExecuteScalar) + 1));
        }
        /// <summary>
后面还有 1083 行代码，解锁后查看完整代码

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。