/// <summary>
/// 检查商家和当前用户的绑定
/// </summary>
/// <param name="MerId"></param>
/// <returns></returns>
public bool CheckBindMer(decimal MerId)
{
BLL.UserBLL bll = new UserBLL();
string UserId = "";
try
{
UserId = bll.CurrentUserId();
}
catch
{
Common.PageInput.ToLogin("");
}
BLL.MerchantBLL mbll = new MerchantBLL();
DataSet ds = mbll.GetMerVsUser(" MerchantId='" + MerId + "' and UserId='" + UserId + "' ");
if (ds.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public MerSetting(decimal MerId)
{
BLL.MerchantBLL bll = new MerchantBLL();
// CheckBindMer(MerId);
ds_Mer = bll.GetMerInfo(MerId);
BindMerTypeSelectOpHtml();
}
public ActionResult SavePIN(string AccountId, string NewPIN)
{
MerchantBLL ab = new MerchantBLL();
MerchantAccounts account = FiiiPayDB.MerchantAccountDb.GetById(AccountId);
account.PIN = PasswordHasher.HashPassword(NewPIN);
return(Json(ab.UpdatePIN(account, UserId, UserName).toJson()));
}
public ActionResult DownloadZh()
{
string merchantId = Request.Form["QRCodeMerchantId"];
MerchantAccount merchant = new MerchantBLL().GetById(new Guid(merchantId));
string strCode = FiiiPay.Framework.Component.QRCode.Generate(SystemPlatform.FiiiPOS, QRCodeEnum.MerchantScanPay, merchant.Id.ToString());
QRCodeGenerator qrGenerator = new QRCoder.QRCodeGenerator();
QRCodeData qrCodeData = qrGenerator.CreateQrCode(strCode, QRCodeGenerator.ECCLevel.Q);
QRCoder.QRCode qrcode = new QRCoder.QRCode(qrCodeData);
Bitmap qrCodeImage = qrcode.GetGraphic(17, Color.Black, Color.White, null, 15, 6, false);
MemoryStream ms = new MemoryStream();
qrCodeImage.Save(ms, ImageFormat.Jpeg);
string bgImagePath = @"E:\API\BackOffice\FiiiPay.BackOffice\images\bg-zh.jpg";
List <ImageMergeEntity> imgs = new List <ImageMergeEntity>();
var bm = new Bitmap(bgImagePath);
imgs.Add(new ImageMergeEntity
{
ContentType = ImageContentType.Image,
Image = new Bitmap(bgImagePath),
Index = 0
});
imgs.Add(new ImageMergeEntity
{
ContentType = ImageContentType.Image,
Image = new Bitmap(ms),
Index = 0,
X = 300,
Y = 620,
AreaHeight = 650,
AreaWidth = 650
});
imgs.Add(new ImageMergeEntity
{
ContentType = ImageContentType.Text,
Text = merchant.MerchantName,
FontSize = 50,
FontColor = Color.Black,
Index = 4,
X = 220,
Y = 1310,
AreaHeight = 80,
AreaWidth = 785
});
var imgByte = ImageHelper.ImageMerge(imgs.ToArray());
Response.ContentType = "application/octet-stream";
//通知浏览器下载文件而不是打开
Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(merchantId + ".jpg", System.Text.Encoding.UTF8));
Response.BinaryWrite(imgByte);
Response.Flush();
return(null);
}
public void ProcessRequest(HttpContext context)
{
string merchantId = context.Request.QueryString["id"];
MerchantAccount merchant = new MerchantBLL().GetById(new Guid(merchantId));
string strCode = FiiiPay.Framework.Component.QRCode.Generate(SystemPlatform.FiiiPOS, QRCodeEnum.MerchantScanPay, merchant.Id.ToString());
QRCodeGenerator qrGenerator = new QRCoder.QRCodeGenerator();
QRCodeData qrCodeData = qrGenerator.CreateQrCode(strCode, QRCodeGenerator.ECCLevel.Q);
QRCoder.QRCode qrcode = new QRCoder.QRCode(qrCodeData);
Bitmap qrCodeImage = qrcode.GetGraphic(17, Color.Black, Color.White, null, 15, 6, false);
MemoryStream ms = new MemoryStream();
qrCodeImage.Save(ms, ImageFormat.Jpeg);
string bgImagePath = Path.Combine(System.AppDomain.CurrentDomain.BaseDirectory + "/images/bg-en.jpg");
List <ImageMergeEntity> imgs = new List <ImageMergeEntity>();
var bm = new Bitmap(bgImagePath);
imgs.Add(new ImageMergeEntity
{
ContentType = ImageContentType.Image,
Image = new Bitmap(bgImagePath),
Index = 0
});
imgs.Add(new ImageMergeEntity
{
ContentType = ImageContentType.Image,
Image = new Bitmap(ms),
Index = 0,
X = 300,
Y = 620,
AreaHeight = 650,
AreaWidth = 650
});
imgs.Add(new ImageMergeEntity
{
ContentType = ImageContentType.Text,
Text = merchant.MerchantName.Length > 10 ? merchant.MerchantName.Substring(0, 8) + "..." : merchant.MerchantName,
FontSize = 48,
FontColor = Color.Black,
Index = 4,
X = 220,
Y = 1310,
AreaHeight = 80,
AreaWidth = 785
});
var imgByte = ImageHelper.ImageMerge(imgs.ToArray());
context.Response.ContentType = "image/jpeg";
context.Response.BinaryWrite(imgByte);
context.Response.End();
}
protected string LoadAllPendingSmvRequestOfCurrentDate(string FromDate, string Todate)
{
string table = "";
try
{
table = new MerchantBLL().LoadAllPendingSmvRequestOfCurrentDate(FromDate, Todate);
}
catch (Exception ex)
{
}
return(table);
}
protected string GetMerchantInfo(int loadMerchantId)
{
string merchantTable = "";
MerchantBLL merchantBLL = new MerchantBLL();
try
{
merchantTable = merchantBLL.GetMerchantInfo(loadMerchantId);
}
catch (Exception ex)
{
}
return(merchantTable);
}
public void BindMerTypeSelectOpHtml()
{
BLL.MerchantBLL bll = new MerchantBLL();
DataTable dt = bll.GetMerType(0).Tables[0];
StringBuilder w = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
w.Append("<option value='" + dr["MerchantTypeId"] + "' >");
w.Append(dr["MerchantTypeName"]);
w.Append("</option>");
}
MerTypeSelectOpHtml = w.ToString();
}
public string LoadMerchantRequest(int userId)
{
string InfoTable = "";
MerchantBLL merchantBll = new MerchantBLL();
try
{
InfoTable = merchantBll.LoadMerchantRequest(userId);
return(InfoTable);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 检查商家的绑定, 要求页面必须具备商家编号"MerId"
/// </summary>
public void CheckMerBind(decimal MerId)
{
BLL.UserBLL ubll = new UserBLL();
MerchantBLL bll = new MerchantBLL();
MyUserId = ubll.CurrentUserId();
DataSet ds = DAL.DalComm.BackData(" select * from dbo.UserMerRoleView with(nolock) where UserId='" + MyUserId + "' and MerId= " + MerId + "");
if (ds.Tables[0].Rows.Count == 0)
{ //这个用户没有这个商家的绑定权限, 这下你大了.
if (ubll.IsAdministrator())
{
//如果你是超级管理员, 仍没有问题.
}
else
{
HttpContext.Current.Response.Write("您是否确定您已经绑定了这个商家?");
HttpContext.Current.Response.End();
}
}
}
public ActionResult SaveNewCellphone(Guid MerchantId, int NewCountryId, string NewCellphone)
{
var sr = new MerchantBLL().ChangeCellphone(this.UserId, this.UserName, MerchantId, NewCountryId, NewCellphone);
return(Json(sr.toJson()));
}
public ActionResult SaveSN(Guid merchantId, string newSN)
{
MerchantBLL mb = new MerchantBLL();
return(Json(mb.Rebind(merchantId, newSN, UserId, UserName).toJson()));
}
public ActionResult Unbind(Guid id)
{
MerchantBLL mb = new MerchantBLL();
return(Json(mb.Unbind(id, UserId, UserName).toJson()));
}
protected void submitButton_Click(object sender, EventArgs e)
{
MerchantBLL merchantBLL = new MerchantBLL();
MerchantModel merchant = new MerchantModel();
DataTable dt = null;
try
{
merchant.MerchantName = merchantNameTextBox.Text;
merchant.LoginId = loginIdTextBox.Text;
merchant.Password = paswordTextBox.Text;
merchant.ConfirmPassword = confirmPasswordTextBox.Text;
merchant.IsActive = Convert.ToInt32(isAcctiveDropDownList.SelectedValue);
if (merchant.Password == merchant.ConfirmPassword)
{
if (merchantId == 0)
{
merchant.PostedBy = Convert.ToInt32(userId);
dt = merchantBLL.InsertNewMerchant(merchant);
if (dt.Rows.Count > 0)
{
bool DbMerchant = Convert.ToBoolean(dt.Rows[0]["Merchant"]);
if (DbMerchant)
{
messageLabel.Text = "<p Style ='font-size:20px;color:Red; margin-top:20px;'>Already Exists</p>";
}
else
{
messageLabel.Text = "<p Style ='font-size:20px;color:Green; margin-top:20px;'>New Information Successfully Inserted</p>";
}
}
table = GetMerchantInfo(merchantId);
}
else
{
merchant.UpdatedBy = Convert.ToInt32(userId);
merchant.MerchantId = merchantId;
int actionResult = 0;
actionResult = merchantBLL.UpdateMerchantInfo(merchant);
if (actionResult > 0)
{
messageLabel.Text = "<p Style ='font-size:20px;color:Green; margin-top:20px;'> Information Successfully Updated</p>";
table = GetMerchantInfo(merchantId);
}
else
{
messageLabel.Text = "<p Style ='font-size:20px;color:Red; margin-top:20px;'>Already Exists</p>";
}
}
}
else
{
messageLabel.Text = "<p Style ='font-size:20px;color:Red; margin-top:20px;'>Password Dose Not Match!</p>";
}
}
catch (Exception ex)
{
}
}
public ActionResult DeleteErrorCount(Guid id, string type)
{
MerchantBLL ab = new MerchantBLL();
return(Json(ab.DeleteErrorCount(id, type, UserId, UserName).toJson()));
}
/// <summary>
/// 回复逻辑
/// </summary>
/// <param name="MsgXml"></param>
public string SendEvent(XmlElement rootElement)
{
RequestXML MsgXml = new RequestXML();
MsgXml.MsgType = rootElement.SelectSingleNode("MsgType").InnerText;
MsgXml.ToUserName = rootElement.SelectSingleNode("ToUserName").InnerText;
MsgXml.FromUserName = rootElement.SelectSingleNode("FromUserName").InnerText;
MsgXml.CreateTime = rootElement.SelectSingleNode("CreateTime").InnerText;
MsgXml.KeyTypeId = MsgXml.MsgType;
StringBuilder s = new StringBuilder();
StringBuilder c = new StringBuilder();
BLL.MerchantBLL mbll = new MerchantBLL();
s.Append(" select * from dbo.MemberView with(nolock) where WxOpenId='" + MsgXml.FromUserName + "' and Invalid=0 and YuanShiId='" + MsgXml.ToUserName + "' ");
s.Append(" SELECT * FROM dbo.WxPtView with(nolock) WHERE YuanShiId='" + MsgXml.ToUserName + "' AND Invalid=0 ");
DataSet dsMember = DAL.DalComm.BackData(s.ToString());
DataTable dtWxPt = dsMember.Tables[1];
if (dtWxPt.Rows.Count != 1)
{
throw new Exception(" 原始ID为'" + MsgXml.ToUserName + "'数量是'" + dtWxPt.Rows.Count + "'! 请联系管理员:qq19278765 ");
}
DataRow drWxPt = dtWxPt.Rows[0];
DataRow drMember;
if (dsMember.Tables[0].Rows.Count > 0)
{
drMember = dsMember.Tables[0].Rows[0];
//更改最后操作时间
DAL.DalComm.ExReInt(" Update dbo.Member set LastTime='" + DateTime.Now + "' where MemberId='" + drMember["MemberId"] + "' ");
}
else
{
//首次关注,添加
Model.MemberModel MemberModel = new MemberModel();
MemberModel.Birthday = DateTime.Parse("1900-01-01");
MemberModel.CreateTime = DateTime.Now;
MemberModel.LastTime = DateTime.Now;
MemberModel.Email = "";
MemberModel.WxPtId = decimal.Parse(drWxPt["WxPtId"].ToString());
MemberModel.WxOpenId = MsgXml.FromUserName;
DAL.MemberDAL mbDal = new DAL.MemberDAL();
mbDal.Add(MemberModel);
int codeSize = 8 - MemberModel.MemberId.ToString().Length;
MemberModel.MemberCode = MemberModel.MemberId.ToString();
for (int i = 0; i < codeSize; i++)
{
MemberModel.MemberCode = "0" + MemberModel.MemberCode; //补齐前位的0,填充会员卡号
}
DataSet ds_ls = DAL.DalComm.BackData(" Update dbo.Member set MemberCode='" + MemberModel.MemberCode + "' where MemberId='" + MemberModel.MemberId + "' select * from dbo.MemberView with(nolock) where MemberId='" + MemberModel.MemberId + "' UPDATE dbo.Member SET MerId=(SELECT TOP 1 dbo.WxPtInfo.MerId FROM dbo.WxPtInfo WHERE WxPtId=member.WxPtId ) WHERE MerId=0 ");
drMember = ds_ls.Tables[0].Rows[0];
}
s.Clear();
switch (MsgXml.MsgType.ToLower())
{
case "event":
MsgXml.KeyTypeDetailId = rootElement.SelectSingleNode("Event").InnerText; //按钮 click
MsgXml.KeyTitle = GetMsgNodeValue(rootElement, "EventKey", "");
break;
case "voice": //如果是语音消息
MsgXml.KeyTitle = rootElement.SelectSingleNode("Recognition").InnerText; //语音识别内容
break;
case "text": //如果是文本消息
MsgXml.KeyTitle = rootElement.SelectSingleNode("Content").InnerText;
#region 系统功能(例如派送订单确认)
#region 派送订单确认
//如果输入了全部订单号, 或者以小数点开头输入了部分订单
if (MsgXml.KeyTitle.Trim().Length == 20 || MsgXml.KeyTitle.Trim().Substring(0, 1) == ".")
{
return(QueakSend(MsgXml, mbll.QueRenDingDan(MsgXml.KeyTitle, MsgXml.FromUserName, "")));
}
#endregion
#endregion
break;
case "image": //如果是图片消息
MsgXml.KeyTitle = "";
break;
}
#region 判断是否快捷会员公共方法
if (MsgXml.KeyTitle.ToLower() == "quickcard")
{
return(MyMemberQuickCard(MsgXml));
}
#endregion
s.Append(" SELECT * FROM CORE.dbo.WxKeyView with(nolock) WHERE YuanShiId='" + MsgXml.ToUserName + "' AND KeyTypeId='" + MsgXml.MsgType.ToLower() + "' ");
s.Append(" and WxSendInvalid=0 and WxPtInvalid=0 ");
if (MsgXml.KeyTitle != "")
{
s.Append(" AND KeyTitle='" + MsgXml.KeyTitle + "' ");
}
if (MsgXml.KeyTypeDetailId != "")
{
s.Append(" AND KeyTypeDetailId='" + MsgXml.KeyTypeDetailId + "' ");
}
DataSet ds = DAL.DalComm.BackData(s.ToString());
DataTable dtKey = ds.Tables[0];
if (dtKey.Rows.Count > 0)
{
DataRow drKey = dtKey.Rows[0];
string SendContent = Common.StringPlus.WxSendStr(HttpUtility.UrlDecode(drKey["SendContent"].ToString()));
switch (drKey["WxSendClassId"].ToString())
{
case "1": //快速文本回复
return(QueakSend(MsgXml, SendContent));
break;
case "5": //素材回复
string WxSuCaiId = drKey["WxSuCaiId"].ToString();
s.Clear();
s.Append(" select * from dbo.WxSuCaiInfo Where WxSuCaiInfoId='" + WxSuCaiId + "' ");
s.Append(" select * from dbo.WxSuCaiDetailView where WxSuCaiInfoId='" + WxSuCaiId + "' ");
DataSet dsSuCai = DAL.DalComm.BackData(s.ToString());
DataTable dtSuCaiInfo = dsSuCai.Tables[0];
if (dtSuCaiInfo.Rows.Count == 0)
{
throw new Exception("没有找到对应的素材!");
}
DataRow drSuCaiInfo = dtSuCaiInfo.Rows[0];
switch (drSuCaiInfo["WxSuCaiClassId"].ToString())
{
case "1": //文本素材
return(QueakSend(MsgXml, drSuCaiInfo["WxSuCaiContent"].ToString()));
break;
case "2": //图文素材
DataTable dtSuCaiDetail = dsSuCai.Tables[1];
return(ImgTextSend(MsgXml, dtSuCaiDetail));
break;
}
break;
}
}
else
{
}
return("");
}
