public int Add(Photo entity) { try { int result = 0; string strSQL = @"INSERT INTO tb_photo (ArticleID,BigImage,SmallImage) VALUES (@ArticleID,@BigImage,@SmallImage);"; DbCommand dbCommand = DB.DB.Db().GetSqlStringCommand(strSQL); DB.DB.Db().AddInParameter(dbCommand, "@ArticleID", DbType.Int32, entity.ArticleID); DB.DB.Db().AddInParameter(dbCommand, "@BigImage", DbType.String, entity.BigImage); DB.DB.Db().AddInParameter(dbCommand, "@SmallImage", DbType.String, entity.SmallImage); result = DB.DB.Db().ExecuteNonQuery(dbCommand); return result; } catch (Exception ex) { Log.Log.logError(ex.Message); throw; } }
private Photo FillEntity(DataRow dr) { Photo entity = new Photo() { ArticleID = DataTypeHelper.Convert<Int32>(dr["ArticleID"]), BigImage = DataTypeHelper.Convert<String>(dr["BigImage"]), SmallImage = DataTypeHelper.Convert<String>(dr["SmallImage"]) }; return entity; }