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