/// <summary>
/// Opens the QCL Form.
/// </summary>
/// <param name="context"></param>
protected override void DoWork(CodeActivityContext context)
{
//Get Values off the arguments
ImpacPersistenceManager pm = ImpacPersistenceManagerFactory.CreatePersistenceManager();
int proId = ProId.Get(context);
int staffIdResponsible = StaffIdResponsible.Get(context);
string comment = Comment.Get(context);
if (String.IsNullOrWhiteSpace(comment))
{
comment = String.Empty;
}
//Check if values exist in the database.
var prompt = pm.GetEntity <Prompt>(new PrimaryKey(typeof(Prompt), proId));
if (prompt.IsNullEntity)
{
throw new InvalidOperationException("Cannot find QCL Procedure (Prompt) record with Pro_Id: " + proId);
}
var staffResponsible = pm.GetEntity <Staff>(new PrimaryKey(typeof(Staff), staffIdResponsible));
if (staffResponsible.IsNullEntity)
{
throw new InvalidOperationException("Cannot find Responsible (Staff) record with Staff_Id: " + staffIdResponsible);
}
int chkId = CallClarion.AddQclRecord(prompt.Text, comment, staffIdResponsible);
ChkId.Set(context, chkId);
}
private void ClickProductEventArg(object sender, EventArgs e)
{
ProductId = int.Parse(((Button)sender).Name);
ProId?.Invoke(this, EventArgs.Empty);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string str = string.Empty;
string ProType = string.Empty; //促销方式
string ProIsEnabled = string.Empty; //是否启用
string ProInfos = string.Empty; //促销描述
string ProIsJieTi = string.Empty; //是否启用阶梯
string PromotionDate = string.Empty; //促销开始日期
string PromotionEndDate = string.Empty; //促销结束日期
int isComNew = 0; //是否发布促销公告
#region 判断值是否为空，取值
//促销方式
ProType = Request["promotionType"].ToString();
//是否启用
ProIsEnabled = Request["IsEnabled"].ToString();
//是否启用阶梯
ProIsJieTi = Request["IsEnabled2"].ToString();
//促销开始日期
if (this.txtPromotionDate.Value.Trim() == "")
{
str += " -- 促销开始日期不能为空。</br>";
}
else
{
PromotionDate = this.txtPromotionDate.Value.Trim();
}
//促销结束日期
if (this.txtPromotionDate1.Value.Trim() == "")
{
str += " -- 促销结束日期不能为空。</br>";
}
else
{
PromotionEndDate = this.txtPromotionDate1.Value.Trim();
}
ProInfos = Common.NoHTML(this.txtProInfos.Value.Trim().ToString());
if (str != "")
{
JScript.AlertMsgOne(this, str, JScript.IconOption.错误, 2500);
return;
}
#endregion
//是否发布促销公告
isComNew = this.isOkComNews.Checked ? 1 : 0;
string NewsContents = string.Empty;
NewsContents = "<font size=\"3\" style=\"line-height:30px;\">";
SqlTransaction Tran = null;
try
{
Hi.Model.BD_Promotion proModel = null;
int ProId = 0;
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
if (KeyID != 0)//修改
{
ProId = KeyID;
List <Hi.Model.BD_PromotionDetail2> l = new Hi.BLL.BD_PromotionDetail2().GetList("", "isnull(dr,0)=0 and proId=" + KeyID + " and compId=" + this.CompID, "", Tran);
if (l.Count > 0)
{
foreach (Hi.Model.BD_PromotionDetail2 item in l)
{
new Hi.BLL.BD_PromotionDetail2().Delete(item.ID, Tran);
}
}
proModel = new Hi.BLL.BD_Promotion().GetModel(KeyID, Tran);
}
else
{
proModel = new Hi.Model.BD_Promotion();
}
//else
//{
proModel.Type = Type.ToInt(0);
proModel.CompID = this.CompID;
proModel.ProType = ProType.ToInt(0);
if (ProType == "5")
{
proModel.ProTitle = "订单满减促销";
}
else if (ProType == "6")
{
proModel.ProTitle = "订单满折促销";
}
proModel.IsEnabled = ProIsEnabled.ToInt(0);
proModel.Discount = 0;
proModel.ProStartTime = PromotionDate.ToDateTime();
proModel.ProEndTime = PromotionEndDate.ToDateTime();
proModel.ProInfos = ProInfos;
proModel.CreateUserID = this.UserID;
proModel.CreateDate = DateTime.Now;
proModel.modifyuser = this.UserID;
proModel.ts = DateTime.Now.ToString();
if (KeyID != 0)//修改
{
ProId = KeyID;
proModel.ID = KeyID;
new Hi.BLL.BD_Promotion().Update(proModel, Tran);
}
else
{
ProId = new Hi.BLL.BD_Promotion().Add(proModel, Tran);
}
if (ProType == "5")
{
string[] price = Request["txtPrice"].ToString().Split(','); //需要满金额
string[] price2 = Request["txtSendFull"].ToString().Split(','); //满后需要减得金额
for (int i = 0; i < price.Length; i++)
{
if (price[i] != "")
{
Hi.Model.BD_PromotionDetail2 modelDeta = new Hi.Model.BD_PromotionDetail2();
modelDeta.CompID = this.CompID;
modelDeta.ProID = ProId;
modelDeta.OrderPrice = Convert.ToDecimal(price[i]);
modelDeta.Discount = Convert.ToDecimal(price2[i]);
modelDeta.modifyuser = this.UserID;
modelDeta.ts = DateTime.Now;
modelDeta.CreateUserID = this.UserID;
modelDeta.CreateDate = DateTime.Now;
new Hi.BLL.BD_PromotionDetail2().Add(modelDeta, Tran);
NewsContents += "订单金额满￥" + price[i] + "，立减￥" + price2[i] + "<br>";
}
}
}
else if (ProType == "6")
{
string[] prices = Request["txtPrices"].ToString().Split(','); //需要满金额
string[] prices2 = Request["txtDiscount"].ToString().Split(','); //满后折扣
for (int i = 0; i < prices.Length; i++)
{
if (prices[i] != "")
{
Hi.Model.BD_PromotionDetail2 modelDeta = new Hi.Model.BD_PromotionDetail2();
modelDeta.CompID = this.CompID;
modelDeta.ProID = ProId;
modelDeta.OrderPrice = Convert.ToDecimal(prices[i]);
modelDeta.Discount = Convert.ToDecimal(prices2[i]);
modelDeta.modifyuser = this.UserID;
modelDeta.ts = DateTime.Now;
modelDeta.CreateUserID = this.UserID;
modelDeta.CreateDate = DateTime.Now;
new Hi.BLL.BD_PromotionDetail2().Add(modelDeta, Tran);
NewsContents += "订单金额满￥" + prices[i] + "，打折（" + prices2[i] + "）%<br>";
}
}
}
//}
Hi.Model.BD_CompNews news = new Hi.Model.BD_CompNews();
news.CompID = CompID;
news.CreateDate = DateTime.Now;
news.CreateUserID = UserID;
news.dr = 0;
news.ts = DateTime.Now;
news.IsTop = 1;
news.IsEnabled = 0;
news.NewsType = 4;
news.ShowType = "2";
if (ProType == "5")
{
news.NewsTitle = "订单满减促销";
}
else if (ProType == "6")
{
news.NewsTitle = "订单满折促销";
}
NewsContents += "先到先得！";
ProInfos = ProInfos == "" ? "" : "（" + ProInfos + "）";
NewsContents += ProInfos;
NewsContents += " </br> 活动时间：" + PromotionDate.ToDateTime().ToString("yyyy-MM-dd") + "至" + PromotionEndDate.ToDateTime().ToString("yyyy-MM-dd");
NewsContents += "</font>";
news.NewsContents = NewsContents;
news.modifyuser = UserID;
news.PmID = ProId;
if (isComNew == 1)
{
new Hi.BLL.BD_CompNews().Add(news, Tran);
}
Tran.Commit();
Response.Write("<script>window.location.href='PromotionInfo2.aspx?KeyId=" + Common.DesEncrypt(ProId.ToString(), Common.EncryptKey) + "&type=" + Type + "';</script>");
}
catch (Exception ex)
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
JScript.AlertMsgOne(this, "保存失败了", JScript.IconOption.错误, 2500);
return;
}
finally
{
DBUtility.SqlHelper.ConnectionClose();
}
}
