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();
}
}
}
