void showdetailinfo()
{
MSCustomersDAL CustomerDal = new MSCustomersDAL();
DataSet ds = CustomerDal.GetCustomerDetail(strID);
MSCustomers CustomerModel = DataConvert.DataRowToModel <MSCustomers>(ds.Tables[0].Rows[0]);
phone.Text = CustomerModel.Phone;
hd_content.Value = CustomerModel.Pnote;
NickName.Text = CustomerModel.NickName;
email.Text = CustomerModel.Email;
QQnum.Text = CustomerModel.QQnum;
if (CustomerModel.HeadImg != null && CustomerModel.HeadImg != "")
{
img0.Src = "../../PalmShop/ShopCode/" + CustomerModel.HeadImg;
oldimg = CustomerModel.HeadImg;
}
if (CustomerModel.Sex == 0)
{
isstateyes.Checked = true;
}
else
{
isstateno.Checked = true;
}
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
}
}
/// <summary>
/// 客户信息更改
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateCustomers(MSCustomers model)
{
string safeslq = "";
safeslq = "UPDATE MS_Customers SET ";
if (model.NickName != null && model.NickName != "")
{
safeslq += "NickName='" + model.NickName + "',";
}
if (model.RealName != null && model.RealName != "")
{
safeslq += "RealName='" + model.RealName + "',";
}
if (model.IDnum != null && model.IDnum != "")
{
safeslq += "IDnum='" + model.IDnum + "',";
}
if (model.IDimg != null && model.IDimg != "")
{
safeslq += "IDimg='" + model.IDimg + "',";
}
if (model.Phone != null && model.Phone != "")
{
safeslq += "Phone='" + model.Phone + "',";
}
if (model.UserPwd != null && model.UserPwd.ToString() != "")
{
safeslq += "UserPwd='" + model.UserPwd + "',";
}
if (model.Email != null && model.Email.ToString() != "")
{
safeslq += "Email='" + model.Email + "',";
}
if (model.QQnum != null && model.QQnum.ToString() != "")
{
safeslq += "QQnum='" + model.QQnum + "',";
}
if (model.HeadImg != null && model.HeadImg != "")
{
safeslq += "HeadImg='" + model.HeadImg + "',";
}
if (model.Pnote != null && model.Pnote != "")
{
safeslq += "Pnote='" + model.Pnote + "',";
}
safeslq += " Sex=" + (model.Sex == 1 ? 1 : 0) + ", ";
safeslq += " IsDel=" + (model.IsDel == 1 ? 1 : 0) + " ";
safeslq += " where ID='" + model.ID + "'";
int rowsAffected = DbHelperSQL.ExecuteSql(safeslq.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
void GetHtmlPage()
{
MSShop shopModel = new MSShop();
MSCustomers UserModel = new MSCustomers();
#region -----------------店铺详情-----------------------
if (strSID != null && strSID != "")
{
MSShopDAL shopDal = new MSShopDAL();
DataSet shopds = shopDal.GetMSShopDetail(strSID);
if (shopds != null && shopds.Tables.Count > 0 && shopds.Tables[0].Rows.Count > 0)
{
shopModel = DataConvert.DataRowToModel <MSShop>(shopds.Tables[0].Rows[0]);
}
}
#endregion
#region ---------------店铺用户资料详情--------------------
if (strUid != null && strUid != "")
{
MSCustomersDAL UserDal = new MSCustomersDAL();
DataSet userds = UserDal.GetCustomerDetail(strUid);
if (userds != null && userds.Tables.Count > 0 && userds.Tables[0].Rows.Count > 0)
{
UserModel = DataConvert.DataRowToModel <MSCustomers>(userds.Tables[0].Rows[0]);
}
}
#endregion
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/ApplyShop.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["footer"] = "奥琦微商易";
context.TempData["errorscript"] = errorscript;
context.TempData["shopdetail"] = shopModel;
context.TempData["usredetail"] = UserModel;
context.TempData["action"] = action;
context.TempData["sid"] = strSID;
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
/// <summary>
/// 客户信息添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddCustomers(MSCustomers model)
{
string sql = @"INSERT INTO [MS_Customers]
([ID],[OpenID],[NickName],[RealName],[IDnum],[IDimg],[Phone],[UserPwd],[Email],[QQnum],[HeadImg],[Sex],[Pnote],[IsDel],[AddTime])
VALUES
(@ID,@OpenID,@NickName,@RealName,@IDnum,@IDimg,@Phone,@UserPwd,@Email,@QQnum,@HeadImg,@Sex,@Pnote,@IsDel,@AddTime)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@OpenID", model.OpenID),
new System.Data.SqlClient.SqlParameter("@NickName", model.NickName),
new System.Data.SqlClient.SqlParameter("@RealName", model.RealName),
new System.Data.SqlClient.SqlParameter("@IDnum", model.IDnum),
new System.Data.SqlClient.SqlParameter("@IDimg", model.IDimg),
new System.Data.SqlClient.SqlParameter("@Phone", model.Phone),
new System.Data.SqlClient.SqlParameter("@UserPwd", model.UserPwd),
new System.Data.SqlClient.SqlParameter("@Email", model.Email),
new System.Data.SqlClient.SqlParameter("@QQnum", model.QQnum),
new System.Data.SqlClient.SqlParameter("@HeadImg", model.HeadImg),
new System.Data.SqlClient.SqlParameter("@Sex", (model.Sex == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@Pnote", model.Pnote),
new System.Data.SqlClient.SqlParameter("@IsDel", (model.IsDel == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
void getTemplate()
{
#region --------------获取客户详细-----------------
MSCustomers customerModel = new MSCustomers();
MSCustomersDAL customerDal = new MSCustomersDAL();
DataSet customerDs = customerDal.GetCustomerDetail(strUid);
if (null != customerDs && customerDs.Tables.Count > 0 && customerDs.Tables[0].Rows.Count > 0)
{
customerModel = DataConvert.DataRowToModel <MSCustomers>(customerDs.Tables[0].Rows[0]);
if (customerModel.HeadImg != null && customerModel.HeadImg != "")
{
oldimgname = customerModel.HeadImg;
}
}
#endregion
string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/customerinfo.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
context.TempData["customer"] = customerModel;
context.TempData["errorscript"] = errorscript;
context.TempData["fid"] = strfid;
context.TempData["footer"] = "奥琦微商易";
t.Render(Response.Output);
}
/// <summary>
/// 用户注册
/// </summary>
void ToSaveUserInfo()
{
string inputphone = string.Empty; string logpwd = string.Empty;
if (Request["inputphone"] != null && Request["inputphone"] != "")
{
inputphone = Common.Common.NoHtml(Request["inputphone"]);
}
if (Request["logpwd"] != null && Request["logpwd"] != "")
{
logpwd = Common.Common.NoHtml(Request["logpwd"]);
}
if (inputphone.Trim() != null && inputphone.Trim() != "" && logpwd.Trim() != null && logpwd.Trim() != "")
{
MSCustomersDAL customerDal = new MSCustomersDAL();
if (customerDal.ExistCustomer(strOpenID, inputphone, "", ""))
{
Response.Write("{\"error\":true,\"msg\":\"该用户已经存在\"}");
}
else
{
MSCustomers customerModel = new MSCustomers();
string strID = string.Empty;
strID = Guid.NewGuid().ToString("N").ToUpper();
customerModel.ID = strID;
customerModel.Phone = inputphone;
customerModel.OpenID = strOpenID;
customerModel.NickName = regNickName;
customerModel.Sex = regSex;
customerModel.HeadImg = regHeadImg;
customerModel.UserPwd = Common.Common.MD5(logpwd);
customerModel.IsDel = 0;
MSVAcctDetailDAL vacctdetailDal = new MSVAcctDetailDAL();
MSVAcctDAL vacctDal = new MSVAcctDAL();
if (customerDal.AddCustomers(customerModel))
{
int vcount = 2;
if (!vacctDal.ExistMSVAcct(strID, ""))
{
MSVAcct vaccModel = new MSVAcct();
vaccModel.CustID = strID;
vaccModel.SiteCode = "VYIGO";
vaccModel.V_Amont = vcount;
MSVAcctDetail vaccDetailModel = new MSVAcctDetail();
vaccDetailModel.Amount = vcount;
vaccDetailModel.ChargeType = "注册";
vaccDetailModel.CustID = strID;
vaccDetailModel.Ext_Fld1 = "";
vaccDetailModel.IsReceive = 1;
vaccDetailModel.SiteCode = "VYIGO";
//vacctDal.AddMSVAcct(vaccModel);
//vacctdetailDal.AddMSVAcctDetail(vaccDetailModel);
}
Response.Write("{\"success\":true,\"msg\":\"操作成功\"}");
}
else
{
Response.Write("{\"error\":true,\"msg\":\"操作失败，请核对后再操作\"}");
}
}
}
Response.End();
}
void editeCustomerinfo()
{
string nickname = string.Empty; string modelimgurl = string.Empty;
try
{
nickname = HttpContext.Current.Request.Form.Get("nickname").ToString();
}
catch (Exception)
{
nickname = "";
}
MSCustomers customerModel = new MSCustomers();
MSCustomersDAL customerDal = new MSCustomersDAL();
customerModel.ID = strUid;
if (nickname != null && nickname != "")
{
#region -----------------头像上传-------------------
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count > 0)
{
//检查文件扩展名字
HttpPostedFile postedFile = files[0];
string fileName, fileExtension, file_oldid, file_id;
//取出精确到毫秒的时间做文件的名称
string my_file_id = DateTime.Now.ToString("yyyyMMddHHmmssfff");
fileName = System.IO.Path.GetFileName(postedFile.FileName);
fileExtension = System.IO.Path.GetExtension(fileName);
file_id = my_file_id + fileExtension;
if (fileName != "" && fileName != null && fileName.Length > 0)
{
fileExtension = System.IO.Path.GetExtension(fileName);
string saveurl;
modelimgurl = "HeadImg/";
saveurl = "../PalmShop/ShopCode/" + modelimgurl;
saveurl = Server.MapPath(saveurl);
if (!Directory.Exists(saveurl))
{
Directory.CreateDirectory(saveurl);
}
int length = postedFile.ContentLength;
if (length > 512000)
{
file_oldid = "old" + file_id;
postedFile.SaveAs(saveurl + file_oldid);
JQDialog.ystp(saveurl + file_oldid, saveurl + file_id, 15);
File.Delete(saveurl + file_oldid);
}
else
{
postedFile.SaveAs(saveurl + file_id);
}
modelimgurl = modelimgurl + file_id;
}
}
#endregion
customerModel.NickName = nickname;
if (modelimgurl != null && modelimgurl != "")
{
customerModel.HeadImg = modelimgurl;
}
customerModel.IsDel = 0;
if (customerDal.UpdateCustomers(customerModel))
{
if (modelimgurl != null && modelimgurl != "")
{
if (oldimgname != null && oldimgname != "")
{
File.Delete(String.Format(@"{0}PalmShop/ShopCode/{1}",
Server.MapPath("~"), oldimgname));
}
}
errorscript = JQDialog.alertOKMsgBox(3, "操作成功", "MyTopicList.aspx?fid=" + strfid,
"succeed");
}
else
{
errorscript = JQDialog.alertOKMsgBox(3, "操作失败，请核对后再操作", "Customerinfo.aspx?fid=" + strfid,
"error");
}
}
else
{
errorscript = JQDialog.alertOKMsgBox(3, "操作失败，请核对后再操作",
"Customerinfo.aspx?fid=" + strfid, "error");
}
}
void GetProductDetail()
{
string ptitle = string.Empty;
string shopID = string.Empty;
string puid = string.Empty;
int paracount = 0;
#region 产品详细
MSProductDAL productDal = new MSProductDAL();
MSProduct productModel = new MSProduct();
DataSet productds = productDal.GetProductDetail(strpid);
if (null != productds && productds.Tables.Count > 0 && productds.Tables[0].Rows.Count > 0)
{
productModel = DataConvert.DataRowToModel <MSProduct>(productds.Tables[0].Rows[0]);
ptitle = productModel.Ptitle;
puid = productModel.CustomerID;
if (productModel.SID != null && productModel.SID != "")
{
shopID = productModel.SID;
}
}
#endregion
#region 店铺详细
MSShop shopModel = new MSShop();
if (shopID != null && shopID != "")
{
MSShopDAL shopDal = new MSShopDAL();
DataSet shopds = shopDal.GetMSShopDetail(shopID);
if (shopds != null && shopds.Tables.Count > 0 && shopds.Tables[0].Rows.Count > 0)
{
shopModel = DataConvert.DataRowToModel <MSShop>(shopds.Tables[0].Rows[0]);
}
}
#endregion
#region 图集列表
MSProductAtlasDAL atlasDal = new MSProductAtlasDAL();
List <MSProductAtlas> AtlasListModel = new List <MSProductAtlas>();
DataSet atlasds = atlasDal.GetProductAtlasByPID(strpid);
if (null != atlasds && atlasds.Tables.Count > 0 && atlasds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in atlasds.Tables[0].Rows)
{
MSProductAtlas atlasModel = DataConvert.DataRowToModel <MSProductAtlas>(row);
AtlasListModel.Add(atlasModel);
}
}
#endregion
#region 产品参数列表
//MSProductParaDAL paraDal = new MSProductParaDAL();
//DataSet paramds = paraDal.GetProductParamByPID(strpid);
//string paramlist = string.Empty;
//if (null != paramds && paramds.Tables.Count > 0 && paramds.Tables[0].Rows.Count > 0)
//{
// for (int i = 0; i < paramds.Tables[0].Rows.Count; i++)
// {
// paramlist += "<tr>\r\n";
// string paraname = paramds.Tables[0].Rows[i]["ParName"].ToString();
// string paravalue = paramds.Tables[0].Rows[i]["ParValue"].ToString();
// paramlist += "<td class=\"td_title\">" + paraname + "</td><td>" + paravalue + "</td>\r\n";
// try
// {
// i = i + 1;
// paraname = paramds.Tables[0].Rows[i]["ParName"].ToString();
// paravalue = paramds.Tables[0].Rows[i]["ParValue"].ToString();
// paramlist += "<td class=\"td_title\">" + paraname + "</td><td>" + paravalue + "</td>\r\n";
// }
// catch (Exception)
// {
// paramlist += "<td class=\"td_title\"> </td><td> </td>\r\n";
// }
// paramlist += "</tr>\r\n";
// }
//}
#endregion
#region -------获取产品型号及价格------------
ProductPara ParaModel = new ProductPara();
List <MSProductPara> paralistmodel = new List <MSProductPara>();
MSProductParaDAL paraDal = new MSProductParaDAL();
DataSet parads = paraDal.GetMaxMinPrice(strpid);
if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
{
paracount = parads.Tables[0].Rows.Count;
ParaModel = DataConvert.DataRowToModel <ProductPara>(parads.Tables[0].Rows[0]);
}
parads = null;
parads = paraDal.GetProductParamByPID(strpid);
if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
{
foreach (DataRow item in parads.Tables[0].Rows)
{
MSProductPara paramodel = DataConvert.DataRowToModel <MSProductPara>(item);
paralistmodel.Add(paramodel);
}
}
#endregion
#region ----------------根据产品编号获取联系方式--------------------
MSShopContactsDAL contactDal = new MSShopContactsDAL();
MSShopContacts contactModel = new MSShopContacts();
DataSet contactDs = contactDal.GetContactDetailByPID(strpid);
MSCustomersDAL CustomerDal = new MSCustomersDAL();
MSCustomers CustomerModel = new MSCustomers();
DataSet PuidDs = null; int contactcount = 0;
if (contactDs != null && contactDs.Tables.Count > 0 && contactDs.Tables[0].Rows.Count > 0)
{
contactModel = DataConvert.DataRowToModel <MSShopContacts>(contactDs.Tables[0].Rows[0]);
contactcount = 1;
}
else
{
if (puid != null && puid != "")
{
PuidDs = CustomerDal.GetCustomerDetail(puid);
}
if (PuidDs != null && PuidDs.Tables.Count > 0 && PuidDs.Tables[0].Rows.Count > 0)
{
CustomerModel = DataConvert.DataRowToModel <MSCustomers>(PuidDs.Tables[0].Rows[0]);
}
}
#endregion
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/Product_detail.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["title"] = ptitle;
if (shopModel != null)
{
context.TempData["shopdetail"] = shopModel;
}
context.TempData["productdetail"] = productModel;
context.TempData["atlaslist"] = AtlasListModel;
if (contactcount > 0)
{
context.TempData["contactdetail"] = contactModel;
}
else
{
context.TempData["contactdetail"] = CustomerModel;
}
context.TempData["customid"] = customid;
//context.TempData["paramlist"] = paramlist;
context.TempData["paracount"] = paracount;
context.TempData["paramodel"] = ParaModel;
context.TempData["paralist"] = paralistmodel;
context.TempData["footer"] = "奥琦微商易";
context.TempData["errorscript"] = errorscript;
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
/// <summary>
/// 获取购物信息
/// </summary>
void GetInfo()
{
#region 产品详细
MSProductDAL productDal = new MSProductDAL();
MSProduct productModel = new MSProduct();
DataSet productds = productDal.GetProductDetail(strpid);
MSProductAtlasDAL atlasDal = new MSProductAtlasDAL();
MSProductAtlas atlasdetailmodel = null;
DataSet atlasDs = null;
if (null != productds && productds.Tables.Count > 0 && productds.Tables[0].Rows.Count > 0)
{
productModel = DataConvert.DataRowToModel <MSProduct>(productds.Tables[0].Rows[0]);
}
#endregion
#region 获取产品默认展示图
atlasDs = atlasDal.GetDefaultAtlasByPid(strpid);
foreach (DataRow atlasrow in atlasDs.Tables[0].Rows)
{
atlasdetailmodel = DataConvert.DataRowToModel <MSProductAtlas>(atlasrow);
}
#endregion
#region -----------获取型号尺码----------------
MSProductPara paraModel = new MSProductPara();
MSProductParaDAL paraDal = new MSProductParaDAL();
DataSet parads = paraDal.GetParaDetail(mid);
if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0)
{
paraModel = DataConvert.DataRowToModel <MSProductPara>(parads.Tables[0].Rows[0]);
}
#endregion
#region 获取收货地址
MSDeliveryAddressDAL addressDal = new MSDeliveryAddressDAL();
MSDeliveryAddress defaultadModel = new MSDeliveryAddress();
List <MSDeliveryAddress> damodellist = new List <MSDeliveryAddress>();
string stradwhere = string.Empty;
stradwhere = "and [UID]='" + customid + "' ";
DataSet addressds = addressDal.GetDAList(3, stradwhere);
if (null != addressds && addressds.Tables.Count > 0 && addressds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in addressds.Tables[0].Rows)
{
MSDeliveryAddress damodel = DataConvert.DataRowToModel <MSDeliveryAddress>(row);
damodellist.Add(damodel);
}
}
#endregion
string customerphone = string.Empty;
MSCustomers customerModel = new MSCustomers();
if (customid != null && customid != "")
{
MSCustomersDAL CustomerDal = new MSCustomersDAL();
DataSet customerds = CustomerDal.GetCustomerDetail(customid);
if (customerds != null && customerds.Tables.Count > 0 && customerds.Tables[0].Rows.Count > 0)
{
customerModel = DataConvert.DataRowToModel <MSCustomers>(customerds.Tables[0].Rows[0]);
}
}
string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/setOrder.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["productdetail"] = productModel;
context.TempData["atlas"] = atlasdetailmodel;
context.TempData["paramodel"] = paraModel;
context.TempData["errorscript"] = errorscript;
context.TempData["dalist"] = damodellist;
context.TempData["customer"] = customerModel;
context.TempData["openid"] = openid;
context.TempData["footer"] = "奥琦微商易";
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
void getTemplate()
{
#region -----------获取客户信息---------
MSCustomers CustomerModel = new MSCustomers();
MSCustomersDAL CustomerDal = new MSCustomersDAL();
DataSet CustomerDs;
if (strUid != null && strUid != "")
{
CustomerDs = CustomerDal.GetCustomerDetail(strUid);
if (null != CustomerDs && CustomerDs.Tables.Count > 0 && CustomerDs.Tables[0].Rows.Count > 0)
{
CustomerModel = DataConvert.DataRowToModel <MSCustomers>(CustomerDs.Tables[0].Rows[0]);
if (CustomerModel.NickName == null || CustomerModel.NickName == "" ||
CustomerModel.NickName.ToLower() == "null")
{
CustomerModel.NickName = "游客";
}
}
}
#endregion
#region ----------获取帖子列表----------------
MSForumTopicDAL topicDal = new MSForumTopicDAL();
List <TopicModelList> topicModellist = new List <TopicModelList>();
int topicCount = 0;
DataSet topiclistds = topicDal.GetMSForumTopicList(" and a.[UID]='" + strUid + "' ", 0);
if (topiclistds != null && topiclistds.Tables.Count > 0 && topiclistds.Tables[0].Rows.Count > 0)
{
topicCount = topiclistds.Tables[0].Rows.Count;
foreach (DataRow row in topiclistds.Tables[0].Rows)
{
TopicModelList topicmodel = DataConvert.DataRowToModel <TopicModelList>(row);
if (topicmodel.NickName == null || topicmodel.NickName == "" || topicmodel.NickName.Length < 1)
{
topicmodel.NickName = "游客";
}
if (topicmodel.HeadImg == null || topicmodel.HeadImg == "")
{
topicmodel.HeadImg = "images/2.png";
}
string msg = topicmodel.TopicDesc;
msg = JQDialog.GetTextFromHTML(msg);
if (msg.Length > 250)
{
msg = msg.ToString().Substring(0, 100) + "...";
}
topicmodel.TopicDesc = msg;
topicModellist.Add(topicmodel);
}
}
#endregion
#region --------------获取喜欢 总数------------------
int likecount = 0;
MSForumTopicLoveDAL likeDal = new MSForumTopicLoveDAL();
try
{
likecount = likeDal.GetLoveOrLikeCountByUID(strUid, "tlike");
}
catch (Exception)
{
likecount = 0;
}
#endregion
#region ------------获取消息总数---------------
int msgcount = 0;
MSForumCommentDAL commentDal = new MSForumCommentDAL();
try
{
msgcount = commentDal.GetCommentCountByUID(strUid);
}
catch (Exception)
{
msgcount = 0;
}
#endregion
string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/othertopiclist.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
context.TempData["mytopiclist"] = topicModellist;
context.TempData["topiccount"] = topicCount;
context.TempData["customer"] = CustomerModel;
context.TempData["fid"] = strfid;
context.TempData["likecount"] = likecount;
context.TempData["msgcount"] = msgcount;
context.TempData["errorscript"] = errorscript;
context.TempData["uid"] = strUid;
context.TempData["myuid"] = strMyUid;
context.TempData["footer"] = "奥琦微商易";
t.Render(Response.Output);
}
public void getTemplate()
{
#region -----------获取客户信息---------
MSCustomers CustomerModel = new MSCustomers();
MSCustomersDAL CustomerDal = new MSCustomersDAL();
DataSet CustomerDs;
if (strUid != null && strUid != "")
{
CustomerDs = CustomerDal.GetCustomerDetail(strUid);
if (null != CustomerDs && CustomerDs.Tables.Count > 0 && CustomerDs.Tables[0].Rows.Count > 0)
{
CustomerModel = DataConvert.DataRowToModel <MSCustomers>(CustomerDs.Tables[0].Rows[0]);
if (CustomerModel.NickName == null || CustomerModel.NickName == "" ||
CustomerModel.NickName.ToLower() == "null")
{
CustomerModel.NickName = "游客";
}
}
}
#endregion
#region ---------评论列表以及信息回复------------
List <CommentListGetSet> commentModelList = new List <CommentListGetSet>();
MSForumCommentDAL commentDal = new MSForumCommentDAL();
DataSet commentDs = commentDal.GetCommentList(" and a.[uid]='" + strUid + "' ");
DataSet repcommentds;
List <CommentListGetSet> repcommentModelList = new List <CommentListGetSet>();
int commentcount = 0;
if (commentDs != null && commentDs.Tables.Count > 0 && commentDs.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in commentDs.Tables[0].Rows)
{
CommentListGetSet commentModel = DataConvert.DataRowToModel <CommentListGetSet>(row);
if (commentModel.NickName == null || commentModel.NickName == "")
{
commentModel.NickName = "游客";
}
#region ----------------获取回复信息-----------------------
string repid = commentModel.ID;
repcommentds = commentDal.GetRepCommentList(" and a.[uid]='" + strUid + "' and a.UpID='" + repid + "' ");
if (repcommentds != null && repcommentds.Tables.Count > 0 && repcommentds.Tables[0].Rows.Count > 0)
{
foreach (DataRow reprow in repcommentds.Tables[0].Rows)
{
CommentListGetSet repcommentModel = DataConvert.DataRowToModel <CommentListGetSet>(reprow);
if (repcommentModel.NickName == null || repcommentModel.NickName == "")
{
repcommentModel.NickName = "游客";
}
repcommentModelList.Add(repcommentModel);
}
}
#endregion
commentModelList.Add(commentModel);
}
}
try
{
commentcount = commentDs.Tables[0].Rows.Count;
}
catch (Exception)
{
commentcount = 0;
}
#endregion
#region --------------获取喜欢 总数------------------
int likecount = 0;
MSForumTopicLoveDAL likeDal = new MSForumTopicLoveDAL();
try
{
likecount = likeDal.GetLoveOrLikeCountByUID(strUid, "tlike");
}
catch (Exception)
{
likecount = 0;
}
#endregion
#region ------------获取消息总数---------------
int msgcount = 0;
try
{
msgcount = commentDal.GetCommentCountByUID(strUid);
}
catch (Exception)
{
msgcount = 0;
}
#endregion
#region ---------帖子总数-------------
int topiccount = 0;
MSForumTopicDAL topicdal = new MSForumTopicDAL();
try
{
topiccount = topicdal.GetTopicCountByUID(strUid);
}
catch (Exception)
{
topiccount = 0;
}
#endregion
string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/Mycommentlist.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
context.TempData["customer"] = CustomerModel;
context.TempData["commentlist"] = commentModelList;
context.TempData["repcommentlist"] = repcommentModelList;
context.TempData["fid"] = strfid;
context.TempData["likecount"] = likecount;
context.TempData["msgcount"] = msgcount;
context.TempData["topiccount"] = topiccount;
context.TempData["errorscript"] = errorscript;
context.TempData["uid"] = strUid;
context.TempData["footer"] = "奥琦微商易";
t.Render(Response.Output);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Session["strLoginName"].ToString() != null && Session["strLoginName"].ToString() != "")
{
if (phone.Text.Trim() != null && phone.Text.Trim() != "" &&
password.Text.Trim() != null && password.Text.Trim() != "" &&
NickName.Text.Trim() != null && NickName.Text.Trim() != "")
{
//上传图像
string strIconFileName = string.Empty; //图像路径
string strIconSaveFileName = string.Empty; //网址路径
try
{
if (this.file0.PostedFile.FileName == "")
{
strIconSaveFileName = "";
}
else
{
if (!System.IO.Directory.Exists(Server.MapPath("~") + @"/PalmShop"))
{
System.IO.Directory.CreateDirectory(Server.MapPath("~") + @"/PalmShop");
}
if (!System.IO.Directory.Exists(String.Format(@"{0}/PalmShop/ShopCode/HeadImg/{1}", Server.MapPath("~"), phone.Text)))
{
System.IO.Directory.CreateDirectory(String.Format(@"{0}/PalmShop/ShopCode/HeadImg/{1}", Server.MapPath("~"), phone.Text));
}
string orignalName = this.file0.PostedFile.FileName; //获取客户机上传文件的文件名
string extendName = orignalName.Substring(orignalName.LastIndexOf(".")); //获取扩展名
if (extendName != ".gif" && extendName != ".jpg" && extendName != ".jpeg" && extendName != ".png")
{
MessageBox.Show(this, "文件格式有误！");
return;
}//检查文件格式
string newName = String.Format("{0}_{1}{2}", DateTime.Now.Millisecond, file0.PostedFile.ContentLength, extendName);//对文件进行重命名
strIconFileName = String.Format(@"{0}PalmShop/ShopCode/HeadImg/{1}/{2}", Server.MapPath("~"), phone.Text, newName);
strIconSaveFileName = String.Format(@"HeadImg/{0}/{1}", phone.Text, newName);
file0.PostedFile.SaveAs(strIconFileName);
if (oldimg.Trim() != null && oldimg.Trim() != "" && oldimg.Trim().ToLower() != "shoplogo/default.png")
{
System.IO.File.Delete(String.Format(@"{0}PalmShop/ShopCode/{1}", Server.MapPath("~"), oldimg));
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, "上传发生错误！原因是：" + ex.ToString());
}
MSCustomersDAL CustomerDal = new MSCustomersDAL();
MSCustomers CustomerModel = new MSCustomers();
CustomerModel.Phone = phone.Text;
CustomerModel.NickName = NickName.Text;
CustomerModel.Pnote = hd_content.Value;
CustomerModel.Email = email.Text;
CustomerModel.QQnum = QQnum.Text;
CustomerModel.Sex = isstateyes.Checked ? 0 : 1;
CustomerModel.UserPwd = Common.Common.MD5(password.Text);
CustomerModel.IsDel = 0;
CustomerModel.ID = strID;
if (strIconSaveFileName.Trim() != null && strIconSaveFileName.Trim() != "")
{
CustomerModel.HeadImg = strIconSaveFileName;
}
if (CustomerDal.UpdateCustomers(CustomerModel))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
else
{
MessageBox.Show(this, "请输入相应店铺名称或电话！");
}
}
else
{
return;
}
}