/// <summary>
/// 加载数据
/// </summary>
/// <param name="strWhere">条件</param>
void LoadData(string strWhere)
{
MSVAcctDetailDAL vcoinDal = new MSVAcctDetailDAL();
DataSet ds = vcoinDal.GetVaccdetail(strWhere);
DataView dv = ds.Tables[0].DefaultView;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dv;
pds.AllowPaging = true;
Repeater1.DataSource = pds;
Repeater1.DataBind();
if (custid != null && custid != "")
{
MSVAcctDAL vaccDal = new MSVAcctDAL();
try
{
vcoincount.Text = vaccDal.GetMSVAcct("V_Amont", custid).ToString();
}
catch (Exception)
{
}
}
}
void GetHtmlPage()
{
int vcoin = 0; int IsReceive = 0;
List <MSVAcctDetail> vcoindetaillist = new List <MSVAcctDetail>();
if (struid != null && struid != "")
{
MSVAcctDAL VAD = new MSVAcctDAL();
MSVAcctDetailDAL MVA = new MSVAcctDetailDAL();
#region -获取V币详细
//try
//{
// IsReceive = Convert.ToInt32(MVA.GetMSVAcctDetailByUID("IsReceive", struid).ToString());
//}
//catch (Exception)
//{
//}
try
{
vcoin = Convert.ToInt32(VAD.GetMSVAcct("V_Amont", struid).ToString());
}
catch (Exception)
{
}
//if (IsReceive == 0)
//{
// vcoin = 0;
//}
#endregion
#region -获取用户V币详情列表
string vcoinwhere = " Where CustID='" + struid + "' ";
DataSet detailds = MVA.GetMSVAcctDetailList(vcoinwhere);
if (detailds != null && detailds.Tables.Count > 0 && detailds.Tables[0].Rows.Count > 0)
{
foreach (DataRow item in detailds.Tables[0].Rows)
{
MSVAcctDetail vcoinmodel = DataConvert.DataRowToModel <MSVAcctDetail>(item);
vcoindetaillist.Add(vcoinmodel);
}
}
#endregion
}
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/Vcoin.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["errormsg"] = errormsg;
context.TempData["vcoin"] = vcoin;
context.TempData["vcoinlist"] = vcoindetaillist;
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
void PrintPhoto(string imgsrc)
{
string imgname = string.Empty;
string[] imgarray = imgsrc.Split('.');
imgname = imgarray[0];
string openid = string.Empty;
if (userid != null && userid != "")
{
MSCustomersDAL customerDal = new MSCustomersDAL();
try
{
openid = customerDal.GetCustomerValueByID("OpenID", userid).ToString();
}
catch (Exception)
{
}
}
if (openid == null || openid == "")
{
openid = strID;
}
DAL.HP.PhotoDAL dalPhoto = new DAL.HP.PhotoDAL();
//照片处理
strSFilePath = "../../PalmShop/ShopCode/" + imgsrc;
strFilePath = imgsrc;
string[] urls = strSFilePath.Split('.');
string _url = openid + "." + urls.Last();
string saveurl = "../../HP_Photo/";
saveurl = Server.MapPath(saveurl);
if (!Directory.Exists(saveurl))
{
Directory.CreateDirectory(saveurl);
}
string inputurl = Server.MapPath("../../PalmShop/ShopCode/") + strFilePath;
string outputurl = Server.MapPath("../../HP_Photo/") + _url;
int width = 260;
int height = 310;
System.IO.FileStream fs = new System.IO.FileStream(inputurl, System.IO.FileMode.Open);
//ZoomAuto(fs, outputurl,width, height, "", "");
CutForCustom(fs, outputurl, width, height, 100);
fs.Close();
string SiteCode = "VYIGO";
if (Session["strSiteCode"].ToString() != null && Session["strSiteCode"].ToString() != "")
{
SiteCode = Session["strSiteCode"].ToString();
}
// DAL.HP.PrintCodeDAL dalPrintCode = new DAL.HP.PrintCodeDAL();
// DataSet printds = dalPrintCode.AddPrintCode(1, SiteCode,"0000", "2014-01-01", "2019-12-31");
//string strPID = string.Empty;
//if (printds != null && printds.Tables.Count > 0 && printds.Tables[0].Rows.Count > 0)
//{
// strPID = printds.Tables[0].Rows[0]["ID"].ToString();
//}
string strPID = Guid.NewGuid().ToString("N");
Model.HP.Photo modelPhoto = new Model.HP.Photo()
{
ID = strPID,
OpenId = openid,
SiteCode = SiteCode,
ClientID = "WSY01",
PrintCode = "1111",
Img = openid + "." + imgsrc.Split('.').Last(),
AttachText = AttachText.Text + "\r\n"
};
dalPhoto.InsertInfo(modelPhoto);
//插入V币记录
if (userid != null && userid != "" && strPID != null && strPID != "")
{
int award = GetAwardChance();
MSVAcct msvModel = new MSVAcct();
MSVAcctDAL msvDal = new MSVAcctDAL();
MSVAcctDetail msvdetailModel = new MSVAcctDetail();
MSVAcctDetailDAL msvdetailDal = new MSVAcctDetailDAL();
if (!msvDal.ExistMSVAcct(userid, SiteCode))
{
msvModel.CustID = userid;
msvModel.SiteCode = SiteCode;
msvModel.V_Amont = award;
msvDal.AddMSVAcct(msvModel);
}
else
{
int count = Convert.ToInt32(msvDal.GetMSVAcct("V_Amont", userid).ToString());
count = count + award;
msvModel.CustID = userid;
msvModel.SiteCode = SiteCode;
msvModel.V_Amont = count;
msvDal.UpdateMSVAcct(msvModel);
}
msvdetailModel.CustID = userid;
msvdetailModel.Amount = award;
msvdetailModel.ChargeType = "首次购物";
msvdetailModel.Ext_Fld1 = strPID;
msvdetailModel.SiteCode = SiteCode;
msvdetailDal.AddMSVAcctDetail(msvdetailModel);
}
//插入活动券
if (!string.IsNullOrEmpty(openid))
{
string strGuid = Guid.NewGuid().ToString("N");
DAL.ACT.CouponDAL cdal = new DAL.ACT.CouponDAL();
if (!cdal.ExistCoupon(SiteCode, "56DBFD79AFF94FD6B0FE7E72CE7589E6", openid))
{
Model.ACT.Coupon coupon = null;
coupon = new Model.ACT.Coupon()
{
ID = strGuid,
SiteCode = SiteCode,
SiteActivityID = "56DBFD79AFF94FD6B0FE7E72CE7589E6",
OpenID = openid,
CouponStatus = 0
};
cdal.InsertInfo(coupon);
}
}
}