private void UpdateHotSpot(string shopMallNo, string shopMallFloorNo, string shopNo, ROSHotSpot rosHotSpot)
{
string sql =
@"Update [dbo].HotSpot set [HotspotInfo] = @HotspotInfo where [SeatNo] =@SeatNo and [ShopMallNo]=@ShopMallNo and [FloorNo]=@FloorNo";
SqlParameter[] parameters =
{
BuildStringSqlParameter("@SeatNo", SqlDbType.NVarChar, 100, shopNo)
, BuildNoStringSqlParameter("@HotspotInfo", SqlDbType.NText, JsonConvert.SerializeObject(rosHotSpot))
, BuildStringSqlParameter("@ShopMallNo", SqlDbType.NVarChar, 100, shopMallNo)
, BuildStringSqlParameter("@FloorNo", SqlDbType.NVarChar, 100, shopMallFloorNo)
};
SqlHelper.ExecuteNonQuery(cnnstring, CommandType.Text, sql, parameters);
}
private void InsertHotSpot(string shopMallNo, string shopMallFloorNo, string shopNo, ROSHotSpot rosHotSpot)
{
string sql =
@"INSERT INTO [dbo].HotSpot
(
[SeatNo]
,[HotspotInfo]
,[ShopMallNo]
,[FloorNo]
)
VALUES
(
@SeatNo
,@HotspotInfo
,@ShopMallNo
,@FloorNo
) " ;
SqlParameter[] parameters =
{
BuildStringSqlParameter("@SeatNo", SqlDbType.NVarChar, 100, shopNo)
, BuildNoStringSqlParameter("@HotspotInfo", SqlDbType.NText, JsonConvert.SerializeObject(rosHotSpot))
, BuildStringSqlParameter("@ShopMallNo", SqlDbType.NVarChar, 100, shopMallNo)
, BuildStringSqlParameter("@FloorNo", SqlDbType.NVarChar, 100, shopMallFloorNo)
};
SqlHelper.ExecuteNonQuery(cnnstring, CommandType.Text, sql, parameters);
}
