public static DBOperator getDBOperator()
{
string strConnection = "Data Source=localhost;Initial Catalog=eformtest;User Id=sa;Password=;";
string type = "sqlclient";
return(DBOperatorFactory.GetDBOperator(strConnection, type));
}
/// <summary>
/// 功能： 返回字段最大值加1
/// </summary>
/// <param name="QueryString"></param>
/// <returns></returns>
public static int GetMaxID(string FieldName, string TableName)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = GetSingle(strsql);
if (obj == null)
{
return(1);
}
else
{
return(int.Parse(obj.ToString()));
}
#endregion
}
else
{
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
try
{
db.Open();
int exec = Convert.ToInt32(db.getTableId(TableName, FieldName)) + 1;
db.Close();
return(exec);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
}
}
public static string Load(HttpRequest Request, string sConn, string sFileName)
{
DBOperator oDb = null;
oDb = DBOperatorFactory.GetDBOperator(sConn);
return(Load(Request, oDb, sFileName));
}
private string DealUploadedZTBFile(string shortFileName, string fullFileName, Dictionary <string, string> customParams)
{
string masterID = customParams["MasterID"];
string fileName = shortFileName;
string fileType = Path.GetExtension(shortFileName);
byte[] fileContent = null;
using (FileStream fs = File.Open(fullFileName, FileMode.Open))
{
using (BinaryReader reader = new BinaryReader(fs))
{
fs.Seek(0L, SeekOrigin.Begin);
fileContent = reader.ReadBytes((int)fs.Length);
}
}
ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["SparkServiceDesk_SZZJFileManagerConnectionString"];
DBOperator db = DBOperatorFactory.GetDBOperator(connstr);
SqlParameterCollection spc = db.CreateSqlParameterCollection();
spc.Add("@masterID", masterID);
string bh = db.ExeSqlForString("select b.bh from gc_wd a inner join gc_jbqk b on a.工程注册号=b.工程注册号 where a.bh=@masterID", spc);
string sql = "insert into Dwgcfjb(bh,附件名称,附件流,可选择) values(@bh, @fileName, @fileContent,'{建设负责人}')";
spc.Add("@bh", bh);
spc.Add("@fileName", fileName);
spc.Add("@fileContent", fileContent);
db.ExecuteNonQuerySql(sql, spc);
sql = " select max(ID) from Dwgcfjb ";
return(db.ExeSqlForObject(sql, null).ToString());
}
/// <summary>
/// 开始进行初始化操作
/// </summary>
/// <returns></returns>
public bool Do_Initalize()
{
IDBOperate pHisDBOp = new DBOperatorFactory(m_sysConfig.HisDbConfig).GetDbOperate();
IDBOperate pOfficalDBOp = new DBOperatorFactory(m_sysConfig.OfficialDbConfig).GetDbOperate();
IDBOperate pTempDBOp = new DBOperatorFactory(m_sysConfig.TempDbConfig).GetDbOperate();
foreach (string key in m_dicTemplate.Keys)
{
IDBOperate pTemplateDBOp = new DBOperatorFactory(m_dicTemplate[key]).GetDbOperate();
}
return(false);
}
private string DealUploadedFile(string shortFileName, string fullFileName, Dictionary <string, string> customParams)
{
int systemID = customParams["SystemID"].ToInt32();
string moduleCode = customParams["ModuleCode"];
string categoryCode = customParams["CategoryCode"];
string masterID = customParams["MasterID"];
string fileName = shortFileName;
string fileType = Path.GetExtension(shortFileName);
byte[] fileContent = null;
using (FileStream fs = File.Open(fullFileName, FileMode.Open))
{
using (BinaryReader reader = new BinaryReader(fs))
{
fs.Seek(0L, SeekOrigin.Begin);
fileContent = reader.ReadBytes((int)fs.Length);
}
}
ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["SparkServiceDesk_FileManagerConnectionString"];
DBOperator db = DBOperatorFactory.GetDBOperator(connstr);
IFileManager fileManager = FileManagerFactory.CreateFileManager("DEFAULT");
fileManager.DB = db;
//add by qianbin
bool overWrite = false;
if (customParams.ContainsKey("OverWrite"))
{
overWrite = customParams["OverWrite"].ToBoolean(false);
}
if (overWrite)
{
List <SimpleFileModel> list = fileManager.GetSimpleFileModel(systemID, moduleCode, categoryCode, masterID);
foreach (SimpleFileModel innerSfm in list)
{
fileManager.DeleteFile(innerSfm.FileID);
}
}
//end add
SimpleFileModel sfm = fileManager.AddFile(systemID, moduleCode, categoryCode, masterID, fileName, fileType, fileContent, FileState.Saved);
return(sfm.FileID.ToString());
}
public DBOperator getDBOperator()
{
DBOperator @operator = null;
if (this.string_0 == ConfigFix.datasourceNameTemp)
{
@operator = GetDbConnection.getDBOperator();
}
if (@operator != null)
{
return(@operator);
}
if (this.xmlNode_0 == null)
{
throw new Exception("数据源配置信息没有找到!");
}
return(DBOperatorFactory.GetDBOperator(cn.com.fcsoft.util.Tools.getAttributeValue(this.xmlNode_0, "connStr"), cn.com.fcsoft.util.Tools.getAttributeValue(this.xmlNode_0, "type")));
}
private void buttonXOK_Click(object sender, EventArgs e)
{
switch (m_DBoType)
{
case DBOperatorType.EsriOperator:
dicDbconfig["server"] = txtEsriServer.Text;
dicDbconfig["serverice"] = txtService.Text;
dicDbconfig["database"] = txtEsriDb.Text;
dicDbconfig["user"] = txtEsriUser.Text;
dicDbconfig["password"] = txtEsriPassword.Text;
break;
case DBOperatorType.ODBC:
dicDbconfig["server"] = txtODBCServer.Text;
dicDbconfig["database"] = txtODBCDb.Text;
dicDbconfig["user"] = txtODBCUser.Text;
dicDbconfig["password"] = txtODBCPassword.Text;
dicDbconfig["serverport"] = txtODBCPort.Text;
break;
}
m_dbConfig.SetConfig(m_DBoType, m_dbType, dicDbconfig);
DBOperatorFactory pFac = new DBOperatorFactory(m_dbConfig);
m_DbOp = pFac.GetDbOperate();
if (m_DbOp != null)
{
if (!m_DbOp.TestConnect())
{
MessageBox.Show("无法连接数据库，请检查设置！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
m_dbConfig.SaveConfig(Fan.Common.ModuleConfig.m_ConnectFileName);
this.DialogResult = DialogResult.OK;
}
}
else
{
MessageBox.Show("无法连接数据库，请检查设置！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SqlString)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
SqlConnection conn = new SqlConnection(ConStr);
SqlCommand cmd = new SqlCommand(SqlString, conn);
cmd.CommandTimeout = 0;
try
{
conn.Open();
int rows = cmd.ExecuteNonQuery();
conn.Close();
return(rows);
}
catch (SqlException ex)
{
conn.Close();
throw new Exception(ex.Message);
}
#endregion
}
else
{
#region access
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
try
{
db.Open();
bool exec = db.exeSql(SqlString);
db.Close();
return(exec ? 1 : 0);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
#endregion
}
}
///// <summary>
///// 执行带一个存储过程参数的的SQL语句。
///// </summary>
///// <param name="SQLString">SQL语句</param>
///// <param name="content">参数内容,比如一个字段是格式复杂的文章，有特殊符号，可以通过这个方式添加</param>
///// <returns>影响的记录数</returns>
//public static int ExecuteSql(string SqlString, string content)
//{
// //SqlConnection conn = new SqlConnection(ConStr);
// //SqlCommand cmd = new SqlCommand(SqlString, conn);
// //SqlParameter myParameter = new SqlParameter("@content", SqlDbType.NText);
// //myParameter.Value = content;
// //cmd.Parameters.Add(myParameter);
// //try
// //{
// // conn.Open();
// // int rows = cmd.ExecuteNonQuery();
// // return rows;
// //}
// //catch (SqlException ex)
// //{
// // throw new Exception(ex.Message);
// //}
// //finally
// //{
// // cmd.Dispose();
// // conn.Close();
// //}
// return -1;
//}
///// <summary>
///// 执行带一个存储过程参数的的SQL语句。
///// </summary>
///// <param name="SQLString">SQL语句</param>
///// <param name="content">参数内容,比如一个字段是格式复杂的文章，有特殊符号，可以通过这个方式添加</param>
///// <returns>影响的记录数</returns>
//public static object ExecuteSqlGet(string SQLString, string content)
//{
// //using (SqlConnection connection = new SqlConnection(ConStr))
// //{
// // SqlCommand cmd = new SqlCommand(SQLString, connection);
// // System.Data.SqlClient.SqlParameter myParameter = new System.Data.SqlClient.SqlParameter("@content", SqlDbType.NText);
// // myParameter.Value = content;
// // cmd.Parameters.Add(myParameter);
// // try
// // {
// // connection.Open();
// // object obj = cmd.ExecuteScalar();
// // if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
// // {
// // return null;
// // }
// // else
// // {
// // return obj;
// // }
// // }
// // catch (SqlException E)
// // {
// // throw new Exception(E.Message);
// // }
// // finally
// // {
// // cmd.Dispose();
// // connection.Close();
// // }
// //}
// return null;
//}
#endregion
/// <summary>
/// 执行查询语句，返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SqlString)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
SqlConnection conn = new SqlConnection(ConStr);
DataSet ds = new DataSet();
try
{
conn.Open();
SqlDataAdapter command = new SqlDataAdapter(SqlString, conn);
command.Fill(ds, "ds");
conn.Close();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
return(ds);
#endregion
}
else
{
#region access
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
try
{
db.Open();
DataSet exec = db.exeSqlForDataSet(SqlString);
db.Close();
return(exec);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
#endregion
}
}
public static void Log(string systemName, string moduleName, string fileName, string messageInfo)
{
ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["SparkServiceDesk_LogManagerConnectionString"];
DBOperator db = DBOperatorFactory.GetDBOperator(connstr);
ILogManager logManager = LogManagerFactory.CreateLogManager("DEFAULT");
logManager.DB = db;
BusinessLog bizLog = new BusinessLog();
bizLog.SystemName = systemName;
bizLog.ModuleName = moduleName;
bizLog.CategoryName = "上传文件";
bizLog.KeyString = fileName;
bizLog.Operation = "上传文件";
bizLog.PriorStatus = "操作前";
bizLog.PostStatus = "操作后";
bizLog.MessageInfo = messageInfo;
bizLog.OperatorID = "-1";
bizLog.OperatorName = "无名氏";
logManager.AppendLog(bizLog);
}
//public static DataSet Query(string SqlString, string TableName)
//{
// //SqlConnection conn = new SqlConnection(ConStr);
// //DataSet ds = new DataSet();
// //try
// //{
// // conn.Open();
// // SqlDataAdapter command = new SqlDataAdapter(SqlString, conn);
// // command.Fill(ds, TableName);
// // conn.Close();
// //}
// //catch (SqlException ex)
// //{
// // throw new Exception(ex.Message);
// //}
// //return ds;
// DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
// try
// {
// db.Open();
// DataSet exec = db.exeSqlForDataSet(SqlString);
// db.Close();
// return exec;
// }
// catch (System.Data.SqlClient.SqlException e)
// {
// db.Close();
// throw new Exception(e.Message);
// }
//}
#endregion
/// <summary>
/// 执行一条计算查询结果语句，返回查询结果（object）。
/// </summary>
/// <param name="SQLString">计算查询结果语句</param>
/// <returns>查询结果（object）</returns>
public static object GetSingle(string SqlString)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
SqlConnection conn = new SqlConnection(ConStr);
SqlCommand cmd = new SqlCommand(SqlString, conn);
try
{
conn.Open();
object obj = cmd.ExecuteScalar();
conn.Close();
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return(null);
}
else
{
return(obj);
}
}
catch (System.Data.SqlClient.SqlException e)
{
conn.Close();
throw new Exception(e.Message);
}
#endregion
}
else
{
#region access
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
if (SqlString.IndexOf(';') == -1)
{
try
{
db.Open();
object str = db.exeSqlForObject(SqlString);
db.Close();
return(str);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
}
//新增档案专用方法(不适合其他地方使用)
else
{
string[] sqls = SqlString.Split(';');
try
{
db.Open();
bool exec = db.exeSql(sqls[0]);//添加信息
object str = null;
if (exec)
{
str = db.exeSqlForObject(sqls[1]);//返回标识列ID
}
db.Close();
return(str);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
}
#endregion
}
}
public DataExchangeBLLForYHT()
{
//this.DAL.DB = new Wxjzgcjczy.DAL.Sqlserver.DatabaseOperatorYHT();
this.DAL.DB = DBOperatorFactory.GetDBOperator("data source=192.168.153.189;Initial Catalog=db_adminexam;user id=sa;password=wxjsj^201701;", "SQLSERVER2008");
}
public static DBOperator GetUserRightDBOperator()
{
return(DBOperatorFactory.GetDBOperator(ConfigManager.GetConnectionString(), ConfigManager.GetDatabaseType().ToUpper()));
}
/// <summary>
/// 连接TCSCIC60
/// </summary>
/// <returns></returns>
public static DBOperator TCSCIC60ForDBOperator()
{
return(DBOperatorFactory.GetDBOperator(TCSCIC60BConnectionString));
}
private string DealUploadedXmwj(string shortFileName, string fullFileName, Dictionary <string, string> customParams)
{
int systemID = customParams["SystemID"].ToInt32();
string moduleCode = customParams["ModuleCode"];
string categoryCode = customParams["CategoryCode"];
string masterID = customParams["MasterID"];
string fileName = shortFileName;
string fileType = Path.GetExtension(shortFileName);
//byte[] fileContent = null;
//using (FileStream fs = File.Open(fullFileName, FileMode.Open))
//{
// using (BinaryReader reader = new BinaryReader(fs))
// {
// fs.Seek(0L, SeekOrigin.Begin);
// fileContent = reader.ReadBytes((int)fs.Length);
// }
//}
ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["SparkServiceDesk_XmwjDBConnectionString"];
DBOperator db = DBOperatorFactory.GetDBOperator(connstr);
//如果是立项项目
if (categoryCode == "10000020" || categoryCode == "10000030" || categoryCode == "10000040")
{
string sql = string.Empty;
SqlParameterCollection spc = db.CreateSqlParameterCollection();
spc.Add("@masterID", masterID);
sql = @"select a.Active_ID from bid_lxdj as a
inner join bid_bagl as b on a.Project_ID=b.Project_ID
inner join tyxmk as c on b.Active_ID=c.zbbaID
where c.xmid=@masterID ";
string xmID = db.ExeSqlForString(sql, spc);
string sql1 = "select count(1) from bid_filesCatalog where xmid=@xmid and fjcode=@categoryCode and status=0";
spc.Add("@xmid", xmID);
spc.Add("@categoryCode", categoryCode);
int CountByXmID = db.ExeSqlForObject(sql1, spc).ToInt32();
fullFileName = fullFileName.Substring(2);
spc.Add("@shortFileName", shortFileName);
spc.Add("@fullFileName", fullFileName);
if (CountByXmID == 0)
{
string guid = Guid.NewGuid().ToString();
spc.Add("@guid", guid);
spc.Add("@createTime", DateTime.Now.ToDate2());
sql = @"insert into bid_filesCatalog (xmid,xmtype,fjguid,fjcode,createTime,status) values (@xmID,'立项项目',@guid, @categoryCode, @createTime, 0)";
db.ExecuteNonQuerySql(sql, spc);
string sql2 = "insert into public_fjk (fjGuid,fjname,fjurl,fjl,fjbz) values (@guid, @shortFileName, @fullFileName,'','施工许可系统')";
return(db.ExecuteNonQuerySql(sql2, spc).ToString2());
}
else
{
string sqlForGuid = "select distinct fjguid from bid_filesCatalog where xmid=@xmID and @categoryCode and status=0";
string guid = db.ExeSqlForString(sqlForGuid, spc).ToString2();
spc.Add("@guid", guid);
string sql2 = "insert into public_fjk (fjGuid,fjname,fjurl,fjl,fjbz) values (@guid, @shortFileName, @fullFileName,'','施工许可系统')";
return(db.ExecuteNonQuerySql(sql2, null).ToString2());
}
}
//是标段项目
else
{
string sql = string.Empty;
SqlParameterCollection spc = db.CreateSqlParameterCollection();
spc.Add("@masterID", masterID);
sql = @"select (a.Project_ID+'_'+a.bdxh) as bdguid from Bid_ItemAndBdRelation as a
inner join Bid_bagl as b on a.Active_ID=b.Active_ID and a.ModuleCode='ZBBA'
inner join tyxmk as c on b.Active_ID=c.ZbbaID
where c.xmid=@masterID";
string xmID = db.ExeSqlForString(sql, spc);
string sql1 = "select count(1) from bid_filesCatalog where xmid=@xmid and fjcode=@categoryCode and status=0";
spc.Add("@xmid", xmID);
spc.Add("@categoryCode", categoryCode);
int CountByXmID = db.ExeSqlForObject(sql1, spc).ToInt32();
fullFileName = fullFileName.Substring(2);
spc.Add("@shortFileName", shortFileName);
spc.Add("@fullFileName", fullFileName);
if (CountByXmID == 0)
{
string guid = Guid.NewGuid().ToString();
spc.Add("@guid", guid);
spc.Add("@createTime", DateTime.Now.ToDate2());
sql = @"insert into bid_filesCatalog (xmid,xmtype,fjguid,fjcode,createTime,status) values (@xmID,'标段项目',@guid,@categoryCode, @createTime,0)";
db.ExecuteNonQuerySql(sql, spc);
string sql2 = "insert into public_fjk (fjGuid,fjname,fjurl,fjl,fjbz) values (@guid, @shortFileName, @fullFileName,'','施工许可系统')";
return(db.ExecuteNonQuerySql(sql2, spc).ToString2());
}
else
{
string sqlForGuid = "select distinct fjguid from bid_filesCatalog where xmid=@xmID and fjcode=@categoryCode and status=0";
string guid = db.ExeSqlForString(sqlForGuid, null).ToString2();
spc.Add("@guid", guid);
string sql2 = "insert into public_fjk (fjGuid,fjname,fjurl,fjl,fjbz) values (@guid, @shortFileName,@fullFileName,'','施工许可系统')";
return(db.ExecuteNonQuerySql(sql2, spc).ToString2());
}
}
}
///// <summary>
///// 执行查询语句，返回SqlDataReader (使用该方法切记要手工关闭SqlDataReader和连接)
///// </summary>
///// <param name="strSQL">查询语句</param>
///// <returns>SqlDataReader</returns>
//public static SqlDataReader ExecuteReader(string SQLString, params SqlParameter[] cmdParms)
//{
// SqlConnection conn = new SqlConnection(ConStr);
// SqlCommand cmd = new SqlCommand();
// try
// {
// PrepareCommand(cmd, conn, null, SQLString, cmdParms);
// SqlDataReader myReader = cmd.ExecuteReader();
// cmd.Parameters.Clear();
// return myReader;
// }
// catch (SqlException e)
// {
// throw new Exception(e.Message);
// }
// //finally //不能在此关闭，否则，返回的对象将无法使用
// //{
// // cmd.Dispose();
// // connection.Close();
// //}
//}
#endregion
/// <summary>
/// 执行查询语句，返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public static DataSet Query(string SQLString, params SqlParameter[] cmdParms)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
SqlConnection conn = new SqlConnection(ConStr);
conn.Open();
SqlCommand cmd = new SqlCommand();
PrepareCommand(cmd, conn, null, SQLString, cmdParms);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
try
{
da.Fill(ds, "ds");
cmd.Parameters.Clear();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
conn.Close();
return(ds);
}
#endregion
}
else
{
#region access
//string[] strParams;
//object[] objValues;
//PrepareParams(cmdParms, out strParams, out objValues);
//DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
//try
//{
// db.Open();
// DataSet ds = db.exeSqlForDataSet(SQLString, strParams, objValues);
// db.Close();
// return ds;
//}
//catch (System.Data.SqlClient.SqlException e)
//{
// db.Close();
// throw new Exception(e.Message);
//}
DBParameter[] Params = PrepareParams(cmdParms);
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
try
{
db.Open();
DataSet ds = db.exeSqlForDataSet(SQLString, Params);
db.Close();
return(ds);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
#endregion
}
}
///// <summary>
///// 执行多条SQL语句，实现数据库事务。
///// </summary>
///// <param name="SQLStringList">SQL语句的哈希表（key为sql语句，value是该语句的SqlParameter[]）</param>
//public static void ExecuteSqlTran(Hashtable SQLStringList)
//{
// using (SqlConnection conn = new SqlConnection(ConStr))
// {
// conn.Open();
// SqlTransaction trans = conn.BeginTransaction();
// SqlCommand cmd = new SqlCommand();
// try
// {
// //循环
// foreach (DictionaryEntry myDE in SQLStringList)
// {
// string cmdText = myDE.Key.ToString();
// SqlParameter[] cmdParms = (SqlParameter[])myDE.Value;
// PrepareCommand(cmd, conn, trans, cmdText, cmdParms);
// int val = cmd.ExecuteNonQuery();
// cmd.Parameters.Clear();
// trans.Commit();
// }
// conn.Close();
// }
// catch(SqlException ex)
// {
// trans.Rollback();
// throw new Exception(ex.Message);
// }
// }
//}
#endregion
/// <summary>
/// 执行一条计算查询结果语句，返回查询结果（object）。
/// </summary>
/// <param name="SQLString">计算查询结果语句</param>
/// <returns>查询结果（object）</returns>
public static object GetSingle(string SQLString, params SqlParameter[] cmdParms)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
SqlConnection conn = new SqlConnection(ConStr);
conn.Open();
SqlCommand cmd = new SqlCommand();
try
{
PrepareCommand(cmd, conn, null, SQLString, cmdParms);
object obj = cmd.ExecuteScalar();
cmd.Parameters.Clear();
conn.Close();
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return(null);
}
else
{
return(obj);
}
}
catch (SqlException e)
{
conn.Close();
throw new Exception(e.Message);
}
#endregion
}
else
{
#region access
//string[] strParams;
//object[] objValues;
//PrepareParams(cmdParms, out strParams, out objValues);
//DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
//if (SQLString.IndexOf(';') == -1)
//{
// try
// {
// db.Open();
// string str = db.exeSqlForString(SQLString, strParams, objValues);
// db.Close();
// if (str == string.Empty)
// {
// return null;
// }
// return str;
// }
// catch (System.Data.SqlClient.SqlException e)
// {
// db.Close();
// throw new Exception(e.Message);
// }
//}
////新增档案专用方法(不适合其他地方使用)
//else
//{
// string[] sqls = SQLString.Split(';');
// try
// {
// db.Open();
// bool exec = db.exeSql(sqls[0], strParams, objValues);//添加信息
// string str = string.Empty;
// if (exec)
// {
// str = db.exeSqlForString(sqls[1]);//返回标识列ID
// }
// db.Close();
// if (str == string.Empty)
// {
// return null;
// }
// return str;
// }
// catch (System.Data.SqlClient.SqlException e)
// {
// db.Close();
// throw new Exception(e.Message);
// }
//}
DBParameter[] Params = PrepareParams(cmdParms);
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
if (SQLString.IndexOf(';') == -1)
{
try
{
db.Open();
string str = db.exeSqlForString(SQLString, Params);
db.Close();
if (str == string.Empty)
{
return(null);
}
return(str);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
}
//新增档案专用方法(不适合其他地方使用)
else
{
string[] sqls = SQLString.Split(';');
try
{
db.Open();
bool exec = db.exeSql(sqls[0], Params);//添加信息
string str = string.Empty;
if (exec)
{
str = db.exeSqlForString(sqls[1]);//返回标识列ID
}
db.Close();
if (str == string.Empty)
{
return(null);
}
return(str);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
}
#endregion
}
}
/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString, params SqlParameter[] cmdParms)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
SqlConnection conn = new SqlConnection(ConStr);
conn.Open();
SqlCommand cmd = new SqlCommand();
try
{
PrepareCommand(cmd, conn, null, SQLString, cmdParms);
int rows = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
conn.Close();
return(rows);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
#endregion
}
else
{
#region access
//string[] strParams;
//object[] objValues;
//PrepareParams(cmdParms, out strParams, out objValues);
//DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
//try
//{
// db.Open();
// bool exec = db.exeSql(SQLString, strParams, objValues);
// db.Close();
// return exec ? 1 : 0;
//}
//catch (System.Data.SqlClient.SqlException e)
//{
// db.Close();
// throw new Exception(e.Message);
//}
DBParameter[] Params = PrepareParams(cmdParms);
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
try
{
db.Open();
bool exec = db.exeSql(SQLString, Params);
db.Close();
return(exec ? 1 : 0);
}
catch (System.Data.SqlClient.SqlException e)
{
db.Close();
throw new Exception(e.Message);
}
#endregion
}
}
/// <summary>
/// 连接SCIC60
/// </summary>
/// <returns></returns>
public static DBOperator SCIC82ForDBOperator()
{
return(DBOperatorFactory.GetDBOperator(SCIC82BConnectionString));
}
/// <summary>
/// 执行多条SQL语句，实现数据库事务。
/// </summary>
/// <param name="SQLStringList">多条SQL语句</param>
public static void ExecuteSqlTran(ArrayList SqlStringList)
{
if (ConnectType == DBConnectType.SqlServer)
{
#region sql
SqlConnection conn = new SqlConnection(ConStr);
conn.Open();
SqlCommand cmd = new SqlCommand();
SqlTransaction tx = conn.BeginTransaction();
cmd.Transaction = tx;
cmd.Connection = conn;
try
{
for (int n = 0; n < SqlStringList.Count; n++)
{
string strsql = SqlStringList[n].ToString();
if (strsql.Trim().Length > 1)
{
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
}
}
tx.Commit();
}
catch (SqlException ex)
{
tx.Rollback();
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
#endregion
}
else
{
#region access
DBOperator db = DBOperatorFactory.GetDBOperator(ConStr, ConnectType);
try
{
db.Open();
db.BeginTrans();
for (int n = 0; n < SqlStringList.Count; n++)
{
string strsql = SqlStringList[n].ToString();
if (strsql.Trim().Length > 1)
{
db.exeSql(strsql);
}
}
db.CommitTrans();
db.Close();
}
catch (System.Data.SqlClient.SqlException e)
{
db.RollbackTrans();
}
finally
{
db.Close();
}
#endregion
}
}
/// <summary>
/// 获得 WJSJZX 数据库操作者
/// </summary>
/// <returns></returns>
public static DBOperator GetDB_WJSJZX()
{
return(DBOperatorFactory.GetDBOperator(ConnectionString_WJSJZX, DataBaseType.SQLSERVER2008.ToString()));
}
private string DealUploadedZTBFile(string shortFileName, string fullFileName, Dictionary <string, string> customParams)
{
int systemID = customParams["SystemID"].ToInt32();
string moduleCode = customParams["ModuleCode"];
string categoryCode = customParams["CategoryCode"];
string masterID = customParams["MasterID"];
string fileName = shortFileName;
string fileType = Path.GetExtension(shortFileName);
byte[] fileContent = null;
using (FileStream fs = File.Open(fullFileName, FileMode.Open))
{
using (BinaryReader reader = new BinaryReader(fs))
{
fs.Seek(0L, SeekOrigin.Begin);
fileContent = reader.ReadBytes((int)fs.Length);
}
}
ConnectionStringSettings connstr = ConfigurationManager.ConnectionStrings["SparkServiceDesk_ZTBFileManagerConnectionString"];
DBOperator db = DBOperatorFactory.GetDBOperator(connstr);
//IFileManager fileManager = FileManagerFactory.CreateFileManager("DEFAULT");
//fileManager.DB = db;
//SimpleFileModel sfm = fileManager.AddFile(systemID, moduleCode, categoryCode, masterID, fileName, fileType, fileContent, FileState.Saved);
int sccs = 0;
string sql = "";
SqlParameterCollection spc = db.CreateSqlParameterCollection();
spc.Add("@fileContent", fileContent);
spc.Add("@masterID", masterID);
spc.Add("@fileName", fileName);
spc.Add("@scsj", DateTime.Now.ToString());
if (categoryCode == "招标文件")
{
//如果已上传，Update
string guid = Guid.NewGuid().ToString();
string querrysql = " select COUNT(*) from bid_Zbwj where sccs=0 and xmbdID=@masterID";
sccs = db.ExeSqlForObject(querrysql, spc).ToInt32();
if (sccs > 0)
{
sql = " update Bid_Zbwj set fjName =@fileName, scsj=@scsj ,fjl=@fileContent where sccs=0 and xmbdID=@masterID";
}
else
{
spc.Add("@guid", guid);
spc.Add("@sccs", sccs);
sql = "insert into Bid_Zbwj(fjGuid, xmbdID, sccs, fjName, scsj, fjl) values(@guid, @masterID, @sccs, @fileName ,@scsj,@fileContent)";
}
}
else if (categoryCode == "资格审查文件")
{
//如果已上传，Update
string guid = Guid.NewGuid().ToString();
string querrysql = " select COUNT(*) from bid_Zswj where sccs=0 and xmbdID=@masterID";
sccs = db.ExeSqlForObject(querrysql, spc).ToInt32();
if (sccs > 0)
{
sql = " update Bid_Zswj set fjName =@fileName, scsj=@scsj, fjl=@fileContent where sccs=0 and xmbdID=@masterID";
}
else
{
spc.Add("@guid", guid);
spc.Add("@sccs", sccs);
sql = "insert into Bid_Zswj(fjGuid, xmbdID, sccs, fjName, scsj, fjl) values(@guid, @masterID, @sccs, @fileName, @scsj, @fileContent)";
}
}
else if (categoryCode == "预审答疑文件")
{
//如果已上传，Update
string guid = Guid.NewGuid().ToString();
string dycs = customParams["Dycs"].ToString();
spc.Add("@dycs", dycs);
string querrysql = " select COUNT(*) from bid_Zswj where sccs<>0 and xmbdID=@masterID and sccs=@dycs";
sccs = db.ExeSqlForObject(querrysql, spc).ToInt32();
if (sccs > 0)
{
sql = " update Bid_Zswj set fjName =@fileName, scsj=@scsj, fjl=@fileContent where xmbdID=@masterID and sccs=@dycs ";
}
else
{
spc.Add("@guid", guid);
sql = "insert into Bid_Zswj(fjGuid, xmbdID, sccs, fjName, scsj, fjl) values(@guid, @masterID, @dycs, @fileName, @scsj, @fileContent)";
}
}
else if (categoryCode == "招标附属文件")
{
string dycs = customParams["Dycs"].ToString();
string guid = Guid.NewGuid().ToString();
spc.Add("@dycs", dycs);
string querrysql = " select COUNT(*) from bid_Zbwj where xmbdID=@masterID and sccs=@dycs ";
sccs = db.ExeSqlForObject(querrysql, spc).ToInt32();
if (sccs > 0)
{
sql = " update Bid_Zbwj set fjName_fs = @fileName , scsj_fs=@scsj, fjl_fs=@fileContent where xmbdID=@masterID and sccs=@dycs";
}
else
{
spc.Add("@guid", guid);
sql = "insert into Bid_Zbwj(fjGuid, xmbdID, sccs,fjName_fs, scsj_fs, fjl_fs) values(@guid, @masterID, @dycs, @fileName, @scsj, @fileContent)";
}
}
else if (categoryCode == "答疑文件")
{
string dycs = customParams["Dycs"].ToString();
string guid = Guid.NewGuid().ToString();
spc.Add("@dycs", dycs);
string querrysql = " select COUNT(*) from bid_Zbwj where sccs<>0 and xmbdID=@masterID and sccs=@dycs";
sccs = db.ExeSqlForObject(querrysql, spc).ToInt32();
if (sccs > 0)
{
sql = " update Bid_Zbwj set fjName =@fileName, scsj=@scsj, fjl=@fileContent where xmbdID=@masterID and sccs=@dycs";
}
else
{
spc.Add("@guid", guid);
sql = "insert into Bid_Zbwj(fjGuid, xmbdID, sccs, fjName, scsj, fjl) values(@guid, @masterID, @dycs, @fileName, @scsj, @fileContent)";
}
}
else if (categoryCode == "标底计价文件")
{
//如果已上传，Update
string guid = Guid.NewGuid().ToString();
string querrysql = " select COUNT(*) from bid_bdjjwj where xmbdID=@masterID";
sccs = db.ExeSqlForObject(querrysql, spc).ToInt32();
if (sccs > 0)
{
sql = " update bid_bdjjwj set fjName =@fileName, scsj=@scsj ,fjl=@fileContent where xmbdID=@masterID";
}
else
{
spc.Add("@guid", guid);
sql = "insert into bid_bdjjwj(fjGuid, xmbdID, fjName, scsj, fjl) values(@guid, @masterID, @fileName, @scsj, @fileContent)";
}
}
db.ExecuteNonQuerySql(sql, spc);
sql = " select max(ID) from bid_Zbwj ";
return(db.ExeSqlForObject(sql, null).ToString());
}
