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()); }