/// <summary>
/// 推送消息
/// </summary>
/// <param name="msgID">操作单</param>
public void GetMsgService(string msgID, string type)
{
try
{
MsgID = msgID.Trim();
MsgType = type.Trim();
Hi.Model.BD_CompNews order = new Hi.BLL.BD_CompNews().GetModel(int.Parse(MsgID));
if (order == null)
{
return;
}
MsgThread();
//this.threadMsg = new Thread(new ThreadStart(MsgThread));
//this.threadTimer = new Thread(new ThreadStart(ThreadTimeOut));
//threadMsg.Start();
//threadTimer.Start();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDel_Click(object sender, EventArgs e)
{
if (KeyID != 0)
{
Hi.Model.BD_Promotion proModel = new Hi.BLL.BD_Promotion().GetModel(KeyID);
//促销公告
List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID, "");
if (proModel != null)
{
proModel.IsEnabled = 1;
proModel.dr = 1;
if (new Hi.BLL.BD_Promotion().Update(proModel))
{
if (newsl != null && newsl.Count > 0)
{
Hi.Model.BD_CompNews newsModel = new Hi.Model.BD_CompNews();
foreach (Hi.Model.BD_CompNews item in newsl)
{
item.IsEnabled = 0;
item.dr = 1;
newsModel = item;
}
new Hi.BLL.BD_CompNews().Update(newsModel);
}
Response.Write("<script>window.location.href='PromotionList.aspx?type=" + Request["type"] + "';</script>");
}
}
}
}
//绑定新闻
public void NewsBind()
{
string whereStr = "isnull(dr,0)=0 and IsEnabled=1 and Compid=" + CompID + " ";
#region 新闻公告
List <Hi.Model.BD_CompNews> LNew = new Hi.BLL.BD_CompNews().GetList("NewsTitle,isnull(ShowType,0) as ShowType,ID,CompID", whereStr, " istop desc,createdate desc");
string Html = "";
if (LNew.Count > 0)
{
for (int i = 0; i < 10; i++)
{
if (LNew.Count > i)
{
LNew[i].ShowType = LNew[i].ShowType == null ? "" : LNew[i].ShowType;
if (LNew[i] != null)
{
Html += "<li><a " + (LNew[i].ShowType.IndexOf("2") >= 0 ? "style='color:red;'" : "") + " title='" + LNew[i].NewsTitle + "' target=\"_blank\" href=\"/EShop/NewsInfo.aspx?ID=" + LNew[i].ID + "&comid=" + LNew[i].CompID + "&Type=3\">" + (LNew[i].NewsTitle.Length > 14 ? LNew[i].NewsTitle.Substring(0, 14) + "..." : LNew[i].NewsTitle) + "</a></li>";
}
}
else
{
Html += "<li> </li>";
}
}
NewsList.InnerHtml = Html;
}
else
{
NewsList.InnerHtml = "<li>暂无公告</li><li></li><li></li><li></li>";
}
#endregion
}
protected void btn_Del(object sender, EventArgs e)
{
Hi.Model.BD_CompNews NewsNotice = new Hi.BLL.BD_CompNews().GetModel(KeyID);
if (NewsNotice != null)
{
NewsNotice.dr = 1;
NewsNotice.ts = DateTime.Now;
NewsNotice.modifyuser = UserID;
if (new Hi.BLL.BD_CompNews().Update(NewsNotice))
{
WebReference.AppService app = new AppService();
try
{
app.MsgPush(NewsNotice.ID.ToString(), "-1");
}
catch
{
app.Abort();
}
if (Request["Type"] == "3")
{
ClientScript.RegisterStartupScript(this.GetType(), "Result", "<script>window.close();</script>");
}
else
{
//JScript.AlertMsgMo(this, "操作成功", "function(){ window.location.href='NewsList.aspx'; }");
Response.Redirect("NewsList.aspx");
}
}
}
}
/// <summary>
/// 禁用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnNo_Click(object sender, EventArgs e)
{
if (KeyID != 0)
{
Hi.Model.BD_Promotion proModel = new Hi.BLL.BD_Promotion().GetModel(KeyID);
//促销公告
List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID, "");
if (proModel != null)
{
proModel.IsEnabled = 0;
if (new Hi.BLL.BD_Promotion().Update(proModel))
{
Hi.Model.BD_CompNews newsModel = new Hi.Model.BD_CompNews();
if (newsl != null && newsl.Count > 0)
{
foreach (Hi.Model.BD_CompNews item in newsl)
{
item.IsEnabled = 0;
newsModel = item;
}
new Hi.BLL.BD_CompNews().Update(newsModel);
}
Response.Write("<script>window.location.href='PromotionInfo2.aspx?KeyId=" + Common.DesEncrypt(this.KeyID.ToString(), Common.EncryptKey) + "&type=" + Request["type"] + "';</script>");
}
}
}
}
public void Bind()
{
int pageCount = 0;
int Counts = 0;
//每页显示的数据设置
if (this.txtPageSize.Value.ToString() != "")
{
if (this.txtPageSize.Value.Trim().ToInt(0) >= 10000)
{
Pager.PageSize = 100;
this.txtPageSize.Value = "100";
}
else
{
Pager.PageSize = this.txtPageSize.Value.Trim().ToInt(0);
}
}
List <Hi.Model.BD_CompNews> CompNewsNotice = new Hi.BLL.BD_CompNews().GetList(Pager.PageSize, Pager.CurrentPageIndex, "CreateDate", true, SearchWhere(), out pageCount, out Counts);
this.Rpt_Distribute.DataSource = CompNewsNotice;
this.Rpt_Distribute.DataBind();
Pager.RecordCount = Counts;
page = Pager.CurrentPageIndex.ToString();
}
public void Databind()
{
if (KeyID > 0)
{
try
{
Hi.Model.BD_CompNews NewsNotice = new Hi.BLL.BD_CompNews().GetModel(KeyID);
if (NewsNotice != null)
{
if (NewsNotice.CompID != CompID)
{
Response.Write("你无权访问。");
Response.End();
}
txtNewsTitle.Value = NewsNotice.NewsTitle;
content7.Text = NewsNotice.NewsContents;
//是否启用
int status = NewsNotice.IsEnabled;
this.RdIsbled1.Checked = (status == 1);
this.RdIsbled2.Checked = (status != 1);
string[] ShowType = NewsNotice.ShowType.Split(new char[] { ',' });
foreach (string s in ShowType)
{
switch (s)
{
case "1": CkShowType1.Checked = true; break;
case "2": CkShowType2.Checked = true; break;
}
}
//是否置顶
int istop = NewsNotice.IsTop;
this.RdTop3.Checked = (istop == 1);
this.RdTop4.Checked = (istop != 1);
//类型 1：新闻 2：公告 3：活动
int newstype = NewsNotice.NewsType;
this.RdType1.Checked = (newstype == 1);
this.RdType2.Checked = (newstype == 2);
this.RdType3.Checked = (newstype == 3);
this.RdType4.Checked = (newstype == 4);
this.RdType5.Checked = (newstype == 5);
}
else
{
Response.Write("信息不存在。");
Response.End();
}
}
catch (Exception ex)
{
}
}
}
public void DataBinds()
{
if (KeyID > 0)
{
Hi.Model.BD_CompNews NewsNotice = new Hi.BLL.BD_CompNews().GetModel(KeyID);
if (NewsNotice.CompID != this.CompID)
{
Response.Write("你无权限访问。");
Response.End();
}
if (NewsNotice != null)
{
if (Request["Type"] == "3")
{
libtnEdit.Visible = false;
libtnDel.Visible = false;
libtnback.Visible = false;
liPreView.Visible = false;
}
//lblnewstitle.InnerText = NewsNotice.NewsTitle;
title = NewsNotice.NewsTitle;
//lblcontent.InnerText = NewsNotice.NewsContents;
string pat = "<[^<>]+>";
Regex regex = new Regex(pat, RegexOptions.None);
content = NewsNotice.NewsContents.Replace("<span>", "<p>").Replace("<span", "<p").Replace("</span>", "</p>");
lblstate.InnerHtml = NewsNotice.IsEnabled == 1 ? "是" : "<i style='color:red'>否</i>";
lblistop.InnerHtml = NewsNotice.IsTop == 1 ? "置顶" : "非置顶";
lblnewtype.InnerHtml = Common.GetCPNewStateName(NewsNotice.NewsType);
string[] showType = NewsNotice.ShowType.Split(new char[] { ',' });
foreach (string s in showType)
{
if (s == "1")
{
lblShowType.InnerText = "New";
}
if (s == "2")
{
if (lblShowType.InnerText == "")
{
lblShowType.InnerText = "标红";
}
else
{
lblShowType.InnerText += "，标红";
}
}
}
}
else
{
Response.Write("信息不存在。");
Response.End();
}
}
}
public void DataBinds()
{
List <Hi.Model.BD_CompNews> CompNewS = new Hi.BLL.BD_CompNews().GetList("", " isnull(dr,0)=0 and CompID=" + CompID + " and ID='" + KeyID + "'", "");
if (CompNewS.Count > 0)
{
Hi.Model.BD_CompNews CompNew = CompNewS[0];
lblNewTitle.InnerHtml = CompNew.NewsTitle + IsEnd(CompNew.PmID);
lblNewContent.InnerHtml = CompNew.NewsContents;
lblCreateDate.InnerText = CompNew.CreateDate.ToString("yyy-MM-dd HH:mm") + " 【" + Common.GetCPNewStateName(CompNew.NewsType) + "】" + (CompNew.IsTop == 1 ? "【置顶】" : "");
}
else
{
Response.Write("数据不存在");
Response.End();
}
}
//绑定新闻
public void NewsBind()
{
if (ShopList.Count == 0)
{
return;
}
string whereStr = "isnull(dr,0)=0 and IsEnabled=1 and Compid=" + Request["Comid"] + " ";
if (HttpContext.Current.Session["UserModel"] == null)
{
//未登录
whereStr += " and NewsType in (1,2,3,5)";
}
#region 新闻公告
List <Hi.Model.BD_CompNews> LNew = new Hi.BLL.BD_CompNews().GetList("NewsTitle,isnull(ShowType,0) as ShowType,ID,CompID", whereStr, " istop desc,createdate desc");
string Html = "";
if (LNew.Count > 0)
{
for (int i = 0; i < 10; i++)
{
if (LNew.Count > i)
{
LNew[i].ShowType = LNew[i].ShowType == null ? "" : LNew[i].ShowType;
if (LNew[i] != null)
{
Html += "<li><a " + (LNew[i].ShowType.IndexOf("2") >= 0 ? "style='color:red;'" : "") + " title='" + LNew[i].NewsTitle + "' target=\"_blank\" href=\"/eshop/NewsInfo_" + LNew[i].ID + "_" + LNew[i].CompID + "_3.html\" >" + (LNew[i].NewsTitle.Length > 14 ? LNew[i].NewsTitle.Substring(0, 14) + "..." : LNew[i].NewsTitle) + "</a></li>";
}
}
else
{
Html += "<li> </li>";
}
}
NewsList.InnerHtml = Html;
}
else
{
NewsList.InnerHtml = "<li>暂无公告</li><li></li><li></li><li></li>";
}
#endregion
}
public void Bind()
{
Hi.Model.BD_CompNews CompNew = new Hi.BLL.BD_CompNews().GetModel(KeyID);
if (CompNew != null)
{
if (CompNew.CompID != this.CompID)
{
Response.Write("数据不存在");
Response.End();
}
lblNewTitle.InnerHtml = CompNew.NewsTitle + IsEnd(CompNew.PmID);
lblCreateDate.InnerText = CompNew.CreateDate.ToString("yyy-MM-dd HH:mm") + " 【" + Common.GetCPNewStateName(CompNew.NewsType) + "】" + (CompNew.IsTop == 1 ? "【置顶】" : "");
lblNewContent.InnerHtml = CompNew.NewsContents;
}
else
{
Response.Write("数据不存在");
Response.End();
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string str = string.Empty;
string ProTitle = string.Empty;
string ProType = string.Empty;
string ProIsEnabled = string.Empty;
string ProInfos = string.Empty;
string PromotionDate = string.Empty;
string PromotionEndDate = string.Empty;
decimal disCount = 0; //折扣率
decimal SendNum = 0; //满送数量
int isComNew = 0;
#region 判断值是否为空，取值
//促销标题
if (this.txtPromotiontitle.Value == "")
{
str += " -- 促销标题不能为空。</br>";
}
else
{
ProTitle = Common.NoHTML(this.txtPromotiontitle.Value.Trim());
}
//促销方式
ProType = Request["promotionType"].ToString();
//是否启用
ProIsEnabled = Request["IsEnabled"].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());
List <Hi.Model.BD_GoodsInfo> gl = Session["GoodsPrice"] as List <Hi.Model.BD_GoodsInfo>;
if (gl == null || gl.Count <= 0)
{
str += " -- 促销商品信息不能为空。</br>";
}
// 促销类型判断取值
if (Type == "1")
{
if (ProType == "3")
{
//满送
disCount = this.txtSendFull.Value.Trim().ToString().ToDecimal(0);
SendNum = this.txtSendNum.Value.Trim().ToString().ToDecimal(0);
if (disCount.ToString() == "" || SendNum.ToString() == "")
{
if (disCount.ToString() == "")
{
str += " -- 满送订购数量不能为空。</br>";
}
else
{
str += " -- 获赠商品数量不能为空。</br>";
}
}
}
else
{
//打折
disCount = this.txtDiscount.Value.Trim().ToString().ToDecimal(0);
if (disCount.ToString() != "")
{
if ((int)disCount < 0 || (int)disCount > 100)
{
str += " -- 打折请输入0—100的数。</br>";
}
}
else
{
str += " -- 打折不能为空。</br>";
}
}
}
if (str != "")
{
JScript.AlertMsgOne(this, str, JScript.IconOption.错误, 2500);
ClientScript.RegisterStartupScript(this.GetType(), "Protype", "<script>Protype('" + ProType + "');</script>");
return;
}
#endregion
int ProId = 0;
//是否发布促销公告
isComNew = this.isOkComNews.Checked ? 1 : 0;
string NewsContents = string.Empty;
NewsContents = "<font size=\"3\" style=\"line-height:30px;\">";
try
{
if (KeyID != 0)
{
#region 修改促销
Hi.Model.BD_Promotion proModel = ProBll.GetModel(KeyID);
if (proModel != null)
{
proModel.Type = Type.ToInt(0);
proModel.ProType = ProType.ToInt(0);
proModel.ProTitle = ProTitle;
proModel.IsEnabled = ProIsEnabled.ToInt(0);
proModel.Discount = disCount;
proModel.ProStartTime = PromotionDate.ToDateTime();
proModel.ProEndTime = PromotionEndDate.ToDateTime();
proModel.ProInfos = ProInfos;
proModel.modifyuser = this.UserID;
proModel.ts = DateTime.Now.ToString();
List <Hi.Model.BD_PromotionDetail> l = new List <Hi.Model.BD_PromotionDetail>();
Hi.Model.BD_PromotionDetail proDmodel = null;
foreach (var item in gl)
{
proDmodel = new Hi.Model.BD_PromotionDetail();
proDmodel.CompID = this.CompID;
proDmodel.GoodInfoID = item.ID;
proDmodel.GoodsID = item.GoodsID;
if (ProType == "3")
{
//满送
proDmodel.SendGoodsinfoID = item.ID;
proDmodel.GoodsPrice = SendNum;
}
else
{
proDmodel.SendGoodsinfoID = 0;
if (ProType == "4")
{
//打折
proDmodel.GoodsPrice = (item.SalePrice * (disCount / 100));
}
else
{
proDmodel.GoodsPrice = item.TinkerPrice;
}
}
proDmodel.GoodsName = GoodsName(item.ID.ToString());
proDmodel.GoodsUnit = GoodsUnit(item.ID.ToString());
proDmodel.Goodsmemo = Goodsmemo(item.ID.ToString());
proDmodel.ts = DateTime.Now.ToString();
proDmodel.modifyuser = this.UserID;
proDmodel.CreateUserID = this.UserID;
proDmodel.CreateDate = DateTime.Now;
string memo = proDmodel.Goodsmemo == "" ? "" : proDmodel.Goodsmemo.Substring(0, proDmodel.Goodsmemo.Length - 1);
NewsContents += proDmodel.GoodsName + " " + memo + " /" + proDmodel.GoodsUnit + " 原价 " + item.SalePrice.ToString("N") + " 促销价 " + proDmodel.GoodsPrice.ToString("N") + "！ </br>";
l.Add(proDmodel);
}
int Id = ProBll.ProUpdate(proModel, l);
NewsContents += "先到先得！";
ProInfos = ProInfos == "" ? "" : "（" + ProInfos + "）";
NewsContents += ProInfos;
NewsContents += "</br> 活动时间：" + PromotionDate.ToDateTime().ToString("yyyy-MM-dd") + "至" + PromotionEndDate.ToDateTime().ToString("yyyy-MM-dd");
NewsContents += "</font>";
//促销公告
List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID, "");
Hi.Model.BD_CompNews news = null;
if (newsl != null && newsl.Count > 0)
{
foreach (Hi.Model.BD_CompNews item in newsl)
{
news = new Hi.Model.BD_CompNews();
news.ID = item.ID;
news.PmID = KeyID;
news.CompID = item.CompID;
news.CreateDate = DateTime.Now;
news.CreateUserID = UserID;
news.dr = item.dr;
news.ts = DateTime.Now;
if (ProIsEnabled.ToInt(0) == 1)
{
news.IsTop = 1;
news.IsEnabled = 0;
news.NewsType = 4;
news.ShowType = "2";
}
else
{
news.IsTop = item.IsTop;
news.IsEnabled = 0;
news.NewsType = item.NewsType;
news.ShowType = item.ShowType;
}
news.NewsTitle = ProTitle;
news.NewsContents = NewsContents;
news.modifyuser = UserID;
}
}
else
{
news = new Hi.Model.BD_CompNews();
news.PmID = KeyID;
news.CompID = CompID;
news.CreateDate = DateTime.Now;
news.CreateUserID = UserID;
news.dr = 0;
news.ts = DateTime.Now;
news.IsTop = 1;
news.IsEnabled = 1;
news.NewsType = 4;
news.ShowType = "2";
news.NewsTitle = ProTitle;
news.NewsContents = NewsContents;
news.modifyuser = UserID;
}
if (Id != 0)
{
if (isComNew == 1)
{
if (newsl != null && newsl.Count > 0)
{
//存在促销公告
new Hi.BLL.BD_CompNews().Update(news);
}
else
{
//不存在促销公告
new Hi.BLL.BD_CompNews().Add(news);
}
}
else
{
if (newsl != null && newsl.Count > 0)
{
news.IsEnabled = 0;
//存在促销公告
new Hi.BLL.BD_CompNews().Update(news);
}
else
{
news.IsEnabled = 0;
//不存在促销公告
new Hi.BLL.BD_CompNews().Add(news);
}
}
Response.Write("<script>window.location.href='../PmtManager/PromotionInfo.aspx?KeyId=" + Common.DesEncrypt(this.KeyID.ToString(), Common.EncryptKey) + "&type=" + Type + "';</script>");
}
}
#endregion
}
else
{
#region 新增促销
Hi.Model.BD_Promotion proModel = new Hi.Model.BD_Promotion();
proModel.Type = Type.ToInt(0);
proModel.CompID = this.CompID;
proModel.ProType = ProType.ToInt(0);
proModel.ProTitle = ProTitle;
proModel.IsEnabled = ProIsEnabled.ToInt(0);
proModel.Discount = disCount;
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();
List <Hi.Model.BD_PromotionDetail> l = new List <Hi.Model.BD_PromotionDetail>();
Hi.Model.BD_PromotionDetail proDmodel = null;
foreach (var item in gl)
{
proDmodel = new Hi.Model.BD_PromotionDetail();
proDmodel.CompID = this.CompID;
proDmodel.GoodInfoID = item.ID;
proDmodel.GoodsID = item.GoodsID;
if (ProType == "3")
{
//满送
proDmodel.SendGoodsinfoID = item.ID;
proDmodel.GoodsPrice = SendNum;
}
else
{
proDmodel.SendGoodsinfoID = 0;
if (ProType == "4")
{
//打折
proDmodel.GoodsPrice = (item.SalePrice * (disCount / 100));
}
else
{
proDmodel.GoodsPrice = item.TinkerPrice;
}
}
proDmodel.GoodsName = GoodsName(item.ID.ToString());
proDmodel.GoodsUnit = GoodsUnit(item.ID.ToString());
proDmodel.Goodsmemo = Goodsmemo(item.ID.ToString());
proDmodel.ts = DateTime.Now.ToString();
proDmodel.modifyuser = this.UserID;
proDmodel.CreateUserID = this.UserID;
proDmodel.CreateDate = DateTime.Now;
string memo = proDmodel.Goodsmemo == "" ? "" : proDmodel.Goodsmemo.Substring(0, proDmodel.Goodsmemo.Length - 1);
NewsContents += proDmodel.GoodsName + " " + memo + " /" + proDmodel.GoodsUnit + " 原价 " + item.SalePrice.ToString("N") + " 促销价 " + proDmodel.GoodsPrice.ToString("N") + "！ </br>";
l.Add(proDmodel);
}
NewsContents += "先到先得！";
ProInfos = ProInfos == "" ? "" : "（" + ProInfos + "）";
NewsContents += ProInfos;
NewsContents += " </br> 活动时间：" + PromotionDate.ToDateTime().ToString("yyyy-MM-dd") + "至" + PromotionEndDate.ToDateTime().ToString("yyyy-MM-dd");
NewsContents += "</font>";
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 = 1;
news.NewsType = 4;
news.ShowType = "2";
news.NewsTitle = ProTitle;
news.NewsContents = NewsContents;
news.modifyuser = UserID;
int Id = ProBll.AddPro(proModel, l);
if (Id != 0)
{
news.PmID = Id;
if (isComNew == 1)
{
int count = new Hi.BLL.BD_CompNews().Add(news);
WebReference.AppService app = new AppService();
try
{
app.MsgPush(count.ToString(), "1");
}
catch
{
app.Abort();
}
}
Response.Write("<script>window.location.href='../PmtManager/PromotionInfo.aspx?KeyId=" + Common.DesEncrypt(Id.ToString(), Common.EncryptKey) + "&type=" + Type + "';</script>");
}
#endregion
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!(Session["UserModel"] as LoginModel).IsExistRole)
{
Response.Redirect("~/Distributor/UserEdit.aspx", true);
}
//获取当前时间
DateTime date = DateTime.Now;
//当天0点0分
DateTime day0 = new DateTime(date.Year, date.Month, date.Day, 0, 0, 0);
//获取当前时间加一天
DateTime Sday = day0.AddDays(1);
//当月第一天
DateTime day1 = new DateTime(date.Year, date.Month, 1);
//本月 最后一天 多加一天
DateTime mothday = day1.AddMonths(1);
user = new Hi.BLL.SYS_Users().GetModel(this.UserID);
orderl = new Hi.BLL.DIS_Order().GetList("", " isnull(dr,0)=0 and Otype<>9 and OState<>6 and CompID=" + this.CompID + " and DisID=" + this.DisID, " CreateDate desc");
if (orderl != null)
{
#region
//当天订单数
dayOrderCount = orderl.FindAll(
p => (p.OState == 2 || p.OState == 3 || p.OState == 4 || p.OState == 5 || p.OState == 7) && p.CreateDate >= day0 && p.CreateDate < Sday).Count;
//本月订单数
orderCount = orderl.FindAll(
p => (p.OState == 2 || p.OState == 3 || p.OState == 4 || p.OState == 5 || p.OState == 7) && p.CreateDate >= day1 && p.CreateDate < mothday).Count;
#endregion
orderll = orderl.FindAll(p => (p.PayState == 0 || p.PayState == 1));
}
List <Hi.Model.DIS_Suggest> suggest = new Hi.BLL.DIS_Suggest().GetList("", " isnull(dr,0)=0 and Stype=0 and isanswer=1 and DisUserID=" + this.UserID, "");
message = suggest.Count;
if (message == 0)
{
//imessage.Attributes.Add("style", "display:none");
}
price = Convert.ToDecimal(new Hi.BLL.PAY_PrePayment().sums(this.DisID, this.CompID)).ToString("0.00");
dis = new Hi.BLL.BD_Distributor().GetModel(this.DisID);
if (dis != null)//add by hgh 出现为null值
{
//if ( dis.CreditType == 0)
//{
//lisalesorder.Attributes.Add("style", "background-color:#fbfbfb");
//}
Hi.Model.BD_DisType distypemodel = new Hi.BLL.BD_DisType().GetModel(dis.DisTypeID);
if (distypemodel != null)
{
disType = distypemodel.TypeName;
}
Hi.Model.BD_DisArea disaddrmodel = new Hi.BLL.BD_DisArea().GetModel(dis.AreaID);
if (disaddrmodel != null)
{
disAreaID = disaddrmodel.AreaName;
}
}
#region 促销商品
string Cx_sql = string.Format(@"SELECT count(1) num from BD_Goods
where ID in (SELECT GoodsID from BD_PromotionDetail where ProID in
(SELECT ID from BD_Promotion where compID={0} and ProStartTime<=getdate()
and ProStartTime<=GETDATE() and DATEADD(D,1,ProEndTime)>= getDate() and IsEnabled=1 ))and ID not in (
select GoodsID from BD_GoodsAreas where compID={0} and DisID={1} and isnull(dr,0)=0)
and compid= {0} and ISNULL(dr,0)=0 and IsEnabled = 1 and IsOffLine=1 ", this.CompID, this.DisID);
DataTable Cx_Dt = SqlHelper.Query(SqlHelper.LocalSqlServer, Cx_sql).Tables[0];
if (Cx_Dt != null)
{
if (Cx_Dt.Rows.Count > 0)
{
decimal sum_CX = Convert.ToDecimal(Cx_Dt.Rows[0]["num"]);
Cx_Sum = sum_CX.ToString();
}
}
#endregion
#region 快过期商品 goods_Sum
//当前时间
DateTime now = DateTime.Now;
//快到期时间
DateTime today = now.AddDays(30);
string goods_sql = string.Format(@"select * from YZT_GoodsStock s where s.validDate<='" + today + "'" + " and DisID=" + DisID + " and dr=0 ");
DataTable goods_Dt = SqlHelper.Query(SqlHelper.LocalSqlServer, goods_sql).Tables[0];
if (goods_Dt != null && goods_Dt.Rows.Count > 0)
{
goods_Sum = goods_Dt.Rows.Count.ToString();
}
#endregion
#region 当天订购额
//add by hgh //包含已退订单金额、退单处理
string daysql = "SELECT SUM(AuditAmount) as AuditAmount FROM [dbo].[DIS_Order] where ostate in (2,3,4,5,7) and DisID=" +
this.DisID + " and CompID=" + this.CompID + " and CreateDate>='" + day0 + "' and CreateDate<'" + Sday + "'";
DataTable dayDt = SqlHelper.Query(SqlHelper.LocalSqlServer, daysql).Tables[0];
if (dayDt != null)
{
if (dayDt.Rows.Count > 0)
{
decimal sumAmount = dayDt.Rows[0]["AuditAmount"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(dayDt.Rows[0]["AuditAmount"]);
DaySum = (sumAmount).ToString("N");
}
}
#endregion
#region 本月订购额
string monthsql = "SELECT SUM(AuditAmount) as AuditAmount FROM DIS_Order where OState in (2,3,4,5,7) and isnull(dr,0)=0 and Otype<>9 and DisID=" + this.DisID + " and CompID=" + this.CompID + " and CreateDate>='" + day1 + "' and CreateDate<'" + mothday + "'";
DataTable monthDt = SqlHelper.Query(SqlHelper.LocalSqlServer, monthsql).Tables[0];
if (monthDt != null)
{
if (monthDt.Rows.Count > 0)
{
decimal sumAmount = monthDt.Rows[0]["AuditAmount"].ToString() == "" ? sum.ToString().ToDecimal() : Convert.ToDecimal(monthDt.Rows[0]["AuditAmount"]);
MonthSum = (sumAmount).ToString("N");
}
}
#endregion
#region 当天付款额
//付款额 add by hgh CompCollection_view 状态 and status!=3
string daypaggersql = "SELECT SUM(Price) as Price FROM [dbo].[CompCollection_view] where DisID=" + this.DisID +
"and CompID=" + this.CompID + " and status!=3 and Date>='" + day0 + "' and Date<'" + Sday + "' AND vedf9=1 ";
DataTable daypaggerdt = SqlHelper.Query(SqlHelper.LocalSqlServer, daypaggersql).Tables[0];
if (daypaggerdt != null)
{
if (daypaggerdt.Rows.Count > 0)
{
decimal Price = daypaggerdt.Rows[0]["Price"].ToString() == ""
? sum.ToString().ToDecimal()
: Convert.ToDecimal(daypaggerdt.Rows[0]["Price"]);
DayPaymentSum = (Price).ToString("N");
}
}
#endregion
#region 本月付款额
//本月付款额 add by hgh CompCollection_view 状态 and status!=3
string paggersql = "SELECT SUM(Price) as Price FROM [dbo].[CompCollection_view] where OrderID not in (select ID from Dis_Order where ISNULL(dr,0)=0 and Otype=9) and DisID=" + this.DisID + " and status!=3 and CompID=" + this.CompID + " and Date>='" + day1 + "' and Date<'" + mothday + "' AND vedf9=1 ";
DataTable paggerdt = SqlHelper.Query(SqlHelper.LocalSqlServer, paggersql).Tables[0];
if (paggerdt != null)
{
if (paggerdt.Rows.Count > 0)
{
decimal Price = paggerdt.Rows[0]["Price"].ToString() == "" ? sum.ToString().ToDecimal() : Convert.ToDecimal(paggerdt.Rows[0]["Price"]);
PaymentSum = (Price).ToString("N");
}
}
#endregion
#region 本月应付额
//本月应付额
decimal AuditAmount = 0;
decimal payAmount = 0;
decimal payyzf = 0;
//赊销订单 未支付的
//string ArrearageSql = "SELECT SUM(AuditAmount) as AuditAmount FROM [dbo].[ArrearageRpt_view] where DisID=" + user.DisID + "and CompID=" + user.CompID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday + "'";
//DataTable ArrearageDt = SqlHelper.Query(SqlHelper.LocalSqlServer, ArrearageSql).Tables[0];
//if (ArrearageDt != null)
//{
// if (ArrearageDt.Rows.Count > 0)
// {
// AuditAmount = ArrearageDt.Rows[0]["AuditAmount"].ToString() == "" ? sum.ToString().ToDecimal() : Convert.ToDecimal(ArrearageDt.Rows[0]["AuditAmount"]);
// }
//}
//未支付订单金额
//string paysql = " select SUM(AuditAmount) as AuditAmount from DIS_Order where (( Otype=1 and OState not in (-1,0,1) and PayState in (0,1) ) or( Otype<>1 and OState=2 and PayState in (0,1) )) and OState<>6 and ReturnState=0 and isnull(dr,0)=0 and Otype!=9 and CompID=" + this.CompID + " and DisID=" + this.DisID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday + "'";
//DataTable payDt = SqlHelper.Query(SqlHelper.LocalSqlServer, paysql).Tables[0];
//if (payDt != null && payDt.Rows.Count > 0)
//{
// payAmount = payDt.Rows[0]["AuditAmount"].ToString() == "" ? 0 : payDt.Rows[0]["AuditAmount"].ToString().ToDecimal(0);
//}
//paysql = " select SUM(PayedAmount) as PayedAmount from DIS_Order where (( Otype=1 and OState not in (-1,0,1) and PayState in (0,1) ) or( Otype<>1 and OState=2 and PayState in (0,1) )) and OState<>6 and ReturnState=0 and isnull(dr,0)=0 and Otype!=9 and CompID=" + this.CompID + " and DisID=" + this.DisID + " and CreateDate>='" + day1 + "' and CreateDate<='" + Sday + "'";
//payDt = SqlHelper.Query(SqlHelper.LocalSqlServer, paysql).Tables[0];
//if (payDt != null && payDt.Rows.Count > 0)
//{
// payyzf = payDt.Rows[0]["PayedAmount"].ToString() == "" ? 0 : payDt.Rows[0]["PayedAmount"].ToString().ToDecimal(0);
//}
//PayableSum = (payAmount - payyzf + AuditAmount).ToString("N");
//edit by hgh 正常合同 总额-已付
string paysql = " select SUM(AuditAmount)-SUM(PayedAmount) as AuditAmount from DIS_Order where OState in(2,3,5) and isnull(dr,0)=0 and Otype!=9 and CompID=" + this.CompID + " and DisID=" + this.DisID + " and CreateDate>='" + day1 + "' and CreateDate<'" + Sday + "'";
DataTable payDt = SqlHelper.Query(SqlHelper.LocalSqlServer, paysql).Tables[0];
if (payDt != null && payDt.Rows.Count > 0)
{
payAmount = payDt.Rows[0]["AuditAmount"].ToString() == "" ? 0 : payDt.Rows[0]["AuditAmount"].ToString().ToDecimal(0);
}
PayableSum = payAmount.ToString("N");
#endregion
#region 商家公告
List <Hi.Model.BD_CompNews> LNew = new Hi.BLL.BD_CompNews().GetList("top 3 *", "isnull(dr,0)=0 and IsEnabled=1 and Compid=" + this.CompID + " ", " istop desc,createdate desc");
string Html = "";
if (LNew.Count > 0)
{
for (int i = 0; i < LNew.Count; i++)
{
if (LNew[i].ShowType == null)
{
LNew[i].ShowType = "";
}
if (i <= 4)
{
string type = LNew[i].ShowType == "1" ? "top" : LNew[i].ShowType == "2" ? "red" : LNew[i].ShowType == "1,2" ? "top red" : "";
Html += "<li class='" + type + "'><a title='" + LNew[i].NewsTitle + "' href=\"CompNewInfo.aspx?KeyID=" + Common.DesEncrypt(LNew[i].ID.ToString(), Common.EncryptKey) + "&Type=3\">【" + Common.GetCPNewStateName(LNew[i].NewsType) + "】" + (LNew[i].NewsTitle.Length > 16 ? LNew[i].NewsTitle.Substring(0, 16) + "..." : LNew[i].NewsTitle) + "</a>" + IsEnd(LNew[i].PmID) + (LNew[i].ShowType.IndexOf("1") >= 0 ? "<i class='newIcon'></i>" : "") + "<i class='date1'>" + LNew[i].CreateDate.ToString("yyyy-MM-dd") + "</i></li>";
}
}
ULNewList.InnerHtml = Html;
}
else
{
//ULNewList.InnerHtml = "<li style='text-align:center'><span>暂无公告</span></li>";
ULNewList.InnerHtml = "<div class='nomh-box'><i class='nomh-i'></i>暂无公告</div>";
}
#endregion
if (!IsPostBack)
{
if (IsDisAdmin(this.UserID))
{
if (user.UserPwd == Util.md5("123456"))
{
DisImport.Attributes.Add("style", "display:block");
zzc.Attributes.Add("style", "display:block");
return;
}
}
}
}
public ResultNewsList CompNewsList(string JSon)
{
try
{
StringBuilder str = new StringBuilder();
#region JSon取值
string userID = string.Empty;
string compID = string.Empty;
string criticalOrderID = string.Empty; //当前列表最临界点产品ID:初始-1
string getType = string.Empty; //方向
string rows = string.Empty;
string sortType = string.Empty;
string sort = string.Empty;
string orderType = string.Empty;
string DisID = string.Empty;
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["CompanyID"].ToString() != "" &&
JInfo["Search"].ToString() != "" && JInfo["CriticalOrderID"].ToString() != "" &&
JInfo["GetType"].ToString() != "" && JInfo["Rows"].ToString() != "" &&
JInfo["SortType"].ToString() != "" && JInfo["Sort"].ToString() != "" &&
JInfo["OrderType"].ToString() != "")
{
userID = JInfo["UserID"].ToString().Trim();
compID = JInfo["CompanyID"].ToString().Trim();
str.Append(" AND CompID='" + compID + "' AND IsEnabled=1 and dr=0");
criticalOrderID = JInfo["CriticalOrderID"].ToString();
getType = JInfo["GetType"].ToString();
rows = JInfo["Rows"].ToString();
sortType = JInfo["SortType"].ToString();
sort = JInfo["Sort"].ToString();
orderType = JInfo["OrderType"].ToString();//0：只按时间 1：置顶优先，再按时间排序
//DisID = JInfo["ResellerID"].ToString();//经销商登录时需要传入经销商ID用于对登录信息进行判断
}
else
{
return(new ResultNewsList()
{
Result = "F", Description = "参数异常"
});
}
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
//if (DisID == "")
//{
// if (!new Common().IsLegitUser(int.Parse(userID), out user, int.Parse(compID)))
// return new ResultNewsList() { Result = "F", Description = "登录信息异常" };
// Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(Convert.ToInt32(compID));
// if (comp == null || comp.dr == 1 || comp.AuditState == 0 || comp.IsEnabled == 0)
// return new ResultNewsList() { Result = "F", Description = "核心企业异常" };
//}
//else
//{
// if (!new Common().IsLegitUser(int.Parse(userID), out user, 0, int.Parse(DisID)))
// return new ResultNewsList() { Result = "F", Description = "登录信息异常" };
// //判断经销商信息是否异常
// Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(Convert.ToInt32(DisID));
// if (dis == null || dis.dr == 1 || dis.IsEnabled == 0 || dis.AuditState == 0)
// return new ResultNewsList() { Result = "F", Description = "经销商信息异常" };
// //判断经销商对应的核心企业信息是否异常
// Hi.Model.BD_Company comp = new Hi.BLL.BD_Company().GetModel(dis.CompID);
// if (comp == null || comp.dr == 1 || comp.AuditState == 0 || comp.IsEnabled == 0)
// return new ResultNewsList() { Result = "F", Description = "核心企业异常" };
//}
JsonData JMsg = JInfo["Search"];
if (JMsg.Count > 0)
{
string NewsID = JMsg["NewsID"].ToString().Trim();
string Title = JMsg["Title"].ToString().Trim();
string IsEnabled = JMsg["IsEnable"].ToString().Trim();
string IsTop = JMsg["IsTop"].ToString().Trim();
string NewsType = JMsg["NewsType"].ToString().Trim();
string ShowType = JMsg["ShowType"].ToString().Trim();
if (NewsID != "-1")
{
str.Append(" and ID ='" + NewsID + "' ");
}
if (Title != "-1")
{
str.Append(" and NewsTitle like '%" + Title + "%' ");
}
if (IsEnabled != "-1")
{
str.Append(" and IsEnable = '" + IsEnabled + "' ");
}
if (IsTop != "-1")
{
str.Append(" and IsTop = '" + IsTop + "' ");
}
if (NewsType != "-1")
{
str.Append(" and NewsType = '" + NewsType + "' ");
}
if (ShowType != "-1")
{
str.Append(ShowType == "3" ? " and ShowType = '1,2' " : " and ShowType = '" + ShowType + "' ");
}
}
#endregion
List <NewsInfo> NewsList = new List <NewsInfo>();
if (orderType == "1")
{
#region 取当前置顶的新闻公告
List <Hi.Model.BD_CompNews> newsList = new Hi.BLL.BD_CompNews().GetList("",
" IsEnabled =1 and IsTop =1 and CompID='" + compID + "' and dr=0", "createDate desc");
if (newsList != null && newsList.Count != 0)
{
str.Append(" and ID not in (-1"); //通用列表中去除置顶公告
if (criticalOrderID.Trim() == "-1")
{
// List<NewsInfo> NewsList_select = newsList.Select(newsInfo => new NewsInfo()
// {
// NewsID = newsInfo.ID.ToString(),
// Title = newsInfo.NewsTitle,
// IsEnabled = newsInfo.IsEnabled.ToString(),
// IsTop = newsInfo.IsTop.ToString(),
// NewsType = newsInfo.NewsType.ToString(),
// ShowType =
// newsInfo.ShowType != "1" && newsInfo.ShowType != "2" && ClsSystem.gnvl(newsInfo.ShowType,"").Trim() != ""
// ? "3" : newsInfo.ShowType,
// CreateTime = newsInfo.CreateDate.ToString()
// }
// ).ToList();
foreach (
NewsInfo news in newsList.Select(newsInfo => new NewsInfo()
{
NewsID = newsInfo.ID.ToString(),
Title = newsInfo.NewsTitle,
IsEnabled = newsInfo.IsEnabled.ToString(),
IsTop = newsInfo.IsTop.ToString(),
NewsType = newsInfo.NewsType.ToString(),
ShowType =
newsInfo.ShowType != "1" && newsInfo.ShowType != "2" && ClsSystem.gnvl(newsInfo.ShowType, "").Trim() != ""
? "3" : newsInfo.ShowType,
CreateTime = newsInfo.CreateDate.ToString()
}
))
//foreach (NewsInfo news in NewsList_select)
{
NewsList.Add(news);
str.Append("," + news.NewsID);
}
}
str.Append(")");
}
#endregion
int dtRow = Convert.ToInt32(rows) - NewsList.Count;
if (dtRow > 1)
{
rows = dtRow.ToString();
}
}
#region 模拟分页
string tabName = " [dbo].[BD_CompNews]"; //表名
string strsql = string.Empty; //搜索sql
sortType = "CreateDate";
sort = "0";
strsql = new Common().PageSqlString(criticalOrderID, "ID", tabName, sortType, sort, str.ToString(), getType, rows);
if (strsql == "")
{
return new ResultNewsList()
{
Result = "F", Description = "基础数据异常"
}
}
;
#endregion
#region 赋值
DataSet ds = SqlHelper.Query(SqlHelper.LocalSqlServer, strsql);
if (ds.Tables.Count == 0)
{
if (NewsList.Count == 0)
{
return new ResultNewsList()
{
Result = "T", Description = "没有更多数据"
}
}
;
else
{
return(new ResultNewsList()
{
Result = "T", Description = "", NewsList = NewsList
});
}
}
DataTable dtList = ds.Tables[0];
if (dtList != null)
{
if (dtList.Rows.Count == 0)
{
if (NewsList.Count != 0)
{
return new ResultNewsList()
{
Result = "T", Description = "", NewsList = NewsList
}
}
;
else
{
return(new ResultNewsList()
{
Result = "F", Description = "没有更多数据"
});
}
}
foreach (DataRow newsInfo in dtList.Rows)
{
NewsInfo news = new NewsInfo();
news.NewsID = newsInfo["ID"].ToString();
news.Title = newsInfo["NewsTitle"].ToString();
news.IsOverdue = "0";
if (newsInfo["NewsType"].ToString() == "4")
{
if (newsInfo["PmID"] != null && Convert.ToInt32(newsInfo["PmID"]) != 0)
{
Hi.Model.BD_Promotion pro = new Hi.BLL.BD_Promotion().GetModel(Convert.ToInt32(newsInfo["PmID"].ToString()));
if (pro.ProEndTime < DateTime.Now)
{
news.IsOverdue = "1";
}
}
}
news.IsEnabled = newsInfo["IsEnabled"].ToString();
news.IsTop = newsInfo["IsTop"].ToString();
news.NewsType = newsInfo["NewsType"].ToString();
news.ShowType = newsInfo["ShowType"].ToString() != "1" && newsInfo["ShowType"].ToString() != "2" &&
newsInfo["ShowType"].ToString().Trim() != "" ? "3" : newsInfo["ShowType"].ToString();
news.CreateTime = newsInfo["CreateDate"].ToString();
NewsList.Add(news);
}
}
#endregion
return(new ResultNewsList()
{
Result = "T", Description = "获取成功", NewsList = NewsList
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "CompNewsList ：" + JSon);
return(new ResultNewsList()
{
Result = "F", Description = "异常"
});
}
}
/// <summary>
/// 获取推送用户，返回推送类
/// </summary>
/// <param name="userType">0 （当前用户类型是企业，即推送至经销商） 1 （当前用户类型是经销商，即推送至企业） 2 全部 </param>
/// <param name="sendType">类型同微信推送</param>
/// <returns></returns>
public PushPayload GetMsgUserModel(string orderID, string type)
{
Hi.Model.BD_CompNews order = new Hi.BLL.BD_CompNews().GetModel(int.Parse(orderID));
if (order == null)
{
return(null);
}
//推送设置
PushPayload payload = new PushPayload();
payload.platform = Platform.android_ios();//推送平台
//推送用户，0：推送给经销商 1：推送给企业
//payload.audience = Audience.all();
List <Hi.Model.SYS_CompUser> userList = new Hi.BLL.SYS_CompUser().GetList("",
" compID='" + order.CompID + "' and IsAudit = 2 and disID!=0 and dr=0 and IsEnabled=1 and (Utype=1 or Utype =5)", "");
if (userList == null || userList.Count == 0)
{
return(null);
}
string[] arr = new String[userList.Count];
for (int i = 0; i < userList.Count; i++)
{
//arr[i] = AESHelper.Encrypt_android(userList[i].ID.ToString());
//arr[i] = AESHelper.Encrypt_android_old(userList[i].ID.ToString());
arr[i] = AESHelper.Encrypt_MD5(userList[i].ID.ToString());//MD5加密
}
payload.audience = Audience.s_alias(arr);
//payload.audience = Audience.s_alias(AESHelper.Encrypt_android("1304"));
//推送通知
string str = "{\"Type\":\"" + (type == "" || type == "-1" ? "-1" : order.NewsType.ToString()) +
"\",\"Title\":\"" + order.NewsTitle +
"\",\"ID\":\"" + order.ID.ToString() + "\",\"Date\":\"" + DateTime.Now.ToString("yyyy-MM-dd") + "\"}";
// SendType 0：推送给经销商 1：推送给企业
string sendStr = "{\"SendType\":\"0\",\"CompID\":\"" + order.CompID + "\"}";
//AndroidNotification android = new AndroidNotification();
//android.setAlert(GetAlertContent(order, sendType));//推送内容
//payload.notification = new Notification().setAndroid(android);//推送内容
payload.notification = new Notification().setAlert("您有一条新的信息公告！")
.setAndroid(new AndroidNotification()//设置Android的notification
.AddExtra("Type", "2")
.AddExtra("CheckUser", AESHelper.Encrypt_android(sendStr))
.AddExtra("Json", AESHelper.Encrypt_android(str)))
.setIos(new IosNotification() //设置IOS的notification
.setAlert("您有一条新的信息公告")
.autoBadge()
.AddExtra("Type", "2")
.AddExtra("CheckUser", AESHelper.Encrypt_android(sendStr))
.AddExtra("Json", AESHelper.Encrypt_android(str)));
//推送消息
payload.message = Message.content("您有一条新的短消息！")
.AddExtras("Type", "2")
.AddExtras("CheckUser", AESHelper.Encrypt_android(sendStr))
.AddExtras("Json", AESHelper.Encrypt_android(str));
Options op = new Options();
op.apns_production = false;
payload.options = op;
return(payload);
}
public ResultNewsInfo GetNewsInfo(string JSon)
{
try
{
#region JSon取值
string userID = string.Empty;
string compID = string.Empty;
string newsID = string.Empty;
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["CompanyID"].ToString() != "" &&
JInfo["NewsID"].ToString() != "")
{
userID = JInfo["UserID"].ToString().Trim();
compID = JInfo["CompanyID"].ToString().Trim();
newsID = JInfo["NewsID"].ToString().Trim();
}
else
{
return(new ResultNewsInfo()
{
Result = "F", Description = "参数异常"
});
}
//Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
//if (!new Common().IsLegitUser(int.Parse(userID), out user, int.Parse(compID)))
// return new ResultNewsInfo() { Result = "F", Description = "登录信息异常" };
#endregion
Hi.Model.BD_CompNews newsInfo = new Hi.BLL.BD_CompNews().GetModel(Convert.ToInt32(newsID));
if (newsInfo == null)
{
return new ResultNewsInfo()
{
Result = "F", Description = "未找到信息"
}
}
;
NewsInfo news = new NewsInfo()
{
NewsID = newsInfo.ID.ToString(),
Title = newsInfo.NewsTitle,
Contents = newsInfo.NewsContents,
IsEnabled = newsInfo.IsEnabled.ToString(),
IsTop = newsInfo.IsTop.ToString(),
NewsType = newsInfo.NewsType.ToString(),
ShowType = newsInfo.ShowType != "1" && newsInfo.ShowType != "2" && newsInfo.ShowType.Trim() != "" ? "3" : newsInfo.ShowType,
CreateTime = newsInfo.CreateDate.ToString()
};
return(new ResultNewsInfo()
{
Result = "T", Description = "返回成功", NewsInfo = news
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetNewsInfo ：" + JSon);
return(new ResultNewsInfo()
{
Result = "F", Description = "异常"
});
}
}
public ResultNewsAdd CompNewsAdd(string JSon)
{
try
{
#region JSon取值
string userID = string.Empty;
string compID = string.Empty;
string title = string.Empty;
string contents = string.Empty;
string IsEnabled = string.Empty;
string IsTop = string.Empty;
string NewsType = string.Empty;
string ShowType = string.Empty;
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["CompanyID"].ToString() != "" &&
JInfo["Title"].ToString() != "" &&
JInfo["IsEnable"].ToString() != "" && JInfo["IsTop"].ToString() != "" &&
JInfo["NewsType"].ToString() != "")
{
userID = JInfo["UserID"].ToString();
compID = JInfo["CompanyID"].ToString();
title = Common.NoHTML(JInfo["Title"].ToString());
contents = Common.NoHTML(JInfo["Contents"].ToString());
IsEnabled = JInfo["IsEnable"].ToString();
IsTop = JInfo["IsTop"].ToString();
NewsType = JInfo["NewsType"].ToString();
ShowType = JInfo["ShowType"].ToString();
}
else
{
return(new ResultNewsAdd()
{
Result = "F", Description = "参数异常"
});
}
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
if (!new Common().IsLegitUser(int.Parse(userID), out user, int.Parse(compID)))
{
return new ResultNewsAdd()
{
Result = "F", Description = "登录信息异常"
}
}
;
#endregion
Hi.Model.BD_CompNews NewsNotice = new Hi.Model.BD_CompNews();
NewsNotice.CompID = Convert.ToInt32(compID);
NewsNotice.NewsTitle = title;
NewsNotice.NewsContents = contents;
NewsNotice.IsEnabled = IsEnabled == "1" ? 1 : 0; //是否启用
NewsNotice.IsTop = IsTop == "1" ? 1 : 0; //是否置顶
if (NewsType.Trim() != "1" && NewsType.Trim() != "2" && NewsType.Trim() != "3" &&
NewsType.Trim() != "4" && NewsType.Trim() != "5")
{
return new ResultNewsAdd()
{
Result = "F", Description = "类别异常"
}
}
;
NewsNotice.NewsType = Convert.ToInt32(NewsType);//类别
if (ShowType.Trim() != "1" && ShowType.Trim() != "2" && ShowType.Trim() != "3" && ShowType.Trim() != "-1")
{
return new ResultNewsAdd()
{
Result = "F", Description = "展示效果异常"
}
}
;
if (ShowType != "-1")
{
NewsNotice.ShowType = ShowType == "3"?"1,2":ShowType;//标红、加new
}
//标准参数
NewsNotice.CreateDate = DateTime.Now;
NewsNotice.CreateUserID = Convert.ToInt32(userID);
NewsNotice.ts = DateTime.Now;
NewsNotice.modifyuser = Convert.ToInt32(userID);
int newsrid = 0;
newsrid = new Hi.BLL.BD_CompNews().Add(NewsNotice);
if (newsrid <= 0)
{
return new ResultNewsAdd()
{
Result = "F", Description = "添加失败", NewsID = newsrid.ToString()
}
}
;
if (IsTop == "1")//置顶数量不能超过3个
{
List <Hi.Model.BD_CompNews> CompNew = new Hi.BLL.BD_CompNews().GetList("", " isnull(dr,0)=0 and Compid=" + compID + " and IsEnabled=1 and istop=1 and PMID=0", " createdate desc");
if (CompNew.Count > 3)
{
for (int i = 0; i < CompNew.Count; i++)
{
if (i > 1 && CompNew[i].ID != newsrid)
{
CompNew[i].IsTop = 0;
NewsNotice.ts = DateTime.Now;
NewsNotice.modifyuser = Convert.ToInt32(userID);
new Hi.BLL.BD_CompNews().Update(CompNew[i]);
}
}
}
}
new MsgSend().GetMsgService(newsrid.ToString(), "1");
return(new ResultNewsAdd()
{
Result = "T", Description = "添加成功", NewsID = newsrid.ToString()
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "CompNewsAdd ：" + JSon);
return(new ResultNewsAdd()
{
Result = "F", Description = "异常"
});
}
}
public ResultNoTime GetMessageDeleteId(string JSon)
{
try
{
string userID = string.Empty;
string disID = string.Empty;
string IDlist = string.Empty;
JsonData JInfo = JsonMapper.ToObject(JSon);
if (JInfo.Count > 0 && JInfo["UserID"].ToString() != "" && JInfo["ResellerID"].ToString() != "" &&
JInfo["UnreadMessageID"].ToString() != "")
{
userID = JInfo["UserID"].ToString().Trim();
disID = JInfo["ResellerID"].ToString().Trim();
IDlist = JInfo["UnreadMessageID"].ToString().Trim();
}
else
{
return(new ResultNoTime()
{
Result = "F", Description = "参数异常"
});
}
Hi.Model.SYS_Users user = new Hi.Model.SYS_Users();
if (!new Common().IsLegitUser(int.Parse(userID), out user, 0, int.Parse(disID == "" ? "0" : disID)))
{
return new ResultNoTime()
{
Result = "F", Description = "用户异常"
}
}
;
Hi.Model.BD_Distributor dis = new Hi.BLL.BD_Distributor().GetModel(Convert.ToInt32(disID));
if (dis == null || dis.dr == 1 || dis.IsEnabled == 0)
{
return new ResultNoTime()
{
Result = "F", Description = "经销商异常"
}
}
;
string newlist = string.Empty;
List <int> intList = new List <int>();
List <Hi.Model.BD_CompNews> list = new Hi.BLL.BD_CompNews().GetList("", "ID in (" + IDlist + ") and (dr=1 or IsEnabled=0)", "");
if (list != null && list.Count > 0)
{
newlist = string.Join(",", list.Select(p => p.ID));
}
return(new ResultNoTime()
{
Result = "T", Description = "获取成功", DeleteMessageID = newlist
});
}
catch (Exception ex)
{
Common.CatchInfo(ex.Message + ":" + ex.StackTrace, "GetMessageDeleteId ：" + JSon);
return(new ResultNoTime()
{
Result = "F", Description = "参数异常"
});
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNewsTitle.Value.Trim()))
{
JScript.AlertMsgOne(this, "消息标题不能为空！", JScript.IconOption.错误);
return;
}
Hi.Model.BD_CompNews NewsNotice = null;
if (KeyID != 0)
{
NewsNotice = new Hi.BLL.BD_CompNews().GetModel(KeyID);
NewsNotice.NewsTitle = Common.NoHTML(txtNewsTitle.Value.Trim());
NewsNotice.NewsContents = content7.Text.Trim();
//是否启用
if (this.RdIsbled1.Checked)
{
NewsNotice.IsEnabled = 1;
}
else
{
NewsNotice.IsEnabled = 0;
}
//是否置顶
if (this.RdTop3.Checked)
{
NewsNotice.IsTop = 1;
}
else
{
NewsNotice.IsTop = 0;
}
//类别
if (this.RdType1.Checked)
{
NewsNotice.NewsType = 1;
}
else if (this.RdType2.Checked)
{
NewsNotice.NewsType = 2;
}
else if (this.RdType3.Checked)
{
NewsNotice.NewsType = 3;
}
else if (this.RdType4.Checked)
{
NewsNotice.NewsType = 4;
}
else if (this.RdType5.Checked)
{
NewsNotice.NewsType = 5;
}
string ShowType = "";
if (CkShowType1.Checked)
{
ShowType = "1";
}
if (CkShowType2.Checked)
{
if (ShowType == "")
{
ShowType = "2";
}
else
{
ShowType += "," + "2";
}
}
NewsNotice.ShowType = ShowType;
NewsNotice.ts = DateTime.Now;
NewsNotice.modifyuser = UserID;
if (new Hi.BLL.BD_CompNews().Update(NewsNotice))
{
if (this.RdTop3.Checked)
{
List <Hi.Model.BD_CompNews> CompNew = new Hi.BLL.BD_CompNews().GetList("", " isnull(dr,0)=0 and Compid=" + CompID + " and IsEnabled=1 and istop=1", " CreateDate desc");
if (CompNew.Count > 3)
{
for (int i = 0; i < CompNew.Count; i++)
{
if (i > 1 && CompNew[i].ID != NewsNotice.ID)
{
CompNew[i].IsTop = 0;
new Hi.BLL.BD_CompNews().Update(CompNew[i]);
}
}
}
}
//JScript.AlertMsgMo(this, "操作成功", "function(){ window.location.href='NewsInfo.aspx?KeyID=" + KeyID + "'; }");
Response.Redirect("NewsInfo.aspx?KeyID=" + KeyID);
}
}
else
{
NewsNotice = new Hi.Model.BD_CompNews();
NewsNotice.CompID = CompID;
NewsNotice.NewsTitle = Common.NoHTML(txtNewsTitle.Value.Trim());
NewsNotice.NewsContents = content7.Text.Trim();
//是否启用
if (this.RdIsbled1.Checked)
{
NewsNotice.IsEnabled = 1;
}
else
{
NewsNotice.IsEnabled = 0;
}
//是否置顶
if (this.RdTop3.Checked)
{
NewsNotice.IsTop = 1;
}
else
{
NewsNotice.IsTop = 0;
}
//类别
if (this.RdType1.Checked)
{
NewsNotice.NewsType = 1;
}
else if (this.RdType2.Checked)
{
NewsNotice.NewsType = 2;
}
else if (this.RdType3.Checked)
{
NewsNotice.NewsType = 3;
}
else if (this.RdType4.Checked)
{
NewsNotice.NewsType = 4;
}
else if (this.RdType5.Checked)
{
NewsNotice.NewsType = 5;
}
string ShowType = "";
if (CkShowType1.Checked)
{
ShowType = "1";
}
if (CkShowType2.Checked)
{
if (ShowType == "")
{
ShowType = "2";
}
else
{
ShowType += "," + "2";
}
}
NewsNotice.ShowType = ShowType;
//标准参数
NewsNotice.CreateDate = DateTime.Now;
NewsNotice.CreateUserID = UserID;
NewsNotice.ts = DateTime.Now;
NewsNotice.modifyuser = UserID;
int newsrid = 0;
newsrid = new Hi.BLL.BD_CompNews().Add(NewsNotice);
if (newsrid > 0)
{
WebReference.AppService app = new AppService();
try
{
app.MsgPush(newsrid.ToString(), "1");
}
catch
{
app.Abort();
}
if (this.RdTop3.Checked)
{
List <Hi.Model.BD_CompNews> CompNew = new Hi.BLL.BD_CompNews().GetList("", " isnull(dr,0)=0 and Compid=" + CompID + " and IsEnabled=1 and istop=1 and PMID=0", " createdate desc");
if (CompNew.Count > 3)
{
for (int i = 0; i < CompNew.Count; i++)
{
if (i > 1 && CompNew[i].ID != newsrid)
{
CompNew[i].IsTop = 0;
new Hi.BLL.BD_CompNews().Update(CompNew[i]);
}
}
}
}
Response.Redirect("NewsInfo.aspx?KeyID=" + newsrid);
}
}
}
public void Bind()
{
//首次进行页面清除Session
Session.Remove("GoodsPrice");
if (KeyID != 0)
{
string Digits = OrderInfoType.rdoOrderAudit("订单下单数量是否取整", CompID);
Hi.Model.BD_Promotion ProModel = ProBll.GetModel(KeyID);
//促销公告
List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID + "and isnull(IsEnabled,0)=1", "");
if (ProModel != null)
{
this.txtPromotiontitle.Value = ProModel.ProTitle;
this.txtPromotionDate.Value = ProModel.ProStartTime == DateTime.MinValue ? "" : ProModel.ProStartTime.ToString("yyyy-MM-dd");
this.txtPromotionDate1.Value = ProModel.ProEndTime == DateTime.MinValue ? "" : ProModel.ProEndTime.ToString("yyyy-MM-dd");
this.txtProInfos.Value = ProModel.ProInfos;
if (newsl != null && newsl.Count > 0)
{
this.isOkComNews.Checked = true;
this.isNoComNews.Checked = false;
}
else
{
this.isOkComNews.Checked = false;
this.isNoComNews.Checked = true;
}
//促销方式
if (ProModel.ProType == 3)
{
this.promotionType3.Checked = true;
this.txtSendFull.Value = string.Format("{0:N4}", ProModel.Discount.ToString("#,####" + Digits));
}
else
{
this.promotionType4.Checked = true;
this.txtDiscount.Value = string.Format("{0:N4}", ProModel.Discount.ToString("#,####" + Digits));
}
//促销禁用
if (ProModel.IsEnabled == 0)
{
this.IsEnabled0.Checked = true;
}
else
{
this.IsEnabled1.Checked = true;
}
decimal count = 0;
//促销活动商品明细
List <Hi.Model.BD_PromotionDetail> gl = ProDBll.GetList("", " CompId=" + this.CompID + " and ProID=" + KeyID, "");
if (gl != null && gl.Count > 0)
{
List <Hi.Model.BD_GoodsInfo> ll = new List <Hi.Model.BD_GoodsInfo>();
Hi.Model.BD_GoodsInfo model = null;
foreach (var item in gl)
{
model = new Hi.Model.BD_GoodsInfo();
model.CompID = this.CompID;
model.IsEnabled = true;
model.CreateUserID = this.UserID;
model.CreateDate = DateTime.Now;
model.ts = DateTime.Now;
model.modifyuser = this.UserID;
model.ID = item.GoodInfoID;
model.GoodsID = item.GoodsID;
model.SalePrice = GoodsPrice(item.GoodInfoID.ToString());
model.TinkerPrice = item.GoodsPrice; //促销价
count = item.GoodsPrice;
ll.Add(model);
}
if (ProModel.ProType == 3)
{
//满送
this.txtSendNum.Value = string.Format("{0:N4}", count.ToString("#,####" + Digits));
}
Session["GoodsPrice"] = ll;
this.rpDtl.DataSource = ll;
this.rpDtl.DataBind();
}
}
}
else
{
this.rpDtl.DataSource = "";
this.rpDtl.DataBind();
}
}
/// <summary>
/// 数据绑定
/// </summary>
private void Bind()
{
if (KeyID != 0)
{
Hi.Model.BD_Promotion ProModel = new Hi.BLL.BD_Promotion().GetModel(KeyID);
//促销公告
List <Hi.Model.BD_CompNews> newsl = new Hi.BLL.BD_CompNews().GetList("", " PMID=" + KeyID + "and isnull(IsEnabled,0)=1", "");
if (ProModel != null)
{
if (newsl != null && newsl.Count > 0)
{
this.isOkComNews.Checked = true;
this.isNoComNews.Checked = false;
}
else
{
this.isOkComNews.Checked = false;
this.isNoComNews.Checked = true;
}
this.txtPromotionDate.Value = ProModel.ProStartTime == DateTime.MinValue ? "" : ProModel.ProStartTime.ToString("yyyy-MM-dd");
this.txtPromotionDate1.Value = ProModel.ProEndTime == DateTime.MinValue ? "" : ProModel.ProEndTime.ToString("yyyy-MM-dd");
this.txtProInfos.Value = ProModel.ProInfos;
//促销禁用
if (ProModel.IsEnabled == 0)
{
this.IsEnabled0.Checked = true;
this.IsEnabled1.Checked = false;
}
else
{
this.IsEnabled0.Checked = false;
this.IsEnabled1.Checked = true;
}
List <Hi.Model.BD_PromotionDetail2> ll = new Hi.BLL.BD_PromotionDetail2().GetList("", "isnull(dr,0)=0 and proId=" + KeyID + " and compId=" + this.CompID, "");
if (ll.Count > 1)
{
this.Radio1.Checked = true;
this.Radio2.Checked = false;
}
else
{
this.Radio2.Checked = true;
this.Radio1.Checked = false;
}
string html = "";
if (ProModel.ProType == 5)
{
this.promotionType3.Checked = true;
this.promotionType4.Checked = false;
int z = 0;
foreach (Hi.Model.BD_PromotionDetail2 item in ll)
{
z++;
html += "<label>订单金额满￥<input type=\"text\" onkeyup='KeyInt2(this)' id=\"txtPrice" + z + "\" class=\"send txtPrice\" style=\"width: 50px;\" name=\"txtPrice\" value=\"" + item.OrderPrice.ToString("f2") + "\" />，立减￥<input type=\"text\" id=\"txtSendFull" + z + "\" onkeyup='KeyInt2(this)' class=\"send txtSendFull\" name=\"txtSendFull\" style=\"width: 50px;\" value=\"" + item.Discount.ToString("f2") + "\"/>";
if (z > 1)
{
html += "<a class=\"theme-color ml20 deleteItem\" href=\"javascript:;\">删除</a>";
}
html += "</label><br>";
}
this.SendFull.InnerHtml = html.Substring(0, html.LastIndexOf("<"));
}
else if (ProModel.ProType == 6)
{
this.promotionType4.Checked = true;
this.promotionType3.Checked = false;
int x = 0;
foreach (Hi.Model.BD_PromotionDetail2 item in ll)
{
x++;
html += "<label>订单金额满￥<input type=\"text\" onkeyup='KeyInt2(this)' id=\"txtPrices" + x + "\" class=\"send txtPrices\" style=\"width: 50px;\" name=\"txtPrices\" value=\"" + item.OrderPrice.ToString("f2") + "\"/>，打折（<input type=\"text\" id=\"txtDiscount" + x + "\" onkeyup='KeyInt2(this)' class=\"send txtDiscount\" name=\"txtDiscount\" style=\"width: 20px;\" value=\"" + Convert.ToInt32(item.Discount) + "\"/>）%";
if (x > 1)
{
html += "<a class=\"theme-color ml20 deleteItem\" href=\"javascript:;\">删除</a>";
}
html += "</label><br>";
}
this.Discount.InnerHtml = html.Substring(0, html.LastIndexOf("<"));
}
}
}
}
