public static void UpdateDeatil(AsyncDbHelper db, SE_ActivityDeatil model)
{
string sql = @"UPDATE Configuration].[dbo].[SE_ActivityDeatil]
SET
[GROUP] =@GROUP
,[PID] = @PID
,[ActivityFlashID] = @ActivityFlashID
,[CouponID] = @CouponID
,[SmallImage] =@SmallImage
,[BigImage] = @BigImage
,[ColunmNumber] = @ColunmNumber
,[Type] = @Type
,[OrderBy] = @OrderBy
,[AppUrl] = @AppUrl
,[WapUrl] = @WapUrl
,[PCUrl] = @PCUrl
,[HandlerIOS] = @HandlerIOS
,[HandlerAndroid] = @HandlerAndroid
,[SOAPIOS] = @SOAPIOS
,[SOAPAndroid] = @SOAPAndroid
,[IsImage] = @IsImage
,[DisplayWay] = @DisplayWay
,[Description] = @Description
WHERE ID=@ID ";
SqlCommand cmd = new SqlCommand(sql);
// cmd.Parameters.AddWithValue("@FK_Activity", model.FK_Activity.ToString());
cmd.Parameters.AddWithValue("@GROUP", model.GROUP);
cmd.Parameters.AddWithValue("@PID", model.PID);
cmd.Parameters.AddWithValue("@ActivityFlashID", model.ActivityFlashID);
cmd.Parameters.AddWithValue("@CouponID", model.CouponID);
cmd.Parameters.AddWithValue("@SmallImage", model.SmallImage);
cmd.Parameters.AddWithValue("@BigImage", model.BigImage);
cmd.Parameters.AddWithValue("@ColunmNumber", model.ColunmNumber);
cmd.Parameters.AddWithValue("@Type", model.Type);
cmd.Parameters.AddWithValue("@OrderBy", model.OrderBy);
cmd.Parameters.AddWithValue("@AppUrl", model.AppUrl);
cmd.Parameters.AddWithValue("@WapUrl", model.WapUrl);
cmd.Parameters.AddWithValue("@PCUrl", model.PCUrl);
cmd.Parameters.AddWithValue("@HandlerIOS", model.HandlerIOS);
cmd.Parameters.AddWithValue("@HandlerAndroid", model.HandlerAndroid);
cmd.Parameters.AddWithValue("@SOAPIOS", model.SOAPIOS);
cmd.Parameters.AddWithValue("@SOAPAndroid", model.SOAPAndroid);
cmd.Parameters.AddWithValue("@IsImage", model.IsImage);
cmd.Parameters.AddWithValue("@DisplayWay", model.DisplayWay);
cmd.Parameters.AddWithValue("@Description", model.Description);
cmd.Parameters.AddWithValue("@ID", model.ID);
db.ExecuteNonQuery(cmd);
}
public static void AddDeatil(AsyncDbHelper db, SE_ActivityDeatil model)
{
string sql = @"INSERT INTO Configuration.dbo.SE_ActivityDeatilConfig
(FK_Activity,
[GROUP],
PID,
ActivityFlashID,
CouponID,
SmallImage,
BigImage,
ColunmNumber,
[Type],
OrderBy,
AppUrl,
WapUrl,
PCUrl,
HandlerIOS,
HandlerAndroid,
SOAPIOS,
SOAPAndroid,
IsImage,
DisplayWay,
[Description],
ProductName,ActivityPrice
)
VALUES(@FK_Activity, --FK_Activity - uniqueidentifier
@GROUP, --GROUP - nvarchar(50)
@PID, --PID - nvarchar(50)
@ActivityFlashID, --ActivityFlashID - nvarchar(100)
@CouponID, --CouponID - int
@SmallImage, --SmallImage - nvarchar(200)
@BigImage, --BigImage - nvarchar(200)
@ColunmNumber, --ColunmNumber - int
@Type, --Type - int
@OrderBy, --OrderBy - int
@AppUrl, --AppUrl - nvarchar(100)
@WapUrl, --WapUrl - nvarchar(100)
@PCUrl, --PCUrl - nvarchar(100)
@HandlerIOS, --HandlerIOS - nvarchar(200)
@HandlerAndroid, --HandlerAndroid - nvarchar(200)
@SOAPIOS, --SOAPIOS - nvarchar(200)
@SOAPAndroid, --SOAPAndroid - nvarchar(200)
@IsImage, --IsImage - int
@DisplayWay, --DisplayWay - int
@Description, -- Description - text
@ProductName,
@ActivityPrice
)
";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@FK_Activity", model.FK_Activity.ToString());
cmd.Parameters.AddWithValue("@GROUP", model.GROUP);
cmd.Parameters.AddWithValue("@PID", model.PID);
cmd.Parameters.AddWithValue("@ActivityFlashID", model.ActivityFlashID);
cmd.Parameters.AddWithValue("@CouponID", model.CouponID);
cmd.Parameters.AddWithValue("@SmallImage", model.SmallImage);
cmd.Parameters.AddWithValue("@BigImage", model.BigImage);
cmd.Parameters.AddWithValue("@ColunmNumber", model.ColunmNumber);
cmd.Parameters.AddWithValue("@Type", model.Type);
cmd.Parameters.AddWithValue("@OrderBy", model.OrderBy);
cmd.Parameters.AddWithValue("@AppUrl", model.AppUrl);
cmd.Parameters.AddWithValue("@WapUrl", model.WapUrl);
cmd.Parameters.AddWithValue("@PCUrl", model.PCUrl);
cmd.Parameters.AddWithValue("@HandlerIOS", model.HandlerIOS);
cmd.Parameters.AddWithValue("@HandlerAndroid", model.HandlerAndroid);
cmd.Parameters.AddWithValue("@SOAPIOS", model.SOAPIOS);
cmd.Parameters.AddWithValue("@SOAPAndroid", model.SOAPAndroid);
cmd.Parameters.AddWithValue("@IsImage", model.IsImage);
cmd.Parameters.AddWithValue("@DisplayWay", model.DisplayWay);
cmd.Parameters.AddWithValue("@Description", model.Description);
cmd.Parameters.AddWithValue("@ProductName", model.ProductName);
cmd.Parameters.AddWithValue("@ActivityPrice", model.ActivityPrice);
db.ExecuteNonQuery(cmd);
}
public ActionResult Edit(string rows = "")
{
SE_ActivityDeatil model = JsonConvert.DeserializeObject <SE_ActivityDeatil>(rows);
return(View(model));
}
