/// <summary>
/// 通过openid查询是否已经注册
/// 1:已注册的可正常扫码的会员;
/// 0:未注册的会员;
/// -1:队员,不能扫码;
/// -2:已注册的岗位是调味品供货商的会员,不能扫码
/// </summary>
/// <param name="openid">微信openid</param>
/// <returns></returns>
public static int GetIsRegist(string openid)
{
// string sql = string.Format(@"SELECT b.UserType FROM dbo.RegistMember a JOIN dbo.OpenIdAssociated b
// ON a.MemberId = b.UserId
// WHERE b.OpenId = '{0}' order by b.UserType ", openid);
// var userType = SqlHelper2.ExecuteScalar(CommandType.Text, sql);
// //userType用户类型 1是队员 2是会员
// if (userType == null)
// {
// return 0;
// }
// else if (userType.ToString() == "1")
// {
// return -1;
// }
// else
// {
// return 1;
// }
string sql = string.Format(@"SELECT b.UserType,a.Position,c.JobType FROM dbo.RegistMember a
JOIN dbo.OpenIdAssociated b ON a.MemberId = b.UserId
LEFT JOIN dbo.MemberProfile c ON c.MemberId = a.MemberId
WHERE b.OpenId = '{0}' order by b.UserType
", openid);
DataTable dt = SqlHelper2.ExecuteDataTable(sql);
var userType = SqlHelper2.ExecuteScalar(CommandType.Text, sql);
//userType用户类型 1是队员 2是会员
if (dt.Rows.Count == 0) //未注册
{
return(0);
}
else if (dt.Rows[0]["UserType"].ToString() == "1") //是队员
{
return(-1);
}
else if (dt.Rows[0]["Position"].ToString() == "调味品供货商" || dt.Rows[0]["JobType"].ToString() == "调味品供货商") //会员岗位是调味品供货商
{
return(-2);
}
else //已经注册的 符合扫码条件的
{
return(1);
}
}
/// <summary>
/// 生成二维码
/// </summary>
/// <param name="number"></param>
/// <returns></returns>
public static string CreateQrCode(int number, int goodsid = 0)
{
//压缩包存储路径
var basePath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase;
var qrCodePath = Convert.ToString(ConfigurationManager.AppSettings["QrCodeStorePath"]);
var fileName = string.Format("{0}.xls", Guid.NewGuid().ToString());
var serverPath = qrCodePath + fileName;
var filePath = basePath + serverPath;
string sql = string.Format(@"INSERT INTO dbo.Hfh_RedPackQrCodePackage
( Num ,State )VALUES ({0},0)
Select @@Identity ", number);
var packageid = SqlHelper2.ExecuteScalar(CommandType.Text, sql);
string now = "";
string guid = "";
string safe = "beautiful";
string url = "";
string sn = "";
string code = "";
List <string> qrCodeList = new List <string>();
//生成二维码
for (int i = 1; i <= number; i++)
{
now = DateTime.Now.ToString("yyyyMMddHHmmssfff");
guid = Guid.NewGuid().ToString();
code = now.Substring(0, 8) + now.Substring(14) + packageid.ToString().PadLeft(10, '0') + Guid.NewGuid().ToString().Substring(0, 8);
sn = Confusion(code);
url = ConfigurationManager.AppSettings["QrCodeUrl"] + "?sn=" + sn;
sql = string.Format(@"INSERT INTO dbo.Hfh_RedPackQrCode
( QrcUrl , Code , State ,PackageId )
VALUES ( '{0}' , '{1}' , 1 , {2} )", url, code, packageid);
SqlHelper2.ExecuteNonQuery(CommandType.Text, sql);
qrCodeList.Add(url);
}
//生成Excel
ExcelExtend.SaveExcel <string>(qrCodeList, qrCodePath, fileName);
sql = "update Hfh_RedPackQrCodePackage set state =1,DownLoadUrl = '" + serverPath + "' where packageid = " + packageid.ToString();
SqlHelper2.ExecuteNonQuery(CommandType.Text, sql);
return("succ");
}