public static DataSet GetTempPicture(Database db, TempPicture oTempPicture)
{
string cmdText = string.Format("select * from TempPicture where CameraId={0} and DateTime='{1}'", oTempPicture.CameraID,oTempPicture.Datetime);
try
{
return db.ExecuteDataSet(CommandType.Text, cmdText);
}
catch (Exception ex)
{
throw ex;
}
}
public int DeleteTempPictureFromDbAndDisk(ref string errMessage, TempPicture oTempPicture)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
if (File.Exists(oTempPicture.FilePath))
{
File.Delete(oTempPicture.FilePath);
}
return TempPictureDataAccess.DeleteTempPicture(db, oTempPicture.PictureID);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return -1;
}
}
public static int InsertTempPicture(Database db, TempPicture oTempPicture)
{
StringBuilder sbField = new StringBuilder();
StringBuilder sbValue = new StringBuilder();
sbField.Append("INSERT INTO [TempPicture](");
sbValue.Append("values (");
//sbField.Append("[PictureID]");
//sbValue.AppendFormat("'{0}'", oTempPicture.PictureID);
sbField.Append("[CameraID]");
sbValue.AppendFormat("{0}", oTempPicture.CameraID);
sbField.Append(",[Datetime]");
//sbValue.AppendFormat(",'{0}'", oTempPicture.Datetime);
sbValue.AppendFormat(",'{0}'", oTempPicture.Datetime);
sbField.Append(",[IsHistroy]");
//sbValue.AppendFormat(",'{0}'", oTempPicture.Datetime);
sbValue.AppendFormat(",'{0}'", oTempPicture.IsHistroy);
sbField.Append(",[FilePath])");
sbValue.AppendFormat(",'{0}')", oTempPicture.FilePath);
string cmdText = sbField.ToString() + " " + sbValue.ToString();
try
{
cmdText = cmdText.Replace("\r\n", "");
db.ExecuteNonQuery(CommandType.Text, cmdText);
//string cmdText2 = "select max(PictureID) from TempPicture";
//return int.Parse(db.ExecuteScalar(CommandType.Text, cmdText2).ToString());
int id = int.Parse(db.ExecuteScalar(CommandType.Text, "SELECT ident_current('TempPicture')").ToString());
return id;
}
catch (Exception ex)
{
throw ex;
}
}
public string MoveTempPicture(ref string errMessage, TempPicture oTempPicture)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
string ret = null;
string destFilePath = SystemParametersBusiness.Instance.ListSystemParameter["CapPicPath"] + @"\" + oTempPicture.CameraID +
@"\" + oTempPicture.Datetime.ToString(@"yyyy\\MM\\dd\\HH\\") + oTempPicture.CameraID + oTempPicture.Datetime.ToString(@"_yyyy_MM_dd_HH_mm_ss_fff") + ".jpg";
if (File.Exists(oTempPicture.FilePath))
{
string path = Path.GetDirectoryName(destFilePath);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
File.Move(oTempPicture.FilePath, destFilePath);
TempPictureDataAccess.DeleteTempPicture(db, oTempPicture.PictureID);
ret = destFilePath;
}
return ret;
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return null;
}
}
public int InsertTempPicture(ref string errMessage, TempPicture oTempPicture)
{
Database db = DatabaseFactory.CreateDatabase();
errMessage = "";
try
{
return TempPictureDataAccess.InsertTempPicture(db, oTempPicture);
}
catch (Exception ex)
{
errMessage = ex.Message + ex.StackTrace;
logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace);
return -1;
}
}
