/// <summary>
/// 点击注册按钮处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
//获取界面数据
string username = txtUserName.Text.Trim();
string emailcode = txtEmailCode.Text.Trim();
string uid = hdUID.Value;
string password = txtPassword.Text.Trim();
string confirm = txtConfirm.Text.Trim();
string realname = txtRealName.Text.Trim();
string mobile = txtMobile.Text.Trim();
string tel = txtTel.Text.Trim();
string fax = txtFax.Text.Trim();
string address = txtAddress.Text.Trim();
if (string.IsNullOrWhiteSpace(username) | string.IsNullOrWhiteSpace(password) || string.IsNullOrWhiteSpace(confirm) || string.IsNullOrWhiteSpace(emailcode) ||
string.IsNullOrWhiteSpace(realname) || string.IsNullOrWhiteSpace(mobile) || string.IsNullOrWhiteSpace(address))
{
MLMGC.COMP.Jscript.ShowMsg("请认真填写以上内容", this);
return;
}
if (password != confirm)
{
MLMGC.COMP.Jscript.ShowMsg("两次密码不一致", this);
return;
}
E_Personal data = new E_Personal();
data.UserName = username;
data.EmailCode = emailcode;
data.UID = Guid.Parse(uid);
data.Password = EncryptString.EncryptPassword(password);
data.RealName = realname;
data.Sex = Convert.ToInt32(rbSex.SelectedValue);
data.Mobile = mobile;
data.Tel = tel;
data.Fax = fax;
data.Address = address;
int result = new T_Personal().AddPersonal(data);
switch (result)
{
case -2:
MLMGC.COMP.Jscript.ShowMsg("添加失败，用户名已存在", this);
break;
case -1:
MLMGC.COMP.Jscript.ShowMsg("验证码失效", this);
break;
case 0:
MLMGC.COMP.Jscript.ShowMsg("注册失败", this);
break;
case 1:
Response.Redirect("regstep3.aspx");
break;
}
}
/// <summary>
/// 提交头像处理事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (hdUrl.Value == "")
{
MLMGC.COMP.Jscript.ShowMsg("请选择头像", this);
return;
}
E_Personal data = new E_Personal();
data.PersonalID = PersonalID;
data.UserID = UserID;
data.Avatar = hdUrl.Value.Substring(hdUrl.Value.LastIndexOf("/") + 1);
bool flag = new T_Personal().UpdateAvatar(data);
if (flag)
{
//new MLMGC.BLL.Enterprise.T_Log().Add(new MLMGC.DataEntity.Enterprise.E_Log() { EnterpriseID = EnterpriceID, UserID = UserID, LogTitle = "修改头像", IP = MLMGC.COMP.Requests.GetRealIP() });
MLMGC.COMP.Jscript.AlertAndRedirect(this, "修改成功", "Avatar.aspx");
}
else
{
MLMGC.COMP.Jscript.ShowMsg("修改失败", this);
}
}
/// <summary>
/// 管理员查看个人用户列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-27</remarks>
public DataTable GetList(E_Personal data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@UserName", SqlDbType.VarChar, 128),
new SqlParameter("@RealName", SqlDbType.VarChar, 128),
new SqlParameter("@UserType", SqlDbType.TinyInt),
new SqlParameter("@StartDate", SqlDbType.SmallDateTime),
new SqlParameter("@EndDate", SqlDbType.SmallDateTime),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@TotalCount", SqlDbType.Int)
};
parms[0].Value = data.UserName;
parms[1].Value = data.RealName;
parms[2].Value = (int)UserType.个人用户;
parms[3].Value = data.Page.StartDate;
parms[4].Value = data.Page.EndDate;
parms[5].Value = data.Page.PageIndex;
parms[6].Value = data.Page.PageSize;
parms[7].Direction = ParameterDirection.Output;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_PersonalS_ListSelect", parms);
data.Page.TotalCount = parms[7].Value == DBNull.Value ? 0 : Convert.ToInt32(parms[7].Value);
return(dt);
}
protected void databind()
{
//获取个人信息，判断他的信息是否完善，如果不完善，跳转到个人资料页面进行填写。
E_Personal dataPersonal = new E_Personal();
dataPersonal.UserID = UserID;
dataPersonal.PersonalID = PersonalID;
dataPersonal = new T_Personal().GetModel(dataPersonal);
if (dataPersonal == null)
{
Response.Redirect("../main.aspx");
}
//判断资料是否完善
if (!new T_Personal().IsPerfect(dataPersonal))
{
Jscript.AlertAndRedirect(this, "个人信息不完善", "../Modify.aspx");
return;
}
//获取文库目录分类
DataTable dt = new T_WenKuClass().GetList();
if (dt == null)
{
return;
}
//绑定目录分类
foreach (DataRow row in dt.Rows)
{
ddlCategory.Items.Add(new ListItem(row["WenKuClassName"].ToString(), row["WenKuClassID"].ToString()));
}
ddlCategory.Items.Add(new ListItem("其它", "0"));
}
protected void databind()
{
E_Personal data = new E_Personal();
data.UserID = UserID;
data.PersonalID = PersonalID;
data = new T_Personal().GetModel(data);
if (data == null)
{
return;
}
ltName.Text = data.RealName;
imgAvatar.ImageUrl = MLMGC.COMP.Config.GetPersonalAvatarUrl(data.Avatar);
//ltSex.Text = data.Sex == 1 ? "男" : "女";
//ltMobile.Text = data.Mobile;
//ltTel.Text = data.Tel;
//ltFax.Text = data.Fax;
//ltAddress.Text = data.Address;
//DataTable dt = new T_ClientInfo().Statistics(new E_ClientInfo() { PersonalID=PersonalID });
//if (dt.Select("[Status] is null").Length > 0)//总量
//{
// LtAmount.Text = dt.Select("[Status] is null")[0]["Amount"].ToString();
//}
//if (dt.Select("[Status]="+(int)EnumClientStatus.潜在客户).Length > 0)//潜在客户
//{
// LtAmount1.Text = dt.Select("[Status]=" + (int)EnumClientStatus.潜在客户)[0]["Amount"].ToString();
//}
//if (dt.Select("[Status]=" + (int)EnumClientStatus.意向客户).Length > 0)//意向客户
//{
// LtAmount2.Text = dt.Select("[Status]=" + (int)EnumClientStatus.意向客户)[0]["Amount"].ToString();
//}
//if (dt.Select("[Status]=" + (int)EnumClientStatus.成交客户).Length > 0)//成交
//{
// LtAmount3.Text = dt.Select("[Status]=" + (int)EnumClientStatus.成交客户)[0]["Amount"].ToString();
//}
//if (dt.Select("[Status]=" + (int)EnumClientStatus.失败客户).Length > 0)//失败
//{
// LtAmount4.Text = dt.Select("[Status]=" + (int)EnumClientStatus.失败客户)[0]["Amount"].ToString();
//}
//if (dt.Select("[Status]=" + (int)EnumClientStatus.报废客户).Length > 0)//报废
//{
// LtAmount5.Text = dt.Select("[Status]=" + (int)EnumClientStatus.报废客户)[0]["Amount"].ToString();
//}
//显示最新的前几条微博
rpListWeibo.DataSource = new T_Weibo().GetMainList(new E_Weibo()
{
WeiboID = 0, Count = 5
});
rpListWeibo.DataBind();
//获取最新的n条公告信息
rpListAnn.DataSource = new T_Announcement().GetNewList(new E_Announcement()
{
Count = 15
});
rpListAnn.DataBind();
}
/// <summary>
/// 管理员查看个人基本信息
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-27</remarks>
public E_Personal SelectModel(E_Personal data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@PersonalID", SqlDbType.Int)
};
parms[0].Value = data.UserID;
parms[1].Value = data.PersonalID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcB_UserS_PISelect", parms);
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
data.UserName = row["UserName"].ToString();
data.Password = row["Password"].ToString();
data.RealName = row["RealName"].ToString();
data.Mobile = row["Mobile"].ToString();
data.Tel = row["Tel"].ToString();
data.Fax = row["Fax"].ToString();
data.Address = row["Address"].ToString();
data.Email = row["Email"].ToString();
data.ClientNum = Convert.ToInt32(row["ClientNum"]);
return(data);
}
return(null);
}
public void EditarPersonal(E_Personal Personal)
{
string Query = @"UPDATE [dbo].[VP_Personal]
SET [VP_IdPerfil] = @VP_IdPerfil
,[VP_IdStatus] = @VP_IdStatus
,[Nombres] = @Nombres
,[Apellidos] = @Apellidos
,[Telefono] = @Telefono
,[CodigoTarjeta] = @CodigoTarjeta
,[RH] = @RH
,[PersonaContacto] = @PersonaContacto
,[Telefono_PersonaContacto] = @Telefono_PersonaContacto
WHERE [VP_IdPersonal] = @VP_IdPersonal;";
SqlCommand cmd = new SqlCommand(Query, conexion);
conexion.Open();
cmd.Parameters.AddWithValue("@VP_IdPersonal", Personal.VP_IdPersonal);
cmd.Parameters.AddWithValue("@VP_IdPerfil", Personal.VP_IdPerfil);
cmd.Parameters.AddWithValue("@VP_IdStatus", Personal.VP_IdStatus);
cmd.Parameters.AddWithValue("@Nombres", Personal.Nombres);
cmd.Parameters.AddWithValue("@Apellidos", Personal.Apellidos);
cmd.Parameters.AddWithValue("@Telefono", Personal.Telefono);
cmd.Parameters.AddWithValue("@CodigoTarjeta", Personal.CodigoTarjeta);
cmd.Parameters.AddWithValue("@RH", Personal.RH);
cmd.Parameters.AddWithValue("@PersonaContacto", Personal.PersonaContacto);
cmd.Parameters.AddWithValue("@Telefono_PersonaContacto", Personal.Telefono_PersonaContacto);
cmd.ExecuteNonQuery();
conexion.Close();
}
/// <summary>
/// 判断个人信息是否完善
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool IsPerfect(E_Personal data)
{
//判断资料是否完善
if (string.IsNullOrWhiteSpace(data.RealName) || string.IsNullOrWhiteSpace(data.Email) || string.IsNullOrWhiteSpace(data.Mobile))
{
return(false);
}
return(true);
}
/// <summary>
/// 修改个人基本信息
/// </summary>
private void UpdateBase()
{
//获取界面数据
string name = nv["name"];
int gender, marital, workyear;
DateTime birthday;
if (!int.TryParse(nv["gender"], out gender) || !int.TryParse(nv["marital"], out marital) || !int.TryParse(nv["workyear"], out workyear) || !DateTime.TryParse(nv["birthday"], out birthday))
{
HttpContext.Current.Response.Write("参数错误");
return;
}
string email = nv["email"];
string mobile = nv["mobile"];
string tel = nv["tel"];
string fax = nv["fax"];
string keyword = nv["keyword"];
string address = nv["address"];
//验证邮箱、手机、电话格式是否正确
bool flag = new Regex(@"^\w+((-\w+)|(\.\w+))*\@[A-Za-z0-9]+((\.|-)[A-Za-z0-9]+)*\.[A-Za-z0-9]+$").IsMatch(email);
flag = flag & new Regex(@"^1(3|5|8)+\d{9}$").IsMatch(mobile);
if (!string.IsNullOrEmpty(tel))
{
flag = flag & new Regex(@"^(0[0-9]{2,3}\-)?([2-9][0-9]{6,7})+(\-[0-9]{1,4})?$").IsMatch(tel);
}
if (!string.IsNullOrEmpty(fax))
{
flag = flag & new Regex(@"^(0[0-9]{2,3}\-)?([2-9][0-9]{6,7})+(\-[0-9]{1,4})?$").IsMatch(fax);
}
if (!flag)
{
HttpContext.Current.Response.Write("参数错误");
return;
}
E_Personal data = new E_Personal();
data.PersonalID = pp.PersonalID;
data.UserID = pp.UserID;
data.RealName = name;
data.Sex = gender;
data.SetMaritalStatus = marital;
data.SetWorkYears = workyear;
data.Birthday = birthday;
data.Email = email;
data.Mobile = mobile;
data.Tel = tel;
data.Fax = fax;
data.KeyWord = keyword;
data.Address = address;
bool b = new T_Personal().Update(data);
HttpContext.Current.Response.Write(b ? "1" : "0");
}
/// <summary>
/// 绑定数据
/// </summary>
protected void databind()
{
//获取个人基本信息
E_Personal data = new E_Personal();
data.UserID = UserID;
data.PersonalID = PersonalID;
data = new T_Personal().GetModel(data);
if (data == null)
{
return;
}
EnumUtil.BindList <EnumWorkYear>(ddlWorkYear);
EnumUtil.BindList <EnumScale>(ddlScale);
//-----------Info---------
lblBName.Text = data.RealName;
lblBSex.Text = data.Sex == 0 ? "男" : "女";
lblBMarital.Text = data.MaritalStatus.ToString();
lblBBirthday.Text = string.Format("{0:yyyy-MM-dd}", data.Birthday);
lblBWorkYear.Text = data.WorkYears.ToString();
//居住地
//户口所在地
lblBEmail.Text = data.Email;
lblBMobile.Text = data.Mobile;
lblBTel.Text = data.Tel;
lblBFax.Text = data.Fax;
lblBKeyword.Text = data.KeyWord;
lblBAddress.Text = data.Address;
//-----------Edit----------
txtBName.Text = data.RealName;
rdBGender.SelectedValue = data.Sex.ToString();
rdBMarital.SelectedValue = ((int)data.MaritalStatus).ToString();
txtBBirthday.Text = string.Format("{0:yyyy-MM-dd}", data.Birthday);
ddlWorkYear.SelectedValue = ((int)data.WorkYears).ToString();
//居住地
//户口所在地
txtBEmail.Text = data.Email;
txtBMobile.Text = data.Mobile;
txtBTel.Text = data.Tel;
txtBFax.Text = data.Fax;
txtBKeyword.Text = data.KeyWord;
txtBAddress.Text = data.Address;
//获取个人的工作经验
E_JobExperience dataJob = new E_JobExperience();
dataJob.PersonalID = PersonalID;
dataJob.UserID = UserID;
rpList.DataSource = new T_JobExperience().GetList(dataJob);
rpList.DataBind();
}
/// <summary>
/// 删除个人用户
/// </summary>
public void Delete()
{
int uid = Convert.ToInt32(nv["uid"]);
int pid = Convert.ToInt32(nv["pid"]);
E_Personal data = new E_Personal();
data.UserID = uid;
data.PersonalID = pid;
int result = new T_Personal().Delete(data);
HttpContext.Current.Response.Write(result);
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
E_Personal data = new E_Personal();
data.PersonalID = PersonalID;
data.UserID = UserID;
data = new T_Personal().GetModel(data);
if (data != null)
{
string url = data.Avatar == "" ? "/images/guanliyuan.jpg" : MLMGC.COMP.Config.GetPersonalAvatarUrl(data.Avatar);
imgAvatar.ImageUrl = url;
}
}
/// <summary>
/// 获取个人用户所在项目的企业号
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-05-14</remarks>
public DataTable GetEnterpriseID(E_Personal data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@PersonalID", SqlDbType.Int)
};
parms[0].Value = data.UserID;
parms[1].Value = data.PersonalID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_GetEnterpriseID", parms);
return(dt);
}
/// <summary>
/// 初始化页面数据
/// </summary>
protected void databind()
{
E_Personal data = new E_Personal();
data.UserID = UserID;
data.PersonalID = PersonalID;
data = new MLMGC.BLL.User.T_Personal().GetModel(data);
if (data == null)
{
return;
}
//ltName.Text = data.RealName;
ltLoginName.Text = UserName;
ltMobile.Text = data.Mobile;
}
/// <summary>
/// 管理员删除个人用户
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-27</remarks>
public int Delete(E_Personal data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@PersonalID", SqlDbType.Int)
};
parms[0].Value = data.UserID;
parms[1].Value = data.PersonalID;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcB_UserS_PIDelete", parms, out ReturnValue);
return(ReturnValue);
}
/// <summary>
/// 修改个人用户状态
/// </summary>
public void Status()
{
int uid = Convert.ToInt32(nv["uid"]);
int pid = Convert.ToInt32(nv["pid"]);
int status = Convert.ToInt32(nv["status"]);
E_Personal data = new E_Personal();
data.UserID = uid;
data.PersonalID = pid;
data.Status = status;
bool flag = new T_Personal().PersonalStatus(data);
HttpContext.Current.Response.Write(flag ? "1" : "0");
}
/// <summary>
/// 个人用户修改头像
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-01-12</remarks>
public bool UpdateAvatar(E_Personal data)
{
SqlParameter[] parms =
{
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@Avatar", SqlDbType.VarChar, 128)
};
parms[0].Value = data.UserID;
parms[1].Value = data.PersonalID;
parms[2].Value = data.Avatar;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcB_User_PIUpdateAvatar", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 修改个人用户状态
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-27</remarks>
public bool PersonalStatus(E_Personal data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.TinyInt)
};
parms[0].Value = data.UserID;
parms[1].Value = data.PersonalID;
parms[2].Value = data.Status;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcB_UserS_PIStatusUpdate", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 发送验证码
/// </summary>
/// <remarks>tianzhenyun 2011-10-21</remarks>
public bool AddAuthCode(E_Personal data)
{
int ReturnValue;
SqlParameter[] parms =
{
new SqlParameter("@UID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Email", SqlDbType.VarChar, 128),
new SqlParameter("@EmailCode", SqlDbType.VarChar, 64)
};
parms[0].Value = data.UID;
parms[1].Value = data.UserName;
parms[2].Value = data.EmailCode;
DbHelperSQL.RunProcedures("ProcPI_B_AuthCode_Insert", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 初始化页面数据
/// </summary>
protected void databind()
{
E_Personal data = new E_Personal();
data.UserID = UserID;
data.PersonalID = PersonalID;
data = new MLMGC.BLL.User.T_Personal().GetModel(data);
if (data == null)
{
return;
}
ltName.Text = data.RealName;
//ltLoginName.Text = UserName;
//ltMobile.Text = data.Mobile;
//头像
imgAvatar.ImageUrl = MLMGC.COMP.Config.GetPersonalAvatarUrl(data.Avatar);
}
/// <summary>
/// 个人用户修改信息
/// </summary>
/// <remarks>tianzhenyun 2011-10-21</remarks>
public bool Update(E_Personal data)
{
int ReturnValue;
SqlParameter[] parms =
{
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@RealName", SqlDbType.VarChar, 64),
new SqlParameter("@Sex", SqlDbType.TinyInt),
new SqlParameter("@Mobile", SqlDbType.VarChar, 11),
new SqlParameter("@Tel", SqlDbType.VarChar, 64),
new SqlParameter("@Fax", SqlDbType.VarChar, 64),
new SqlParameter("@Address", SqlDbType.VarChar, 128),
//2012-03-09日改，添加以下参数
new SqlParameter("@Email", SqlDbType.VarChar, 128),
new SqlParameter("@Birthday", SqlDbType.SmallDateTime),
new SqlParameter("@WorkYears", SqlDbType.TinyInt),
new SqlParameter("@CityID", SqlDbType.Int),
new SqlParameter("@HuKouCityID", SqlDbType.Int),
new SqlParameter("@KeyWord", SqlDbType.VarChar, 256),
new SqlParameter("@MaritalStatus", SqlDbType.TinyInt)
};
parms[0].Value = data.UserID;
parms[1].Value = data.PersonalID;
parms[2].Value = data.RealName;
parms[3].Value = data.Sex;
parms[4].Value = data.Mobile;
parms[5].Value = data.Tel;
parms[6].Value = data.Fax;
parms[7].Value = data.Address;
parms[8].Value = data.Email;
parms[9].Value = data.Birthday;
parms[10].Value = (int)data.WorkYears;
parms[11].Value = data.CityID;
parms[12].Value = data.HuKouCityID;
parms[13].Value = data.KeyWord;
parms[14].Value = (int)data.MaritalStatus;
DbHelperSQL.RunProcedures("ProcPI_B_Personal_Update", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind(int uid, int pid)
{
E_Personal data = new E_Personal();
data.UserID = uid;
data.PersonalID = pid;
data = new T_Personal().SelectModel(data);
if (data != null)
{
txtRealName.Text = data.RealName;
txtTel.Text = data.Tel;
txtEmail.Text = data.Email;
txtMobile.Text = data.Mobile;
txtFax.Text = data.Fax;
txtAddress.Text = data.Address;
txtClientNum.Text = data.ClientNum.ToString();
txtUserName.Text = data.UserName;
//txtPassword.Text = data.Password;
}
}
void AddAuthCode()
{
//------------------先验证邮箱是否可用-----------------------
string email = nv["email"];
bool fl = new T_Personal().AuthEmail(new E_PersonalUser {
UserName = email
});
if (!fl)
{
HttpContext.Current.Response.Write("-2"); //-2,说明邮箱已存在
return;
}
//随机码
string emailCode = StringUtil.RndString(6);
E_Personal data = new E_Personal();
data.UID = Guid.Parse(nv["uid"]);
data.EmailCode = emailCode;
data.UserName = email;
//发送邮件
bool f = SendEmail(data.UID.ToString(), emailCode, email);
if (!f)
{
HttpContext.Current.Response.Write("-1"); //-1,说明邮件发送失败
return;
}
bool flag = new T_Personal().AddAuthCode(data);
if (flag)
{
HttpContext.Current.Response.Write("1"); //验证码插入成功
}
else
{
HttpContext.Current.Response.Write("0"); //验证码插入失败
}
}
/// <summary>
/// 个人注册
/// </summary>
/// <remarks>tianzhenyun 2011-10-21</remarks>
public int AddPersonal(E_Personal data)
{
int ReturnValue;
SqlParameter[] parms =
{
new SqlParameter("@UID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Email", SqlDbType.VarChar, 128),
new SqlParameter("@EmailCode", SqlDbType.VarChar, 64),
new SqlParameter("@UserType", SqlDbType.TinyInt),
new SqlParameter("@Status", SqlDbType.TinyInt),
new SqlParameter("@Password", SqlDbType.VarChar, 128),
new SqlParameter("@RealName", SqlDbType.VarChar, 64),
new SqlParameter("@Sex", SqlDbType.TinyInt),
new SqlParameter("@Mobile", SqlDbType.VarChar, 11),
new SqlParameter("@Tel", SqlDbType.VarChar, 64),
new SqlParameter("@Fax", SqlDbType.VarChar, 64),
new SqlParameter("@Address", SqlDbType.VarChar, 128),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@PersonalID", SqlDbType.Int)
};
parms[0].Value = data.UID;
parms[1].Value = data.UserName;
parms[2].Value = data.EmailCode;
parms[3].Value = UserType.个人用户;
parms[4].Value = UserStatus.启用;
parms[5].Value = data.Password;
parms[6].Value = data.RealName;
parms[7].Value = data.Sex;
parms[8].Value = data.Mobile;
parms[9].Value = data.Tel;
parms[10].Value = data.Fax;
parms[11].Value = data.Address;
parms[12].Direction = ParameterDirection.Output;
parms[13].Direction = ParameterDirection.Output;
DbHelperSQL.RunProcedures("ProcPI_B_PersonalS_Insert", parms, out ReturnValue);
return(ReturnValue);
}
protected void databind()
{
//个人信息
E_Personal dataPersonal = new E_Personal();
dataPersonal.UserID = UserID;
dataPersonal.PersonalID = PersonalID;
dataPersonal = new T_Personal().GetModel(dataPersonal);
if (dataPersonal == null)
{
Response.Redirect("../main.aspx");
}
ltName.Text = dataPersonal.RealName;
imgAvatar.ImageUrl = MLMGC.COMP.Config.GetPersonalAvatarUrl(dataPersonal.Avatar);
//获取最新的n条公告信息
rpListAnn.DataSource = new T_Announcement().GetNewList(new E_Announcement()
{
Count = 15
});
rpListAnn.DataBind();
}
protected void databind()
{
//个人信息
E_Personal dataPersonal = new E_Personal();
dataPersonal.UserID = UserID;
dataPersonal.PersonalID = PersonalID;
dataPersonal = new T_Personal().GetModel(dataPersonal);
if (dataPersonal == null)
{
Response.Redirect("../main.aspx");
}
ltName.Text = dataPersonal.RealName;
imgAvatar.ImageUrl = MLMGC.COMP.Config.GetPersonalAvatarUrl(dataPersonal.Avatar);
//微博信息
T_Weibo bll = new T_Weibo();
E_Weibo data = new E_Weibo();
data.PersonalID = PersonalID;
data.Page = new E_Page();
data.Page.PageSize = pagesize;
data.Page.PageIndex = pageindex;
rpList.DataSource = bll.SelfList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pagesize;
pageList1.CurrentPageIndex = pageindex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有 <span class='red_font'>{0}</span> 条微博", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
//获取最新的n条公告信息
rpListAnn.DataSource = new T_Announcement().GetNewList(new E_Announcement()
{
Count = 15
});
rpListAnn.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
E_Personal data = new E_Personal();
data.UserName = Requests.GetQueryString("username");
txtUserName.Text = data.UserName;
data.RealName = Requests.GetQueryString("realname");
txtRealName.Text = data.RealName;
string start = Requests.GetQueryString("startdate");
string end = Requests.GetQueryString("enddate");
txtStartDate.Value = start;
txtEndDate.Value = end;
data.Page = new MLMGC.DataEntity.E_Page();
if (start != "")
{
data.Page.StartDate = Convert.ToDateTime(start);
}
if (end != "")
{
data.Page.EndDate = Convert.ToDateTime(end);
}
//分页参数
data.Page.PageSize = pageSize;
data.Page.PageIndex = pageIndex;
rpList.DataSource = new T_Personal().GetList(data);
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = data.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
public void InsertarPersonal(E_Personal Personal)
{
string Query = @"INSERT INTO [dbo].[VP_Personal]
([VP_IdPerfil],[VP_IdStatus],[Nombres],[Apellidos],[Telefono],[CodigoTarjeta],[RH],[PersonaContacto],[Telefono_PersonaContacto])
VALUES
(@VP_IdPerfil,@VP_IdStatus,@Nombres,@Apellidos,@Telefono,@CodigoTarjeta,@RH,@PersonaContacto,@Telefono_PersonaContacto);";
SqlCommand cmd = new SqlCommand(Query, conexion);
conexion.Open();
cmd.Parameters.AddWithValue("@VP_IdPerfil", Personal.VP_IdPerfil);
cmd.Parameters.AddWithValue("@VP_IdStatus", Personal.VP_IdStatus);
cmd.Parameters.AddWithValue("@Nombres", Personal.Nombres);
cmd.Parameters.AddWithValue("@Apellidos", Personal.Apellidos);
cmd.Parameters.AddWithValue("@Telefono", Personal.Telefono);
cmd.Parameters.AddWithValue("@CodigoTarjeta", Personal.CodigoTarjeta);
cmd.Parameters.AddWithValue("@RH", Personal.RH);
cmd.Parameters.AddWithValue("@PersonaContacto", Personal.PersonaContacto);
cmd.Parameters.AddWithValue("@Telefono_PersonaContacto", Personal.Telefono_PersonaContacto);
cmd.ExecuteNonQuery();
conexion.Close();
}
/// <summary>
/// 得到个人实体对象
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2011-10-21</remarks>
public E_Personal GetModel(E_Personal data)
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@PersonalID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int)
};
parms[0].Value = data.PersonalID;
parms[1].Value = data.UserID;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcPI_B_Personal_Select", parms);
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
data.RealName = row["RealName"].ToString();
data.Sex = Convert.ToInt32(row["Sex"]);
data.Mobile = row["Mobile"].ToString();
data.Tel = row["Tel"].ToString();
data.Fax = row["Fax"].ToString();
data.Address = row["Address"].ToString();
data.Avatar = row["Avatar"] == DBNull.Value ? "" : row["Avatar"].ToString();
//2012-03-09
data.Email = row["Email"].ToString();
data.Birthday = row["Birthday"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(row["Birthday"]);
data.SetWorkYears = row["WorkYears"] == DBNull.Value ? 0 : Convert.ToInt32(row["WorkYears"]);
data.CityID = row["CityID"] == DBNull.Value ? 0 : Convert.ToInt32(row["CityID"]);
data.HuKouCityID = row["HuKouCityID"] == DBNull.Value ? 0 : Convert.ToInt32(row["HuKouCityID"]);
data.KeyWord = row["KeyWord"].ToString();
data.SetMaritalStatus = row["MaritalStatus"] == DBNull.Value ? 0 : Convert.ToInt32(row["MaritalStatus"]);
//2012-05-09
data.SetItemFlag = row["ItemFlag"] == DBNull.Value ? 0 : Convert.ToInt32(row["ItemFlag"]);
return(data);
}
return(null);
}
/// <summary>
/// 绑定数据
/// </summary>
protected void databind()
{
//获取个人基本信息
E_Personal data = new E_Personal();
data.UserID = userid;
data.PersonalID = personalid;
data = new T_Personal().GetModel(data);
if (data == null)
{
return;
}
//-----------Info---------
lblBName.Text = data.RealName;
lblBSex.Text = data.Sex == 0 ? "男" : "女";
lblBMarital.Text = data.MaritalStatus.ToString();
lblBBirthday.Text = string.Format("{0:yyyy-MM-dd}", data.Birthday);
lblBWorkYear.Text = data.WorkYears.ToString();
//居住地
//户口所在地
lblBEmail.Text = data.Email;
lblBMobile.Text = data.Mobile;
lblBTel.Text = data.Tel;
lblBFax.Text = data.Fax;
lblBKeyword.Text = data.KeyWord;
lblBAddress.Text = data.Address;
//获取个人的工作经验
E_JobExperience dataJob = new E_JobExperience();
dataJob.PersonalID = personalid;
dataJob.UserID = userid;
rpList.DataSource = new T_JobExperience().GetList(dataJob);
rpList.DataBind();
}
