/// <summary>
/// 得到送货地址
/// </summary>
/// <param name="pdata"></param>
/// <returns></returns>
public static List <addressinfo> getaddress(pageinfo pdata)
{
List <addressinfo> list = new List <addressinfo>();
try
{
DataTable dt = pagehelper.getpagedt(pdata);
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
addressinfo item = new addressinfo();
item.addressid = TypeParse.DbObjToInt(dr["addressid"].ToString(), 0);
item.address = TypeParse.DbObjToString(dr["address"].ToString(), "");
item.contact = TypeParse.DbObjToString(dr["contact"].ToString(), "");
item.mobile = TypeParse.DbObjToString(dr["mobile"].ToString(), "");
item.tel = TypeParse.DbObjToString(dr["tel"].ToString(), "");
item.userid = TypeParse.DbObjToString(dr["userid"].ToString(), "");
item.deliveryIid = TypeParse.DbObjToInt(dr["deliveryIid"].ToString(), 0);
item.deliveryIIid = TypeParse.DbObjToInt(dr["deliveryIIid"].ToString(), 0);
item.isdefault = TypeParse.DbObjToInt(dr["isdefault"].ToString(), 0);
list.Add(item);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(list);
}
public string editaddressinfo(string contact, string userid, string saddress, string tel, string mobile, string p1id, string p2id, string addressid)
{
int d1id = TypeParse.DbObjToInt(p1id, 0);
int d2id = TypeParse.DbObjToInt(p2id, 0);
int id = TypeParse.DbObjToInt(addressid, 0);
addressinfo item = new addressinfo();
item.contact = contact;
item.address = saddress;
item.tel = tel;
item.mobile = mobile;
item.deliveryIid = d1id;
item.deliveryIIid = d2id;
item.userid = userid;
item.isdefault = 1;
item.addressid = id;
bool result = address.editaddress(item);
if (result)
{
return("t");
}
else
{
return("f");
}
}
protected void EditAddressInfo(object sender, EventArgs e)
{
string uid = "";
if (Request.Cookies["tfuid"] != null)
{
uid = TypeParse.DbObjToString(Request.Cookies["tfuid"].Value, "");
}
else
{
Response.Redirect("/UserLog");
}
if (txtaddress.Value.Length < 5 || txtcontact.Value.Length < 2)
{
lbladdressnote.InnerText = "请完整填写下面的选项";
return;
}
try
{
addressinfo data = new addressinfo();
data.address = txtaddress.Value.Trim();
data.contact = txtcontact.Value.Trim();
data.mobile = txtmobile.Value.Trim();
data.tel = txttel.Value;
data.deliveryIid = TypeParse.DbObjToInt(ddldeliveryIid.SelectedValue, 1);
data.deliveryIIid = TypeParse.DbObjToInt(ddldeliveryIIid.SelectedValue, 1);
data.isdefault = 0;
data.userid = uid;
data.addressid = TypeParse.DbObjToInt(hdaddressid.Value, 0);
bool result = address.editaddress(data);
if (result)
{
Response.Write("<script>alert('修改收货地址成功！');location.href='/Address';</script>");
return;
}
else
{
Response.Write("<script>alert('修改收货地址失败！');location.href='/Address';</script>");
return;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (RouteData.Values["addressid"] != null)
{
int addressid = TypeParse.DbObjToInt(RouteData.Values["addressid"], 0);
addressinfo data = address.getaddressinfo(addressid);
if (!Page.IsPostBack)
{
txtaddress.Value = data.address;
txtcontact.Value = data.contact;
txtmobile.Value = data.mobile;
txttel.Value = data.tel;
hdaddressid.Value = data.addressid.ToString();
//配送区域I
List <categoryinfo> ntlist = category.getdeliveryI();
ddldeliveryIid.DataSource = ntlist;
ddldeliveryIid.DataTextField = "deliveryI";
ddldeliveryIid.DataValueField = "deliveryIid";
ddldeliveryIid.DataBind();
for (int i = 0; i < ddldeliveryIid.Items.Count; i++)
{
if (ddldeliveryIid.Items[i].Value == data.deliveryIid.ToString())
{
ddldeliveryIid.SelectedIndex = i;
}
}
//配送区域II
List <categoryinfo> ntlist2 = category.getdeliveryII();
ddldeliveryIIid.DataSource = ntlist2;
ddldeliveryIIid.DataTextField = "deliveryII";
ddldeliveryIIid.DataValueField = "deliveryIIid";
ddldeliveryIIid.DataBind();
for (int k = 0; k < ddldeliveryIIid.Items.Count; k++)
{
if (ddldeliveryIIid.Items[k].Value == data.deliveryIIid.ToString())
{
ddldeliveryIIid.SelectedIndex = k;
}
}
}
}
}
public static List <addressinfo> getaddressinfobyuid(string userid)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@userid", SqlDbType.NVarChar, 50);
parms[0].Value = userid;
string sql = "select a.addressid,a.address,a.contact,a.mobile,a.tel,a.userid,a.deliveryIid,a.deliveryIIid,a.isdefault,b.deliveryI,c.deliveryII from address a ,deliveryI b ,deliveryII c where a.deliveryIid=b.deliveryIid and a.deliveryIIid=c.deliveryIIid and userid=@userid order by a.isdefault desc";
List <addressinfo> list = new List <addressinfo>();
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.connectionstring, CommandType.Text, sql, parms).Tables[0];
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
addressinfo item = new addressinfo();
item.addressid = TypeParse.DbObjToInt(dr["addressid"].ToString(), 0);
item.address = TypeParse.DbObjToString(dr["address"].ToString(), "");
item.contact = TypeParse.DbObjToString(dr["contact"].ToString(), "");
item.mobile = TypeParse.DbObjToString(dr["mobile"].ToString(), "");
item.tel = TypeParse.DbObjToString(dr["tel"].ToString(), "");
item.userid = TypeParse.DbObjToString(dr["userid"].ToString(), "");
item.deliveryIid = TypeParse.DbObjToInt(dr["deliveryIid"].ToString(), 0);
item.deliveryIIid = TypeParse.DbObjToInt(dr["deliveryIIid"].ToString(), 0);
item.isdefault = TypeParse.DbObjToInt(dr["isdefault"].ToString(), 0);
item.deliveryI = TypeParse.DbObjToString(dr["deliveryI"].ToString(), "");
item.deliveryII = TypeParse.DbObjToString(dr["deliveryII"].ToString(), "");
list.Add(item);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(list);
}
public static addressinfo getindexaddressinfo(string userid)
{
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@userid", SqlDbType.NVarChar, 50);
parms[0].Value = userid;
addressinfo item = new addressinfo();
string sql = "select a.addressid,a.address,a.contact,a.mobile,a.tel,a.userid,a.deliveryIid,a.deliveryIIid,a.isdefault,b.deliveryI,c.deliveryII from address a ,deliveryI b ,deliveryII c where a.deliveryIid=b.deliveryIid and a.deliveryIIid=c.deliveryIIid and a.userid=@userid and a.isdefault=1";
try
{
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.connectionstring, CommandType.Text, sql, parms);
if (dr.Read())
{
item.addressid = TypeParse.DbObjToInt(dr["addressid"].ToString(), 0);
item.address = TypeParse.DbObjToString(dr["address"].ToString(), "");
item.contact = TypeParse.DbObjToString(dr["contact"].ToString(), "");
item.mobile = TypeParse.DbObjToString(dr["mobile"].ToString(), "");
item.tel = TypeParse.DbObjToString(dr["tel"].ToString(), "");
item.userid = TypeParse.DbObjToString(dr["userid"].ToString(), "");
item.deliveryIid = TypeParse.DbObjToInt(dr["deliveryIid"].ToString(), 0);
item.deliveryIIid = TypeParse.DbObjToInt(dr["deliveryIIid"].ToString(), 0);
item.deliveryI = TypeParse.DbObjToString(dr["deliveryI"].ToString(), "");
item.deliveryII = TypeParse.DbObjToString(dr["deliveryII"].ToString(), "");
item.isdefault = TypeParse.DbObjToInt(dr["isdefault"].ToString(), 0);
dr.Close();
dr.Dispose();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(item);
}
/// <summary>
/// 添加送货地址
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static bool addaddress(addressinfo data)
{
SqlParameter[] parms = new SqlParameter[8];
parms[0] = new SqlParameter("@address", SqlDbType.VarChar, 50);
parms[0].Value = data.address;
parms[1] = new SqlParameter("@contact", SqlDbType.VarChar, 10);
parms[1].Value = data.contact;
parms[2] = new SqlParameter("@mobile", SqlDbType.VarChar, 30);
parms[2].Value = data.mobile;
parms[3] = new SqlParameter("@tel", SqlDbType.VarChar, 30);
parms[3].Value = data.tel;
parms[4] = new SqlParameter("@userid", SqlDbType.VarChar, 50);
parms[4].Value = data.userid;
parms[5] = new SqlParameter("@deliveryIid", SqlDbType.Int);
parms[5].Value = data.deliveryIid;
parms[6] = new SqlParameter("@deliveryIIid", SqlDbType.Int);
parms[6].Value = data.deliveryIIid;
parms[7] = new SqlParameter("@isdefault", SqlDbType.Int);
parms[7].Value = data.isdefault;
string sql = "insert into address (address,contact,mobile,tel,userid,deliveryIid,deliveryIIid,isdefault) values(@address,@contact,@mobile,@tel,@userid,@deliveryIid,@deliveryIIid,@isdefault)";
int result = 0;
try
{
result = SqlHelper.ExecuteNonQuery(SqlHelper.connectionstring, CommandType.Text, sql, parms);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
return(result > 0);
}
public string editaddress(string addressid)
{
int id = TypeParse.DbObjToInt(addressid, 0);
addressinfo data = address.getaddressinfo(id);
//大区下拉菜单
List <categoryinfo> d1list = category.getdeliveryI();
string str;
StringBuilder d1sb = new StringBuilder();
d1sb.Append("<select id=\"d1select\" class=\"orderselect\" onchange=\"changed1()\">");
foreach (categoryinfo pitem in d1list)
{
string template;
if (data.deliveryIid == pitem.deliveryIid)
{
template = "<option value=\"{0}\" selected=\"selected\">{1}</option>";
}
else
{
template = "<option value=\"{0}\">{1}</option>";
}
d1sb.AppendFormat(template, pitem.deliveryIid, pitem.deliveryI);
}
d1sb.Append("</select>");
StringBuilder d2sb = new StringBuilder();
List <categoryinfo> d2list = category.getdeliveryIIbyID(data.deliveryIid);
d2sb.Append("<select id=\"d2select\" class=\"orderselect\">");
foreach (categoryinfo pitem in d2list)
{
string template;
if (data.deliveryIIid == pitem.deliveryIIid)
{
template = "<option value=\"{0}\" selected=\"selected\">{1}</option>";
}
else
{
template = "<option value=\"{0}\">{1}</option>";
}
d2sb.AppendFormat(template, pitem.deliveryIIid, pitem.deliveryII);
}
d2sb.Append("</select>");
str = " <h3>添加新的收货地址 <a href=\"javascript:refresh()\">[关闭]</a> </h3><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" class=\"ordertb\"><tr><td class=\"tdleft\">收 货 人：</td><td><input type=\"text\" id=\"txtcontact\" value=\"{0}\" class=\"ordertxt\" /></td></tr><tr><td class=\"tdleft\">配送大区：</td><td>";
str += d1sb.ToString();
str += "</td></tr><tr><td class=\"tdleft\"> 配送小区：</td><td><label id=\"d2selectlabel\">";
str += d2sb.ToString();
str += "</label></td></tr><tr><td class=\"tdleft\">详细地址：</td><td><input type=\"text\" id=\"txtaddress\" value=\"{1}\" class=\"ordertxt w300\" /> 如:上海市XX区XX路XX弄XX号XX室</td></tr><tr><td class=\"tdleft\">手机号码：</td><td><input type=\"text\" id=\"txtmobile\" value=\"{2}\" class=\"ordertxt\"/></td></tr><tr><td class=\"tdleft\">固定电话：</td><td><input type=\"text\" id=\"txttel\" value=\"{3}\" class=\"ordertxt\"/></td></tr></table><p><input type=\"button\" value=\"修改地址\" onclick=\"editaddressinfo('{4}')\" class=\"orderbtn\" /></p> ";
StringBuilder sb = new StringBuilder();
sb.AppendFormat(str, data.contact, data.address, data.mobile, data.tel, data.addressid);
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
//图片绑定
List <webimagesinfo> webimageslist = webimages.bindwebimages(1, "企业LOGO");
StringBuilder webimagessb = new StringBuilder();
foreach (webimagesinfo item in webimageslist)
{
string template = "<a href=\"{0}\" target=\"_blank\"><img src=\"/Files/WebImages/{1}\" alt=\"\" target=\"_blank\"/></a>";
webimagessb.AppendFormat(template, item.imgurl, item.imgname);
}
logoimgHTML = webimagessb.ToString();
if (Request.Cookies["tfuid"] != null)
{
string userid = Request.Cookies["tfuid"].Value.ToString();
uidValue = userid;
userinfo item = user.getuserinfo(userid);
List <addressinfo> alist = address.getaddressinfobyuid(userid);
if (alist.Count < 1)
{
//大区下拉菜单
List <categoryinfo> d1list = category.getdeliveryI();
StringBuilder d1sb = new StringBuilder();
d1sb.Append("<select id=\"d1select\" class=\"orderselect\" onchange=\"changed1()\"><option value=\"0\">--请选择--</option>");
foreach (categoryinfo pitem in d1list)
{
string template;
template = "<option value=\"{0}\">{1}</option>";
d1sb.AppendFormat(template, pitem.deliveryIid, pitem.deliveryI);
}
d1sb.Append("</select>");
addressHTML = " <h3>添加收货人信息</h3><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" class=\"ordertb\"><tr><td class=\"tdleft\">收 货 人：</td><td><input type=\"text\" id=\"txtcontact\" class=\"ordertxt\" /></td></tr><tr><td class=\"tdleft\">配送大区：</td><td>";
addressHTML += d1sb.ToString();
addressHTML += "</td></tr><tr><td class=\"tdleft\"> 配送小区：</td><td><label id=\"d2selectlabel\"><select id=\"d2select\" class=\"orderselect\"><option value=\"0\">--请选择--</option></select></label></td></tr><tr><td class=\"tdleft\">详细地址：</td><td><input type=\"text\" id=\"txtaddress\" class=\"ordertxt w300\" /> 如:上海市XX区XX路XX弄XX号XX室</td></tr><tr><td class=\"tdleft\">手机号码：</td><td><input type=\"text\" id=\"txtmobile\" class=\"ordertxt\"/></td></tr><tr><td class=\"tdleft\">固定电话：</td><td><input type=\"text\" id=\"txttel\" class=\"ordertxt\"/></td></tr></table><p><input type=\"button\" value=\"确认地址\" onclick=\"addaddress()\" class=\"orderbtn\" /></p> ";
}
else
{
addressinfo data = address.getindexaddressinfo(userid);
StringBuilder asb = new StringBuilder();
string template = " <h3>收货人信息 <a href=\"javascript:selectaddress()\">[修改信息]</a></h3><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" class=\"ordertb\"><tr><td class=\"tdleft\">收 货 人：</td><td>{0}</td></tr><tr><td class=\"tdleft\">配送大区：</td><td>{1}</td></tr><tr><td class=\"tdleft\">配送小区：</td><td>{2}</td></tr> <tr><td class=\"tdleft\">详细地址：</td><td>{3}</td></tr><tr><td class=\"tdleft\">手机号码： </td><td>{4}</td></tr><tr><td class=\"tdleft\"> 固定电话： </td><td>{5}</td></tr></table>";
asb.AppendFormat(template, data.contact, data.deliveryI, data.deliveryII, data.address, data.mobile, data.tel);
addressHTML = asb.ToString();
}
if (DateTime.Now.Hour >= 16)
{
deliverydateValue = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
}
else
{
deliverydateValue = DateTime.Now.ToString("yyyy-MM-dd");
}
List <orderinfo> cartlist = order.getcartlist(0, userid);
int ccount = cartlist.Count;
StringBuilder csb = new StringBuilder();
for (int k = 0; k < ccount; k++)
{
string template = "<tr style=\"height: 60px;\"><td align=\"center\">{0}</td><td class=\"buyimg\"><a href=\"/PInfo/{1}.html\"><img src=\"/Files/Product/{2}\" alt=\"\" /></a></td><td><a href=\"/PInfo/{3}.html\" title=\"{4}\">{5}</a></td><td align=\"center\">{6}</td><td align=\"center\"><a href=\"javascript:changecartordernum('{7}','minus')\" class=\"minusbtn1\"> </a><input type=\"text\" id=\"buynum\" class=\"numtxt1\" value=\"{8}\" readonly=\"readonly\" /><a href=\"javascript:changecartordernum('{9}','add')\" class=\"addbtn1\"> </a></td><td align=\"center\"><a href=\"javascript:delcart('{10}')\">删除</a></td></tr>";
csb.AppendFormat(template, k + 1, cartlist[k].productid, cartlist[k].productimg, cartlist[k].productid, cartlist[k].productname, cartlist[k].productname, cartlist[k].vipprice, cartlist[k].cartid, cartlist[k].buynum, cartlist[k].cartid, cartlist[k].cartid);
}
cartlistHTML = csb.ToString();
if (ccount > 0)
{
userinfo udata = user.getuserinfo(userid);
decimal udiscount = udata.atdiscount;
string ac = (udiscount * 10).ToString("F1");
string atype = udata.accountstype;
decimal pmoney = order.getallprice(userid);
decimal dmoney = pmoney - pmoney * udiscount;
decimal paymoney = pmoney * udiscount;
pmoneyHMTL = pmoney.ToString("F2");
dmoneyHTML = atype + ac + "折，优惠：￥" + dmoney.ToString("F2");
paymoneyHTML = paymoney.ToString("F2");
}
else
{
pmoneyHMTL = "0";
dmoneyHTML = "优惠：0";
paymoneyHTML = "0";
}
}
else
{
Response.Redirect("/UserLog?relurl=/PList");
}
}