protected void btnSeasch_Click(object sender, EventArgs e)
{
//string pagecolumn = "ID,number,StoreID,name,StoreName,ExpectNum,Direct,TotalAccountMoney,OperateNum,Direct,OfficeTele,RegisterDate,StoreLevelStr";
StringBuilder sb = new StringBuilder();
sb.Append("1=1 ");
if (chShi.Checked)
{
if (this.CountryCity1.Country != "" && this.CountryCity1.Country != "" && this.CountryCity1.Country != "")
{
UserControl_CountryCity countryCity = Page.FindControl("CountryCity1") as UserControl_CountryCity;
string cp = DBHelper.ExecuteScalar("select cpccode from city where country='" + this.CountryCity1.Country + "' and province='" + this.CountryCity1.Province + "' and city='" + this.CountryCity1.City + "'").ToString();
sb.Append(" and cpccode='" + cp.ToString() + "'");
}
}
UserControl_ExpectNum expectnum = Page.FindControl("ExpectNum1") as UserControl_ExpectNum;
if (expectnum.ExpectNum > 0)
{
sb.Append(" and ExpectNum=" + expectnum.ExpectNum);
}
if (txtStoreId.Text.Trim().Length > 0)
{
sb.Append(" and StoreId='" + txtStoreId.Text.Trim() + "'");
}
if (ddl_shenhe.SelectedValue == "1")
{
sb.Append(" and number='" + Session["Member"].ToString() + "'");
ViewState["sql"] = sb.ToString();
string codition = sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
ViewState["pagewhere"] = sb.ToString();
pager.PageBind(0, 10, "UnauditedStoreInfo", pagecolumn, codition, "RegisterDate", "givStoreInfo");
}
else
{
sb.Remove(0, sb.Length);
sb.Append(" number='" + Session["Member"].ToString() + "'");
ViewState["sql"] = sb.ToString();
string codition = sb.ToString();
Pager pager = Page.FindControl("Pager1") as Pager;
ViewState["pagewhere"] = sb.ToString();
pager.PageBind(0, 10, "storeinfo", pagecolumn, codition, "RegisterDate", "givStoreInfo");
}
Translations();
}
private void GetOldMemberData(string bianhao)
{
//MemberInfoModifyBll mf = new MemberInfoModifyBll();
MemberInfoModel member = MemberInfoModifyBll.getMemberInfo(bianhao);
if (member != null)
{
this.LblBh.Text = member.Number;
this.LblBh.ForeColor = Color.Silver;
//解密姓名
this.labName.Text = Encryption.Encryption.GetDecipherName(CommonDataBLL.quanjiao(member.Name));
Txtlm.Text = member.PetName;
Txtyb1.Text = member.PostalCode;
//解密地址
this.txtdizhi.Text = Encryption.Encryption.GetDecipherAddress(member.Address);
Txtjtdh.Text = Encryption.Encryption.GetDecipherTele(member.HomeTele);
if (this.Txtjtdh.Text.Trim() == "")
{
this.Txtjtdh.Text = GetTran("000028", "电话号码");
this.Txtjtdh.Style.Add("color", "gray");
}
Txtbgdh.Text = Encryption.Encryption.GetDecipherTele(member.OfficeTele);
if (this.Txtbgdh.Text.Trim() == "")
{
this.Txtbgdh.Text = GetTran("000028", "电话号码");
this.Txtbgdh.Style.Add("color", "gray");
}
Txtyddh.Text = Encryption.Encryption.GetDecipherTele(member.MobileTele);
Txtczdh.Text = Encryption.Encryption.GetDecipherTele(member.FaxTele);
if (this.Txtczdh.Text.Trim() == "")
{
this.Txtczdh.Text = GetTran("000028", "电话号码");
this.Txtczdh.Style.Add("color", "gray");
}
IList <string> strBankInfo = new GroupRegisterBLL().GetBankValue(member.BankCode);
if (strBankInfo.Count > 0)
{
foreach (ListItem li in ddlCountry.Items)
{
if (li.Value == strBankInfo[1].Substring(0, 2))
{
li.Selected = true;
break;
}
}
ViewState["bankcode"] = strBankInfo[1];
}
txtbankbrachname.Text = member.Bankbranchname;
if (member.BCPCCode != "")
{
List <string> BankArea = new RegistermemberBLL().ChoseArea(member.BCPCCode);
//解密银行地址并且读出银行详细地址
UserControl_CountryCity countrycity1 = Page.FindControl("CountryCity2") as UserControl_CountryCity;
//取得该会员地址
CityModel bankArea = DAL.CommonDataDAL.GetCPCCode(member.BCPCCode);
countrycity1.SelectCountry(bankArea.Country, bankArea.Province, bankArea.City, bankArea.Xian);
}
List <string> GetCardType = new GroupRegisterBLL().GetCardType(member.PaperType.PaperTypeCode);
lblzhengjian.Text = GetCardType[0];
UserControl_CountryCity countrycity = Page.FindControl("CountryCity1") as UserControl_CountryCity;
//取得该会员地址
CityModel MemberArea = DAL.CommonDataDAL.GetCPCCode(member.CPCCode);
countrycity.SelectCountry(MemberArea.Country, MemberArea.Province, MemberArea.City, MemberArea.Xian);
//生日需要修改
lblBirthday.Text = (Convert.ToDateTime(member.Birthday).Year + "-" + (Convert.ToDateTime(member.Birthday)).Month + "-" + (Convert.ToDateTime(member.Birthday)).Day);
//解密开户名
this.labkaihuming.Text = Encryption.Encryption.GetDecipherName(member.BankBook) == "" ? Encryption.Encryption.GetDecipherName(member.Name) : Encryption.Encryption.GetDecipherName(member.BankBook);
//卡号解密
this.labkahao.Text = Encryption.Encryption.GetDecipherCard(member.BankCard);
if (Convert.ToInt32(member.Sex) == 0)
{
this.labSex.Text = GetTran("000095", "女");
}
else
{
this.labSex.Text = GetTran("000094", "男");
}
//解密证件号
this.labzhengjianhaoma.Text = Encryption.Encryption.GetDecipherNumber(member.PaperNumber);
Txtbz.Text = member.Remark;
}
}
protected void go_Click(object sender, System.EventArgs e)
{
//删除会员图片
string dirName = "";
string oldFileName = "";
string newFileName = "";
string newFilePath = "";
int photoW = 0, photoH = 0;
#region
//if (this.myFile.PostedFile.FileName.Trim() != string.Empty)
//{
// //删除旧图
// if (Session["Member"].ToString() != "")
// {
// delMemberPic(Session["Member"].ToString());
// }
// else
// {
// //Response.Write("<script>alert('参数错误，请重新登陆！');location.href('index.aspx')</script>");
// msg = "<script language='javascript'>alert('参数错误！重新登陆！');location.href('../index.aspx')</script>";
// return;
// }
// #region 上传新图
// //string oldFilePath = this.myFile.PostedFile.FileName.Trim();
// //try
// //{
// // if (oldFilePath != string.Empty)
// // {
// // //检查目录是否存在
// // dirName = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString();
// // if (!System.IO.Directory.Exists(Server.MapPath("../upload/" + dirName)))
// // {
// // System.IO.Directory.CreateDirectory(Server.MapPath("../upload/" + dirName));
// // }
// // oldFileName = System.IO.Path.GetFileName(oldFilePath);
// // string fileExtName = System.IO.Path.GetExtension(oldFilePath);
// // if (fileExtName.ToLower() != ".gif" && fileExtName.ToLower() != ".jpg" && fileExtName.ToLower() != ".jpeg")
// // {
// // // Response.Write("<script>alert('上传文件格式不正确！')</script>");
// // msg = "<script language='javascript'>alert('上传文件格式不正确！');</script>";
// // return;
// // }
// // if (myFile.PostedFile.ContentLength > 102400)
// // {
// // //Response.Write("<script>alert('上传文件不能大于100K！')</script>");
// // msg = "<script language='javascript'>alert('上传文件不能大于100K！');</script>";
// // return;
// // }
// // System.Random rd = new Random(0);
// // newFileName = DateTime.Now.Year.ToString() + rd.Next(10).ToString()
// // + DateTime.Now.Month.ToString() + rd.Next(10).ToString()
// // + DateTime.Now.Day.ToString() + rd.Next(10).ToString()
// // + DateTime.Now.Second.ToString()
// // + fileExtName;
// // newFilePath = Server.MapPath("..\\upload\\" + dirName) + "\\" + newFileName;
// // this.myFile.PostedFile.SaveAs(newFilePath);
// // try
// // {
// // System.Drawing.Image myIma = System.Drawing.Image.FromFile(newFilePath);
// // photoH = myIma.Height;
// // photoW = myIma.Width;
// // }
// // catch
// // { }
// // ViewState["photopath"] = dirName + "\\" + newFileName;
// // ViewState["photoH"] = photoH.ToString();
// // ViewState["photoW"] = photoW.ToString();
// // }
// //}
// //catch (Exception ext)
// //{
// // Response.Write("<script>alert('" + ext.ToString() + "')</script>");
// // return;
// //}
// #endregion
// #region 上传图片
// string oldFilePath = this.myFile.PostedFile.FileName.Trim();
// //string oldFilePath = "";
// try
// {
// if (oldFilePath != string.Empty)
// {
// if (!Directory.Exists(Server.MapPath("../Store/H_image"))) //如果文件夹不存在则创建
// {
// Directory.CreateDirectory(Server.MapPath("../Store/H_image"));
// }
// //检查目录是否存在
// dirName = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString();
// oldFileName = System.IO.Path.GetFileName(oldFilePath);
// string fileExtName = System.IO.Path.GetExtension(oldFilePath);
// if (fileExtName.ToLower() != ".gif" && fileExtName.ToLower() != ".jpg" && fileExtName.ToLower() != ".jpeg" && fileExtName.ToLower() != ".bmp" && fileExtName.ToLower() != ".png")
// {
// System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("000823", "上传文件格式不正确！") + "');", true);
// return;
// }
// if (this.myFile.PostedFile.ContentLength > 51200)
// {
// System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("000824", "上传文件不能大于50K！") + "');", true);
// return;
// }
// //System.Drawing.Image img = System.Drawing.Image.FromStream(PhotoPath1.PostedFile.InputStream);
// //int width = img.Width;
// //int hight = img.Height;
// //if (width > 50 || hight > 50)
// //{
// // Response.Write("<script>alert('" + GetTran("006034", "图片宽度和高度太大！") + "');</script>");
// // this.Button1.Enabled = true;
// // return "";
// //}
// System.Random rd = new Random(0);
// newFileName = DateTime.Now.Year.ToString() + rd.Next(10).ToString()
// + DateTime.Now.Month.ToString() + rd.Next(10).ToString()
// + DateTime.Now.Day.ToString() + rd.Next(10).ToString()
// + DateTime.Now.Second.ToString()
// + fileExtName;
// newFilePath = Server.MapPath("..\\Store\\H_image\\") + newFileName;
// string LevelIcon = "../Store/" + new MemberInfoModifyBll().GetMemberPhoto(Session["Member"].ToString());
// if (System.IO.File.Exists(Server.MapPath(LevelIcon)))
// {
// System.IO.File.Delete(Server.MapPath(LevelIcon));
// }
// this.myFile.PostedFile.SaveAs(newFilePath);
// try
// {
// System.Drawing.Image myIma = System.Drawing.Image.FromFile(newFilePath);
// photoH = myIma.Height;
// photoW = myIma.Width;
// }
// catch
// { }
// filepath = @"\Store\H_image\" + newFileName;
// try
// {
// System.Drawing.Image myIma = System.Drawing.Image.FromFile(newFilePath);
// photoH = myIma.Height;
// photoW = myIma.Width;
// }
// catch (Exception ex1)
// {
// System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("006895", "图片格式转换错误！") + "');", true);
// if (System.IO.File.Exists(Server.MapPath(filepath)))
// {
// System.IO.File.Delete(Server.MapPath(filepath));
// }
// return;
// }
// }
// }
// catch
// {
// return;
// }
// #endregion
//}
//else
//{
//}
#endregion
//生日
DateTime birthday;
try
{
//更改至标准时间
birthday = Convert.ToDateTime(lblBirthday.Text);
}
catch
{
Page.ClientScript.RegisterStartupScript(GetType(), null, "<script language='javascript'>alert('" + GetTran("000148", "对不起，请选择正确的出生日期！") + "');</script>", false);
return;
}
int sex = 0;
if (labSex.Text.Trim() == GetTran("000094", "男"))
{
sex = 1;
}
else
{
sex = 0;
}
if (Txtbz.Text.Length > 500)
{
Page.ClientScript.RegisterStartupScript(GetType(), null, "<script language='javascript'>alert('" + GetTran("007704", "备注内容不能超过500字") + "！');</script>", false);
return;
}
//姓名加密
string name = Encryption.Encryption.GetEncryptionName(labName.Text.Trim());
string Petname = Txtlm.Text.Trim();
//string Birthday = birthday;
//string sex = sex;
//加密电话
string HomeTele = Encryption.Encryption.GetEncryptionTele(Txtjtdh.Text.Trim());
string OfficeTele = Encryption.Encryption.GetEncryptionTele(Txtbgdh.Text.Trim());
string MobileTele = Encryption.Encryption.GetEncryptionTele(Txtyddh.Text.Trim());
string FaxTele = Encryption.Encryption.GetEncryptionTele(Txtczdh.Text.Trim());
UserControl_CountryCity countrycity = Page.FindControl("CountryCity1") as UserControl_CountryCity;
string Country = countrycity.Country;
string Province = countrycity.Province;
string City = countrycity.City;
string Xian = countrycity.Xian;
if (Country == "请选择" || Province == "请选择" || City == "请选择" || Xian == "请选择" || Country == "" || Province == "" || City == "" || Xian == "")
{
ScriptHelper.SetAlert(Page, "请选择地址！");
return;
}
string CPCCode = DAL.CommonDataDAL.GetCPCCode(Country, Province, City, Xian);
//加密地址
string Address = Encryption.Encryption.GetEncryptionAddress(txtdizhi.Text.Trim());
if (Address.Trim().Length == 0)
{
ScriptHelper.SetAlert(Page, "请填写详细地址！");
return;
}
string PostalCode = Txtyb1.Text.Trim();
string PaperType = new GroupRegisterBLL().GetPaperTypeCode(lblzhengjian.Text.Trim());
//证件加密
string PaperNumber = Encryption.Encryption.GetEncryptionNumber(labzhengjianhaoma.Text.Trim());
if (this.Txtbz.Text.Length > 500)
{
System.Web.UI.ScriptManager.RegisterStartupScript(Page, GetType(), "success2", "alert('" + GetTran("006708", "对不起，备注输入的字符太多,最多500个字符！") + "');", true);
return;
}
;
string Remark = Txtbz.Text.Trim();
//int Healthy = Convert.ToInt32(MemberHealth.SelectedValue);
string photopath = "";
//需要修改标准时间
DateTime Birthday = Convert.ToDateTime(birthday);
#region 银行信息
UserControl_CountryCity countrycity1 = Page.FindControl("CountryCity2") as UserControl_CountryCity;
string Country1 = countrycity1.Country;
string Province1 = countrycity1.Province;
string City1 = countrycity1.City;
string Xian1 = countrycity1.Xian;
if (Country1 == "请选择" || Province1 == "请选择" || City1 == "请选择" || Xian1 == "请选择" || Country1 == "" || Province1 == "" || City1 == "" || Xian1 == "")
{
ScriptHelper.SetAlert(Page, "请选择开户行地址！");
return;
}
string bcpccode = DAL.CommonDataDAL.GetCPCCode(Country1, Province1, City1, Xian1);
string bankcode = DdlBank.SelectedValue;
string bankbrachname = txtbankbrachname.Text.Trim();
string bankcard = Encryption.Encryption.GetEncryptionCard(labkahao.Text.Trim());
string bankaddress = "";
#endregion
BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("Memberinfo", "ltrim(rtrim(number))");
cl_h_info.AddRecord(Session["Member"].ToString());
MemberInfoModifyBll mf = new MemberInfoModifyBll();
if (mf.updateMember(Session["Member"].ToString(), name, Petname, Birthday, sex, HomeTele, OfficeTele, MobileTele, FaxTele, Country, Province, City, Address, PostalCode, PaperType, PaperNumber, Remark, photopath, photoW, photoH, CPCCode, bcpccode, bankaddress, bankcard, bankcode, bankbrachname))
{
cl_h_info.AddRecord(Session["Member"].ToString());
cl_h_info.ModifiedIntoLogs(BLL.CommonClass.ChangeCategory.member3, Session["Member"].ToString(), BLL.CommonClass.ENUM_USERTYPE.objecttype5);
//ScriptHelper.SetAlert(Page,"修改成功！！！");
Page.ClientScript.RegisterStartupScript(GetType(), null, "<script language='javascript'>alert('" + GetTran("000222", "修改成功！") + "');</script>", false);
}
else
{
//ScriptHelper.SetAlert(Page, "修改失败！！！");
Page.ClientScript.RegisterStartupScript(GetType(), null, "<script language='javascript'>alert('" + GetTran("000225", "修改失败！") + "');</script>", false);
}
GetOldMemberData(Session["Member"].ToString());
}
