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