public ActionResult AddMeeting(string Name, string BegTime, float Duration, string UserName) { try { int rCount = 0; string errorinfo = String.Empty; string guid = String.Empty; PublicDao pPublicDao = new PublicDao(); bool isb = true; DataSet ds = new DataSet(); //string UserID = Session["LoginUID"].ToString(); string UserID = ""; isb = pPublicDao.TransactionAddMeeting(Name, BegTime, Duration, UserName, UserID, ref guid, ref rCount, ref errorinfo); if (isb == true) { //生成二维码 QRCode pQRCode = new QRCode(); pQRCode.CreateQRCode(ConfigurationManager.AppSettings["hyqbUrl"] + "/HYQD/EndSignIn?mid=" + guid, guid); return(Content("提交成功!")); } else { return(Content(errorinfo)); //return Content("提交失败!"); } } catch (Exception ex) { return(Content(ex.Message.ToString())); } }
public ActionResult AddEndSignIn(string UserName, string Q1, string Q2, string Q3, string Q4, string Q5) { int rCount = 0; string errorinfo = String.Empty; string guid = String.Empty; PublicDao pPublicDao = new PublicDao(); bool isb = true; DataSet ds = new DataSet(); string mID = String.Empty; if (Session["EndSignIn_mID"] != null) { mID = Session["EndSignIn_mID"].ToString(); } isb = pPublicDao.TransactionAddEndSignIn(mID, UserName, Q1, Q2, Q3, Q4, Q5, ref rCount, ref errorinfo); if (isb == true) { //生成二维码 QRCode pQRCode = new QRCode(); pQRCode.CreateQRCode(ConfigurationManager.AppSettings["hyqbUrl"] + "/HYQD/EndSignIn?mid=" + guid, guid); return(Content("提交成功!")); } else { return(Content(errorinfo)); //return Content("提交失败!"); } }
public void CreateQRCode(string id, string fieldCode, string text, string title = "") { string folder = GetQRCodePath(); Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("ID", id + "_" + fieldCode); dic.Add("Title", title); dic.Add("Text", text); string logo = folder + "logo.png"; QRCode.CreateQRCode(folder + "QRCode/", dic, logo, true, false); }
public ActionResult DownLoadPosters(int id) { try { ViewData["CustomerName"] = CustomerName(); ViewData["WeixinUser"] = WeiXinUser(); var customerId = CustomerId().ToString(); LogManager.GetLogger().Info("customerId:" + customerId); var productLine = ProductLine.FindById(id); ViewData["ProductLine"] = productLine; var imgUrl1 = (!string.IsNullOrEmpty(productLine.WeChatAdUrl) ? (ConstValue.SysConfig.BossImgUrl + productLine.WeChatAdUrl.Split(',')[0]) : ""); if (!string.IsNullOrEmpty(imgUrl1)) { System.Net.WebClient myWebClient = new System.Net.WebClient(); //将头像保存到服务器 var virPath = "/Uploads/temp/"; var fileName = Guid.NewGuid().ToString("N") + ".png"; myWebClient.DownloadFile(imgUrl1, System.Web.HttpContext.Current.Request.PhysicalApplicationPath + virPath + fileName); ViewData["ImgUrl1"] = virPath + fileName; } else { ViewData["ImgUrl1"] = ""; } var url = ConstValue.SysConfig.ImgUrl + "/Home/Product/Index?lineId=" + id + "&uId=" + CustomerId(); LogManager.GetLogger().Info("DownLoadPosters-Url:" + url); #region 生成二维码 var content = url; var size = Convert.ToInt32(string.IsNullOrEmpty(Request.QueryString["size"]) ? "200" : Request.QueryString["size"]); var border = Convert.ToInt32(string.IsNullOrEmpty(Request.QueryString["border"]) ? "10" : Request.QueryString["border"]); var image = QRCode.CreateQRCode(content, QRCodeEncoder.ENCODE_MODE.BYTE, QRCodeEncoder.ERROR_CORRECTION.M, 0, 5, size, border); //将图片输出到页面 var ms = new System.IO.MemoryStream(); image.Save(ms, System.Drawing.Imaging.ImageFormat.Png); var imgUrl = ""; var strPath = Server.MapPath("~/Uploads"); //保存图片到目录 if (Directory.Exists(strPath)) { //文件名称 var guid = Guid.NewGuid().ToString().Replace("-", "") + ".png"; image.Save(strPath + "/" + guid, System.Drawing.Imaging.ImageFormat.Png); imgUrl = "/Uploads/" + guid; } else { //当前目录不存在,则创建 Directory.CreateDirectory(strPath); } ms.Close(); ms = null; image.Dispose(); image = null; ViewData["ImgUrl"] = imgUrl; #endregion } catch (Exception ex) { LogManager.GetLogger().Error(ex); } return(View()); }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance"); string id = lbCouponId.Text.Trim(); string coupId = id; string couponType = ddlCouponType.SelectedValue; decimal value = 0; decimal.TryParse(txtValue.Text, out value); string context = txtContext.Text; DateTime startTime = DateTime.Now; DateTime.TryParse(hfStart.Value, out startTime); DateTime endTime = DateTime.Now; DateTime.TryParse(hfEnd.Value, out endTime); int couponDay = int.Parse(this.txtDay.Text.Trim()); string qrCode = QRCodeUrl.ImageUrl; int isPost = cbQF.Checked ? 1 : 0; string postObject = ddlMember.SelectedValue; string getPlaceInfo = this.ddlGetPlaceInfo.SelectedValue; decimal minPrice = decimal.Parse(this.txtMinPrice.Text.Trim()); DataTable dt = new DataTable(); int index = 1; if (couponType == "DJ") { string strMem = "select memberId,tel from T_Member_Info "; if (postObject == "new") { strMem += " where memberId,tel not in (select memberId from T_Base_Coupon);"; } DataSet ds = adoHelper.ExecuteSqlDataset(strMem); if (ds != null || ds.Tables.Count < 1 || ds.Tables[0].Rows.Count < 1) { dt = ds.Tables[0]; } index = ds.Tables[0].Rows.Count; } string cid = (lbCouponId.Text).Trim(); int effect = cbEffect.Checked ? 1 : 0; int use = lbUse.Text == "已使用"?1:0; string remark = txtRemark.Text; string couponCode = id; StringBuilder strSql = new StringBuilder(); if (couponId == "") { int success = 0; int fail = 0; for (int i = 0; i < index; i++) { string memberId = ""; if (dt.Rows.Count > 0) { memberId = dt.Rows[i][0].ToString(); } coupId = id + i.ToString().PadLeft(6, '0'); if (couponType == "CZ") { cid = "http://" + System.Web.Configuration.WebConfigurationManager.AppSettings["coupon"].ToString() + "/Coupon.aspx?type=CZ&cid=" + coupId; QRCode qrc = new QRCode(cid); qrCode = qrc.CreateQRCode(); QRCodeUrl.ImageUrl = qrCode; } strSql.Clear(); strSql.Append("insert into T_Base_Coupon("); strSql.Append("CouponId,CouponType,CouponValue,Context,StartTime,EndTime,QRCodeUrl,isEffect,isUse,Remark,isPost,postObject,CouponCode,MemberId,CouponDay,GetPlaceInfo,minPrice)"); strSql.Append(" values ("); strSql.Append("@CouponId,@CouponType,@CouponValue,@Context,@StartTime,@EndTime,@QRCodeUrl,@isEffect,@isUse,@Remark,@isPost,@postObject,@CouponCode,@MemberId,@CouponDay,@GetPlaceInfo,@minPrice)"); SqlParameter[] parameters = { new SqlParameter("@CouponId", SqlDbType.VarChar), new SqlParameter("@CouponType", SqlDbType.VarChar), new SqlParameter("@CouponValue", SqlDbType.Decimal), new SqlParameter("@Context", SqlDbType.VarChar), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@QRCodeUrl", SqlDbType.VarChar), new SqlParameter("@isEffect", SqlDbType.Int), new SqlParameter("@isUse", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.VarChar), new SqlParameter("@isPost", SqlDbType.Int), new SqlParameter("@postObject", SqlDbType.VarChar), new SqlParameter("@CouponCode", SqlDbType.VarChar), new SqlParameter("@MemberId", SqlDbType.VarChar), new SqlParameter("@CouponDay", SqlDbType.Int), new SqlParameter("@GetPlaceInfo", SqlDbType.VarChar), new SqlParameter("@minPrice", SqlDbType.Decimal) }; parameters[0].Value = coupId;; parameters[1].Value = couponType; parameters[2].Value = value; parameters[3].Value = context; parameters[4].Value = startTime; parameters[5].Value = endTime; parameters[6].Value = qrCode; parameters[7].Value = effect; parameters[8].Value = use; parameters[9].Value = remark; parameters[10].Value = isPost; parameters[11].Value = postObject; parameters[12].Value = couponCode; parameters[13].Value = memberId; parameters[14].Value = couponDay; parameters[15].Value = getPlaceInfo; parameters[16].Value = minPrice; int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (rows > 0) { if (isPost == 1) { new MobileInfo().GetMess(dt.Rows[i][1].ToString(), context); } success++; //this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>"); couponId = id; } else { fail++; } } //LogAdd.CreateLog(Session["UserId"].ToString(), "添加优惠卷“" + context + "共" + success + "张”", "添加", "", "", Request.Url.ToString()); this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('成功添加优惠卷设置');layer_close_refresh();</script>"); } else { //if (couponType == "CZ") // cid = "http://" + System.Web.Configuration.WebConfigurationManager.AppSettings["coupon"].ToString() + "/Coupon.aspx?type=DJ&cid=" + cid; //QRCode qrc = new QRCode(cid); //qrCode = qrc.CreateQRCode(); //QRCodeUrl.ImageUrl = qrCode; //StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Base_Coupon set "); strSql.Append("CouponType=@CouponType,CouponValue=@CouponValue,Context=@Context,StartTime=@StartTime,EndTime=@EndTime,QRCodeUrl=@QRCodeUrl,isEffect=@isEffect,isUse=@isUse,Remark=@Remark,isPost=@isPost,postObject=@postObject,CouponDay=@CouponDay,GetPlaceInfo=@GetPlaceInfo,minPrice=@minPrice "); strSql.Append(" where CouponId=@CouponId"); strSql.Append(""); SqlParameter[] parameters = { //new SqlParameter("@CouponId", SqlDbType.VarChar,50), new SqlParameter("@CouponType", SqlDbType.VarChar, 50), new SqlParameter("@CouponValue", SqlDbType.Int, 4), new SqlParameter("@Context", SqlDbType.VarChar, 50), new SqlParameter("@StartTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@QRCodeUrl", SqlDbType.VarChar), new SqlParameter("@isEffect", SqlDbType.Int), new SqlParameter("@isUse", SqlDbType.Int), new SqlParameter("@Remark", SqlDbType.VarChar), new SqlParameter("@isPost", SqlDbType.Int), new SqlParameter("@postObject", SqlDbType.VarChar), new SqlParameter("@CouponDay", SqlDbType.Int), new SqlParameter("@CouponId", SqlDbType.VarChar), new SqlParameter("@GetPlaceInfo", SqlDbType.VarChar), new SqlParameter("@minPrice", SqlDbType.Decimal) }; parameters[0].Value = couponType; parameters[1].Value = value; parameters[2].Value = context; parameters[3].Value = startTime; parameters[4].Value = endTime; parameters[5].Value = qrCode; parameters[6].Value = effect; parameters[7].Value = use; parameters[8].Value = remark; parameters[9].Value = isPost; parameters[10].Value = postObject; parameters[11].Value = couponDay; parameters[12].Value = id; parameters[12].Value = getPlaceInfo; parameters[13].Value = minPrice; int rows = adoHelper.ExecuteSqlNonQuery(strSql.ToString(), parameters); if (rows > 0) { //LogAdd.CreateLog(Session["UserId"].ToString(), "修改优惠卷“" + context + "”", "修改", "", "", Request.Url.ToString()); this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); GetData(); } } }