protected int Insert(BaseTable nesne, DbCommand dbComm, DbTransaction dbTransaction, Database db) { //YetkiKullanici ui = (YetkiKullanici)HttpContext.Current.Session["YetkiKullanici"]; //if (ui == null) //{ // ui = new YetkiKullanici(); // ui.Tckimlikno = "Everyone"; // ui.Ip = HttpContext.Current.Request.UserHostAddress; //} int sonuc = 0; string geriDeger = ""; if (dbTransaction == null) geriDeger = db.ExecuteScalar(dbComm).ToString(); else geriDeger = db.ExecuteScalar(dbComm, dbTransaction).ToString(); //if (ConfigurationSettings.AppSettings.Get("DBLOG_AKTIF") != null && // ConfigurationSettings.AppSettings.Get("DBLOG_AKTIF") == "E") //{ // try // { // int.TryParse(geriDeger, out sonuc); // GenDbLog log = new GenDbLog(); // log.Tckimlikno = ui.Tckimlikno; // log.KullaniciIp = ui.Ip; // log.Tablo = nesne.GetName(); // log.KayitId = sonuc; // log.Kayit = nesne.ToString(); // log.Tarih = DateTime.Now; // log.YapilanIslem = "I"; // InsertLog(log, dbTransaction, db); // } // catch (Exception ex) { } //} bool snc = int.TryParse(geriDeger, out sonuc); return sonuc; }
/// <summary> /// Takes a command object and returns the first column of the first row /// </summary> /// <param name="sqlCommand">SQLCommand</param> /// <returns>SqlDataReader</returns> public int ExecuteScalar(SqlCommand command) { if (command == null) { throw new ArgumentNullException("command"); } int timeout = CommandTimeOut; if (timeout > 0) { command.CommandTimeout = timeout; } //Microsoft.Practices.EnterpriseLibrary.Data.Database db = GetDatabase(); return(Convert.ToInt32(db.ExecuteScalar((DbCommand)command))); }
public static int Insert(Database db, Track oTrack) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [Track]("); sbValue.Append("values ("); //sbField.Append("[Id]"); //sbValue.AppendFormat("'{0}'", oTrack.Id); sbField.Append("[REct])"); sbValue.AppendFormat("'{0}')", oTrack.REct); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); db.ExecuteNonQuery(CommandType.Text, cmdText); int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('Track')").ToString()); return id; } catch (Exception ex) { throw ex; } }
//Get XML From Database2 public static string GetOldXml(int id) { string RetrivedXML2 = null; try { //Instance for the database DatabaseProviderFactory factory2 = new DatabaseProviderFactory(); Microsoft.Practices.EnterpriseLibrary.Data.Database db2 = factory2.Create("DB2"); DbCommand dbCommand2 = db2.GetSqlStringCommand("SELECT xmldata FROM data WHERE id='" + id + "'"); object getOldXml = db2.ExecuteScalar(dbCommand2); if (getOldXml != null) { RetrivedXML2 = (string)getOldXml; } else { throw new Exception(String.Format("Could not find the historyId.", id)); } return(RetrivedXML2); } catch (Exception) { throw; } }
public static int Insert(Database db, EventRect oEventRect) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [EvenRectInfo]("); sbValue.Append("values ("); //sbField.Append("[FaceID]"); //sbValue.AppendFormat("'{0}'", oFace.FaceID); sbField.Append("[x]"); sbValue.AppendFormat("{0}", oEventRect.x); sbField.Append(",[y]"); sbValue.AppendFormat(",{0}", oEventRect.y); sbField.Append(",[w]"); sbValue.AppendFormat(",{0}", oEventRect.w); sbField.Append(",[h]"); sbValue.AppendFormat(",{0}", oEventRect.h); sbField.Append(",[ObjectId])"); sbValue.AppendFormat(",{0})", oEventRect.ObjectId); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); db.ExecuteNonQuery(CommandType.Text, cmdText); int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('EventRectInfo')").ToString()); return id; } catch (Exception ex) { throw ex; } }
public static int Insert(Database db, CapturePicture ocapturePicture) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [CapturePicture]("); sbValue.Append("values ("); //sbField.Append("[PictureID]"); //sbValue.AppendFormat("'{0}'", ocapturePicture.PictureID); sbField.Append("[CameraID]"); sbValue.AppendFormat("{0}", ocapturePicture.CameraID); sbField.Append(",[Datetime]"); //sbValue.AppendFormat(",'{0}'", ocapturePicture.Datetime); sbValue.AppendFormat(",'{0}'", ocapturePicture.Datetime); sbField.Append(",[FilePath])"); sbValue.AppendFormat(",'{0}')", ocapturePicture.FilePath); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); db.ExecuteNonQuery(CommandType.Text, cmdText); //string cmdText2 = "select max(PictureID) from CapturePicture"; //return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText2).ToString()); int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('CapturePicture')").ToString()); return id; } catch (Exception ex) { throw ex; } }
public static int Insert(Database db, REct oRect) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [REct]("); sbValue.Append("values ("); //sbField.Append("[RectID]"); //sbValue.AppendFormat("'{0}'", oRect.RectID); sbField.Append("[X]"); sbValue.AppendFormat("{0}", oRect.X); sbField.Append(",[Y]"); sbValue.AppendFormat(",{0}", oRect.Y); sbField.Append(",[W]"); sbValue.AppendFormat(",{0}", oRect.W); sbField.Append(",[H])"); sbValue.AppendFormat(",{0})", oRect.H); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); db.ExecuteNonQuery(CommandType.Text, cmdText); int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('REct')").ToString()); return id; } catch (Exception ex) { throw ex; } }
public void btnScalar_Click(System.Object sender, System.EventArgs e) { //ExecuteScalar int count = System.Convert.ToInt32(db.ExecuteScalar(CommandType.Text, "SELECT COUNT(*) FROM SampleData")); string message = string.Format("There are {0} rows in the sample data table.", count.ToString()); MessageBox.Show(message); }
public static object ExecuteScalar(EntLib.Database db, DbCommand cmd) { var f = new Func <object>(() => { return(db.ExecuteScalar(cmd)); }); return(RetryIt(f, cmd)); }
public void GetTiemposDeAlimentacion(int TiemposDeAlimentacionID) { DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory(); Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection"); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("SELECT Nombre FROM TblTiemposDeAlimentacion WHERE TiemposDeAlimentacionID=@PTiemposDeAlimentacionID"); DbCommand command = database.GetSqlStringCommand(stringBuilder.ToString()); database.AddInParameter(command, "PTiemposDeAlimentacionID", System.Data.DbType.String, TiemposDeAlimentacionID); Nombre = database.ExecuteScalar(command).ToString(); }
public void GetModuloHabitacional(string ModuloHabitacionalID) { DatabaseProviderFactory databaseProviderFactory = new DatabaseProviderFactory(); Microsoft.Practices.EnterpriseLibrary.Data.Database database = databaseProviderFactory.Create("DefaultConnection"); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.AppendLine("SELECT Nombre FROM TblModulosHabitacionales WHERE ModuloHabitacional=@PModuloHabitacional"); DbCommand command = database.GetSqlStringCommand(stringBuilder.ToString()); database.AddInParameter(command, "PModuloHabitacional", System.Data.DbType.String, ModuloHabitacionalID); Nombre = database.ExecuteScalar(command).ToString(); }
public static int GetMaxGroupSwitchGroupId(Database db) { string cmdText = "select max(Id) from GroupSwitchGroup"; try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()); } catch (Exception ex) { throw ex; } }
/// <summary> /// Executes the <paramref name="dbCommand"/> and returns an <see cref="IDataReader"/> through which the result can be read. /// It is the responsibility of the caller to close the connection and reader when finished. /// </summary> /// <param name="database">The database to execute the command within.</param> /// <param name="dbCommand">The command that contains the query to execute.</param> /// <returns>An <see cref="IDataReader"/> object.</returns> /// <exception cref="System.Exception">The command could not be executed.</exception> /// <exception cref="System.Data.Common.DbException">The command could not be executed.</exception> public static object ExecuteScalar(Enterprise.Database database, DbCommand dbCommand) { object results = null; try { results = database.ExecuteScalar(dbCommand); } catch (Exception ex) { throw new BusinessException(ex); } return(results); }
public static bool IsExistCapturePicture(Database db, int id, DateTime dt) { string cmdText = string.Format("select count(*) from CapturePicture where CameraID={0} and Datetime={1}", id, dt); try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()) > 0; } catch (Exception ex) { return false; } }
public static bool IsTaskExisted(Database db, int taskId) { string cmdText = string.Format("select count(*) from TaskInfo where TaskId={0}",taskId); try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString())>0; } catch (Exception ex) { throw ex; } }
private static bool IsExistRow(Database db,string name) { string cmdText = string.Format("select count(*) from systemParameter where Name='{0}';", name); try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString())>0; } catch (Exception ex) { throw ex; } }
public static int GetMaxDisplayChannelId(Database db) { string cmdText = "select max(DisplayChannelId) from displayChannelInfo"; try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()); } catch (Exception ex) { throw ex; } }
public static int GetMaxUserId(Database db) { string cmdText = "select max([UserId]) from [UserInfo]"; try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()); } catch (Exception ex) { throw ex; } }
public static int GetMaxSystemLogId(Database db) { string cmdText = "select max(Id) from OperateLog"; try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()); } catch (Exception ex) { throw ex; } }
internal static DateTime GetCurrentDateTime(Database db) { try { using (DbCommand cmd = db.GetSqlStringCommand(Resources.GetDatabaseCurrentDateTime)) { return (DateTime)db.ExecuteScalar(cmd); } } catch (Exception e) { AssistLogger.Log<ExceptionHolder>(e); return DateTime.Now; } }
public bool ExisteUsuario(string Usuario) { stringBuilder = new StringBuilder(); stringBuilder.Append("SELECT COUNT(1) FROM DbSistemas.dbo.TBLSECUSUARIOS WHERE USUARIO = @USUARIO"); DbCommand commad = Database.GetSqlStringCommand(stringBuilder.ToString()); Database.AddInParameter(commad, "USUARIO", System.Data.DbType.String, Usuario); if ((int)Database.ExecuteScalar(commad) > 0) { return(true); } else { return(false); } }
public static int GetEventRectCustomQuantity(Database db, int objectid) { string cmdText = string.Format( "select count(distinct EventRectInfo.EventRectId) " + "from EventRectInfo " + "where EventRectInfo.ObjectId={0}",objectid); try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()); } catch (Exception ex) { throw ex; } }
public bool ExistePersonalTiemposDeAlimentacion(string NumeroDeEmpleado, DateTime Fecha, int TiemposDeAlimentacionID) { stringBuilder = new StringBuilder(); stringBuilder.AppendLine("SELECT COUNT(1) FROM TblPersonalTiemposDeAlimentacion WHERE NumeroDeEmpleado=@NumeroDeEmpleado and Fecha=@Fecha and TiemposDeAlimentacionID=@TiemposDeAlimentacionID"); DbCommand cmd = Database.GetSqlStringCommand(stringBuilder.ToString()); Database.AddInParameter(cmd, "NumeroDeEmpleado", DbType.String, NumeroDeEmpleado); Database.AddInParameter(cmd, "Fecha", DbType.DateTime, Fecha); Database.AddInParameter(cmd, "TiemposDeAlimentacionID", DbType.Int16, TiemposDeAlimentacionID); if ((int)Database.ExecuteScalar(cmd) > 0) { return(true); } else { return(false); } }
public static int GetEventCustomQuantity(Database db, string str) { str = str.Replace("''", "'"); string cmdText = string.Format( "select count(distinct EventInfo.EventId) " + "from EventInfo,CapturePicture,VideoInfo " + "where EventInfo.PictureId=CapturePicture.PictureId and " + "CapturePicture.CameraId = VideoInfo.CameraId and (CapturePicture.[DateTime] between VideoInfo.CaptureTimeBegin and VideoInfo.CaptureTimeEnd) {0};", str); try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()); } catch (Exception ex) { throw ex; } }
public object ExecuteScalar(string query, CommandType commandType, List <IDbDataParameter> parameters) { DbConnection _connection; _connection = _database.CreateConnection(); _connection.Open(); var cmd = commandType == CommandType.StoredProcedure ? _database.GetStoredProcCommand(query) : _database.GetSqlStringCommand(query); cmd.CommandTimeout = 300; cmd.Connection = _connection; using (cmd) { if (parameters != null && parameters.Count > 0) { cmd.Parameters.AddRange(parameters.ToArray()); } return(_database.ExecuteScalar(cmd)); } }
public static int Insert(Database db, ObjectInfo oObject) { int i; StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [ObjectInfo]("); sbValue.Append("values ("); sbField.Append("[ObjectId"); sbValue.AppendFormat("{0}", oObject.ObjectId); if (oObject.stop == true) i = 1; else i = 0; sbField.Append(",[stop]"); sbValue.AppendFormat(",{0}", i); if (oObject.illegalDir == true) i = 1; else i = 0; sbField.Append(",[illegalDir]"); sbValue.AppendFormat(",{0}", i); if (oObject.CrossLine== true) i = 1; else i = 0; sbField.Append(",[CrossLine]"); sbValue.AppendFormat(",{0}", i); if (oObject.changeChannel == true) i = 1; else i = 0; sbField.Append(",[changeChannel]"); sbValue.AppendFormat(",{0}", i); sbField.Append(",[changeChannel])"); sbValue.AppendFormat(",{0})", oObject.EventId); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); db.ExecuteNonQuery(CommandType.Text, cmdText); int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('ObjectInfo')").ToString()); return id; } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行返回单个值的查询 /// </summary> /// <param name="cmdType">命令类型,SQL文本或存储过程</param> /// <param name="cmdText">SQL语句或存储过程名称</param> /// <returns>object值</returns> public static object ExecuteScalar(Database db, DbTransaction dbTransaction, CommandType cmdType, string cmdText) { DbCommand dbcmd = GetDbCommand(db, cmdType, cmdText); return db.ExecuteScalar(dbcmd, dbTransaction); }
/// <summary> /// 执行SQL语句事务,返回查询结果(object)。 /// </summary> /// <param name="dc">查询语句</param> /// <param name="db">操作目标数据库</param> /// <returns>查询结果(object)</returns> public static object GetSingleBySqlTrans(DbCommand dc, Database db) { object obj; using (DbConnection connection = db.CreateConnection()) { connection.Open(); using (DbTransaction transaction = connection.BeginTransaction()) { try { PrepareCommand(ref dc, db); obj = db.ExecuteScalar(dc); transaction.Commit(); if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { obj = null; } } catch (System.Exception e) { transaction.Rollback(); throw new Exception(e.Message); } connection.Close(); } } return obj; }
/// <summary> /// 执行一条计算查询结果语句,返回查询结果(object)。 /// </summary> /// <param name="dc">查询语句</param> /// <param name="db">操作目标数据库</param> /// <returns>查询结果(object)</returns> public static object GetSingle(DbCommand dc, Database db) { try { PrepareCommand(ref dc, db); object obj = db.ExecuteScalar(dc); if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { return null; } else { return obj; } } catch (System.Exception e) { throw new Exception(e.Message); } }
/* * The Interface1's description: * execute db.ExecuteScalar. * Parameters: * sql: * db: database object * Return Value * the first field of the first row. * Remark: * NULL * Output * NULL */ protected Object ExecuteScalar(String sql, Database db) { if (db == null) ExceptionManager.Throw(ExceptionMsg.DB_OBJECT_NULL); DbCommand dbCommand = db.GetSqlStringCommand(sql); return db.ExecuteScalar(dbCommand); }
public static bool IsWindowCameraExisted(Database db, int row, int col) { string cmdText = string.Format("select count(*) from [WindowCameraInfo] where [row]={0} and [col]={1}", row, col); try { return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText).ToString()) > 0 ? true : false; } catch (Exception ex) { throw ex; } }
public static int Insert(Database db, Face oFace) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [Face]("); sbValue.Append("values ("); //sbField.Append("[FaceID]"); //sbValue.AppendFormat("'{0}'", oFace.FaceID); sbField.Append("[score]"); sbValue.AppendFormat("'{0}'", oFace.score); sbField.Append(",[RectID]"); sbValue.AppendFormat(",{0}", oFace.RectID); sbField.Append(",[PictureID]"); sbValue.AppendFormat(",{0}", oFace.PictureID); sbField.Append(",[FacePath])"); sbValue.AppendFormat(",'{0}')", oFace.FacePath); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); db.ExecuteNonQuery(CommandType.Text, cmdText); int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('Face')").ToString()); return id; } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行返回单个值的查询 /// </summary> /// <param name="cmdType">命令类型,SQL文本或存储过程</param> /// <param name="cmdText">SQL语句或存储过程名称</param> /// <param name="paras">查询参数</param> /// <returns>object值</returns> public static object ExecuteScalar(Database db, DbTransaction dbTransaction, CommandType cmdType, string cmdText, params DbParameter[] paras) { DbCommand dbcmd = GetDbCommand(db, cmdType, cmdText); PrepareDbCommand(dbcmd, paras); return db.ExecuteScalar(dbcmd, dbTransaction); }
public static bool IsExisted(Database db, int groupSwitchid, int synGroupId) { String strSqlExisted = String.Format("select count(*) from GroupSwitchDetail where GroupSwitchGroupId={0} and SynGroupId={1}", groupSwitchid, synGroupId); try { return int.Parse(db.ExecuteScalar(CommandType.Text, strSqlExisted).ToString()) > 0 ? true : false; } catch (Exception ex) { throw ex; } }
public static int Insert(Database db, Event oEvent) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO [EventInfo]("); sbValue.Append("values ("); sbField.Append("[CarNum]"); sbValue.AppendFormat("{0}", oEvent.CarNum); sbField.Append(",[Congestion]"); sbValue.AppendFormat(",{0}", oEvent.Congestion); sbField.Append(",[PictureID])"); sbValue.AppendFormat(",{0})", oEvent.PictureID); string cmdText = sbField.ToString() + " " + sbValue.ToString(); try { cmdText = cmdText.Replace("\r\n", ""); db.ExecuteNonQuery(CommandType.Text, cmdText); int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('EventInfo')").ToString()); return id; } catch (Exception ex) { throw ex; } }
/// <summary> /// 执行 <paramref name="command"/> 命令并根据执行结果返回查询所返回的结果集中的第一行第一列。所有其他的行和列将会被忽略。 /// </summary> /// <param name="database">表示一个 <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Database"/> 对象。</param> /// <param name="command">要被执行的 <see cref="DbCommand"/> 命令。</param> /// <returns>表示 <paramref name="command"/> 执行的查询所返回的结果集中的第一行第一列。所有其他的行和列将会被忽略</returns> public static object ExecuteScalar(Database database, DbCommand command) { return database.ExecuteScalar(command); }
public int getPrecise(Database db, int itemid) { string strsql = string.Format(@"select Precise from ReportItem where ID ={0} ", itemid.ToString()); int vReturnValue = 0; vReturnValue = int.Parse(db.ExecuteScalar(CommandType.Text, strsql).ToString()); return vReturnValue; }
public static int InsertSynGroupCamera(Database db, int groupId, int cameraId, int displayChannelId, int displaySplitScreenNo) { string cmdTextIsExisted = string.Format("select count(*) from SynCamera where syngroupid={0} and cameraid={1} and displayChannelId={2} and displaySplitScreenNo= {3} ", groupId, cameraId, displayChannelId, displaySplitScreenNo); try { int isexisted = int.Parse(db.ExecuteScalar(CommandType.Text, cmdTextIsExisted).ToString()); if (isexisted > 0) { return -1; } } catch (Exception ex) { throw ex; } StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO SynCamera("); sbValue.Append("values("); sbField.Append("SynGroupId"); sbValue.AppendFormat("{0}", groupId); sbField.Append(",CameraId"); sbValue.AppendFormat(",{0}", cameraId); sbField.Append(",displayChannelId"); sbValue.AppendFormat(",{0}", displayChannelId); sbField.Append(",displaySplitScreenNo)"); sbValue.AppendFormat(",{0})", displaySplitScreenNo); string cmdText = sbField.ToString() + " " + sbValue.ToString() + ""; try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public override int CreatePrintTask(string creator, DateTime createTime, bool isPO, DbTransaction dbTran) { database = DatabaseFactory.CreateDatabase(); StringBuilder builder = new StringBuilder(); builder.Append("INSERT INTO Hishop_PrintTask(Creator,CreateDate,IsPO) VALUES(@Creator,@CreateDate,@IsPO);SELECT @@IDENTITY;"); DbCommand sqlStringCommand = database.GetSqlStringCommand(builder.ToString()); database.AddInParameter(sqlStringCommand, "Creator", DbType.String, creator); database.AddInParameter(sqlStringCommand, "CreateDate", DbType.DateTime, createTime); database.AddInParameter(sqlStringCommand, "IsPO", DbType.Boolean, isPO); if (dbTran != null) { return Convert.ToInt32(database.ExecuteScalar(sqlStringCommand, dbTran)); } return Convert.ToInt32(database.ExecuteScalar(sqlStringCommand)); }
public static bool IsExisted(Database db, int progSwitchid, int cameraId) { String strSqlExisted = String.Format("select count(*) from ProgSwitchDetail where ProgSwitchId={0} and CameraId={1}", progSwitchid, cameraId); try { return int.Parse(db.ExecuteScalar(CommandType.Text, strSqlExisted).ToString()) > 0 ? true : false; } catch (Exception ex) { throw ex; } }