private void button3_Click(object sender, EventArgs e)
{
AdHTML = htmlEditorControl1.InnerHtml;
//using (EditHtmlForm dialog = new EditHtmlForm())
//{
// dialog.HTML = this.DocumentHtml;
// dialog.ReadOnly = true;
// dialog.SetCaption(HTML_TITLE_VIEW);
// DefineDialogProperties(dialog);
// dialog.ShowDialog(this.ParentForm);
//}
//寫進資料庫
using (SmartShoppingEntities db = new SmartShoppingEntities())
{
//新增
if (NewAd)
{
Promotions promotion = new Promotions();
promotion.AdHtml = AdHTML;
promotion.PromotionName = this.textBoxTitle.Text;
db.Entry(promotion).State = EntityState.Added;
}
else
{
//修改
Promotions promotion = db.Promotions.Find(AdID);
promotion.AdHtml = AdHTML;
promotion.PromotionName = this.textBoxTitle.Text;
db.Entry(promotion).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
LoadAdLabel();
MessageBox.Show("儲存成功");
}
private void FromOrderToSmart()
{
using (SmartShoppingEntities db = new SmartShoppingEntities())
{
db.Database.ExecuteSqlCommand("TRUNCATE TABLE [RoleSmart]");
var q = from r in db.View_RoleXProduct
select r;//只從新增的開始讀?上次讀到幾要存起來
foreach (var item in q.ToList())
{
//檢查RoleSmart資料表是否有此Role X Product的紀錄
var qry = (from P in db.RoleSmart
where P.RoleID == item.Roles_ID && P.ProductID == item.Product_ID
select P).FirstOrDefault();
if (qry == null)
{
//新增程式代碼記錄
var NewRS = new RoleSmart();
NewRS.RoleID = item.Roles_ID;
NewRS.ProductID = item.Product_ID;
NewRS.TimesPurchased = 1;
NewRS.OrderBilling = item.Amount;
//加入程式代碼
db.Entry(NewRS).State = EntityState.Added;
db.SaveChanges();
}
else
{
RoleSmart rs = db.RoleSmart.Find(item.Roles_ID, item.Product_ID);
rs.TimesPurchased += 1;
rs.OrderBilling += item.Amount;
db.Entry(rs).State = EntityState.Modified;
db.SaveChanges();
}
}
}
}
