/// <summary> /// ServicesLog /// </summary> /// <param name="actionType"></param> /// <param name="logInfo"></param> public void WXPushLog(string actionType, string logInfo) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_WXServicePush_Log("); strSql.Append("sysnumber,logTime,actionType,logInfo,MsgType,Event)"); strSql.Append(" values ("); strSql.Append("@sysnumber,@logTime,@actionType,@logInfo,@MsgType,@Event)"); SqlParameter[] parameters = { new SqlParameter("@sysnumber", SqlDbType.VarChar, 50), new SqlParameter("@logTime", SqlDbType.DateTime), new SqlParameter("@actionType", SqlDbType.VarChar, 50), new SqlParameter("@logInfo", SqlDbType.Text), new SqlParameter("@MsgType", SqlDbType.VarChar, 50), new SqlParameter("@Event", SqlDbType.VarChar, 50), }; parameters[0].Value = Guid.NewGuid().ToString(); parameters[1].Value = DateTime.Now; parameters[2].Value = actionType; parameters[3].Value = logInfo; parameters[4].Value = GetMsgField(logInfo, "MsgType"); parameters[5].Value = GetMsgField(logInfo, "Event"); StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); }
/// <summary> /// 更新任务表中的自定义集合字段(把所有自定义字段拼接成一个大字符串保存) /// </summary> protected void UpdateGoodsTable(string goodsId) { string info = ""; StarTech.DBUtility.AdoHelper ado = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance); DataSet ds = ado.ExecuteSqlDataset("select * from T_Goods_MoreProperty where goodsId='" + this.id + "'"); DataSet dsSet = ado.ExecuteSqlDataset("select * from T_Goods_MorePropertySet"); foreach (DataRow row in ds.Tables[0].Rows) { DataRow[] rowsSet = dsSet.Tables[0].Select("PropertyId='" + row["PropertyId"].ToString() + "'"); if (rowsSet.Length > 0) { info += "{" + row["PropertyId"].ToString() + "$" + rowsSet[0]["propertyName"].ToString() + "$" + row["PropertyValue"].ToString().Replace("'", "’") + "}"; } } ado.ExecuteSqlNonQuery("update T_Goods_Info set MorePropertys='" + info + "' where goodsId='" + goodsId + "'"); }
protected void btnSave_Click(object sender, EventArgs e) { if (Request["MorePropertyId_AllIds"] != null && Request["MorePropertyId_AllIds"] != "") { StarTech.DBUtility.AdoHelper ado = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance); ado.ExecuteSqlNonQuery("delete T_Goods_MoreProperty where goodsId='" + this.id + "'"); foreach (string s in Request["MorePropertyId_AllIds"].Split(',')) { if (Request[s] != null) { string k = s.Replace("MorePropertyId_", ""); string v = Request[s]; string sqladd = "insert into T_Goods_MoreProperty(sysnumber,GoodsId,PropertyId,PropertyValue)"; sqladd += "values('" + Guid.NewGuid().ToString() + "','" + this.id + "','" + k + "','" + v + "')"; ado.ExecuteSqlNonQuery(sqladd); } } UpdateGoodsTable(this.id); } ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('保存成功');window.returnValue=1;window.close();</script>"); }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { GoodsTypeModel mod; if (this.id != "" && this.id != null) { mod = bll.GetModel(this.id); } else { mod = new GoodsTypeModel(); } string pPath = ""; string[] codeList = this.cSelect.hfCode.Split('|'); StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); if (codeList.Length < 1 || cSelect.hfCode == "") { mod.PCategoryId = ""; mod.CategoryLevel = 1; mod.CategoryPath = mod.CategoryId; } else { //if(this.cSelect.categoryID) mod.PCategoryId = codeList[codeList.Length - 1]; DataSet ds = adoHelper.ExecuteSqlDataset("select * from T_Info_Category where categoryid='" + KillSqlIn.Form_ReplaceByString(mod.PCategoryId, 20) + "';"); mod.CategoryLevel = Convert.ToInt32(ds.Tables[0].Rows[0]["CategoryLevel"].ToString()) + 1; pPath = ds.Tables[0].Rows[0]["CategoryPath"].ToString(); } if (pPath != "") { pPath += ","; } mod.CategoryName = this.txtMenuName.Text.Trim(); //mod.CategoryPath= //mod.Remarks = this.txtRemarks.Text.Trim(); int orderdy = 0; int.TryParse(this.txtSort.Text.Trim(), out orderdy); mod.Orderby = orderdy; mod.CategoryFlag = (this.cbIsVisible.Checked == true) ? "Course" : "Category"; if (fuImg.FileName != null && fuImg.FileName != "") { //mod.Url = fuImg.FileName; string nowUrl = Guid.NewGuid().ToString(); string tzm = fuImg.FileName.Substring(fuImg.FileName.LastIndexOf(".")); string url = "/upload/Category/" + nowUrl + "" + tzm; fuImg.SaveAs(Server.MapPath("~" + url)); mod.Url = url; } if (this.id != "" && this.id != null) { if (this.id == mod.PCategoryId) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('上级分类不能选择当前分类');layer_close_refresh();</script>"); return; } mod.CategoryPath = pPath + mod.CategoryId; if (bll.Update(mod)) { LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "修改任务分类《" + mod.CategoryName + "》", "修改", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { mod.CategoryId = IdCreator.CreateId("T_Info_Category", "CategoryId"); mod.CategoryPath = pPath + mod.CategoryId; bll.Add(mod); LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "添加任务分类《" + mod.CategoryName + "》;", "添加", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>"); //JSUtility.ReplaceOpenerParentWindow("menuTree.aspx"); } //ModMenu detail = new ModMenu(); //detail.menuName = this.txtMenuName.Text.Trim(); //detail.menuTarget = this.txtMenuLink.Text.Trim(); //detail.isShow = (this.cbIsVisible.Checked == true ? 1 : 0); //detail.orderIndex = Convert.ToInt32(this.txtSort.Text.Trim()); //detail.parentMenuId = Convert.ToInt32(this.cSelect.categoryID); //if (this._menuId != null) //{ // int menuId = Convert.ToInt32(this._menuId); // detail.uniqueId = menuId; // this._menu.Update(detail); // ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); //} //else //{ // this._menu.Add(detail); // ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>"); // //JSUtility.ReplaceOpenerParentWindow("menuTree.aspx"); //} }
/// <summary> /// 邦定推广用户的公众号 /// </summary> /// <param name="MsgType"></param> /// <param name="wxMsg"></param> /// <returns></returns> public void BindUser(string MsgType, string wxMsg) { /* * <xml> * <ToUserName><![CDATA[gh_384b77007ac6]]></ToUserName> * <FromUserName><![CDATA[oKiw2t92-9nwoTj4QXgMiAb1fsnQ]]></FromUserName> * <CreateTime>1519282100</CreateTime> * <MsgType><![CDATA[event]]></MsgType> * <Event><![CDATA[subscribe]]></Event> * <EventKey><![CDATA[qrscene_oKiw2t92-9nwoTj4QXgMiAb1fsnQ]]></EventKey> * <Ticket><![CDATA[gQGJ8TwAAAAAAAAAAS5odHRwOi8vd2VpeGluLnFxLmNvbS9xLzAyTWJFbzFrR0k4U1QxMDAwMGcwNy0AAgT4Zo5aAwQAAAAA]]></Ticket> * </xml> */ if (MsgType == "event") { string Event = GetMsgField(wxMsg, "Event"); //if (Event == "subscribe" || Event == "SCAN") if (Event == "subscribe") { //邦定推广用户的公众号 string myOpenId = GetMsgField(wxMsg, "EventKey").Replace("qrscene_", ""); string firendNewOpenId = GetMsgField(wxMsg, "FromUserName"); JObject userObj = NG.WeiXin.NGWeiXinUser.GetUserInfoByOpenId(firendNewOpenId); string nickname = userObj == null ? "" : userObj["nickname"].ToString(); string sex = userObj == null ? "" : userObj["sex"].ToString(); string headimgurl = userObj == null ? "" : userObj["headimgurl"].ToString(); //入库 StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_WXQRCodeShare_Log("); strSql.Append("sysnumber,logTime,myOpenId,firendNewOpenId,firendNewNickname,firendNewSex,firendNewHeader,scanInfo,remarks)"); strSql.Append(" values ("); strSql.Append("@sysnumber,@logTime,@myOpenId,@firendNewOpenId,@firendNewNickname,@firendNewSex,@firendNewHeader,@scanInfo,@remarks)"); SqlParameter[] parameters = { new SqlParameter("@sysnumber", SqlDbType.VarChar, 50), new SqlParameter("@logTime", SqlDbType.DateTime), new SqlParameter("@myOpenId", SqlDbType.VarChar, 50), new SqlParameter("@firendNewOpenId", SqlDbType.VarChar, 50), new SqlParameter("@firendNewNickname", SqlDbType.VarChar, 50), new SqlParameter("@firendNewSex", SqlDbType.VarChar, 50), new SqlParameter("@firendNewHeader", SqlDbType.VarChar, 500), new SqlParameter("@scanInfo", SqlDbType.VarChar, 4000), new SqlParameter("@remarks", SqlDbType.VarChar, 500), }; parameters[0].Value = Guid.NewGuid().ToString(); parameters[1].Value = DateTime.Now; parameters[2].Value = myOpenId; parameters[3].Value = firendNewOpenId; parameters[4].Value = nickname; parameters[5].Value = sex; parameters[6].Value = headimgurl; parameters[7].Value = wxMsg; parameters[8].Value = "我的二维码推广"; StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); //消息通知分享推广人 if (myOpenId != "") { WXSendShare(myOpenId, nickname); } //赠送优惠券 if (myOpenId != "") { object objMemberId = adoHelper.ExecuteSqlScalar("select MemberId from T_Member_Info where WXOpenId='" + myOpenId + "'"); if (objMemberId != null) { GetCouponShareBat(objMemberId.ToString()); } } } } }