pramezh

摘要： select substring(convert(nvarchar(8),getdate(),112),1,6)+right(100+isnull(substring(convert(nvarchar(8),max([No])),7,2),0)+1,2) from Bulletin where substring(convert(nvarchar(8),[No]),1,6)=substring(convert(nvarchar(8),getdate(),112),1,6)//當前年月的流水號select substring(convert(nvarchar(8),getdate(),112), 阅读全文

摘要： <connectionStrings><add name="DBConnectionString" connectionString="Server=服務器;database=數據庫名;uid=用戶名;pwd=密碼;" providerName="System.Data.SqlClient"/></connectionStrings> 阅读全文

摘要： using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Configuration;using System.Data;using System.Data.SqlClient;using System.Collections;/// <summary> /// SQLHelper 的摘要描述 /// </summary>public class SQLHelper{ private static readonly string Conne 阅读全文