/// <summary>
/// 获取用户个人信息
/// </summary>
/// <param name="strAccount">用户名</param>
/// <returns></returns>
public PersonInfo Account_PersonInfo_Get(string strAccount)
{
DataSet ds = dal.Get_AccountList("Power_Accounts.AcountName='" + strAccount + "'");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
PersonInfo Person = new PersonInfo();
DataRow dr = ds.Tables[0].Rows[0];
Person.AcountName = dr["AcountName"].ToString();
Person.ADD_Home = dr["ADD_Home"].ToString();
Person.BIRTHDAY = dr["BIRTHDAY"].ToString().Equals("") ? DateTime.Parse("1900-01-01 00:00:00") : DateTime.Parse(dr["BIRTHDAY"].ToString());
Person.Email = dr["Email"].ToString();
Person.Fax_No_Dept = dr["Fax_No_Dept"].ToString();
Person.ICQ_NO = dr["ICQ_NO"].ToString();
Person.MOBIL_NO = dr["MOBIL_NO"].ToString();
Person.MOBIL_NO_HIDDEN = bool.Parse(dr["MOBIL_NO_HIDDEN"].ToString());
Person.MSN = dr["MSN"].ToString();
Person.Post_NO_Home = dr["Post_NO_Home"].ToString();
Person.QQ_NO = dr["QQ_NO"].ToString();
Person.Sex = bool.Parse(dr["Sex"].ToString());
Person.Tel_No_Dept = dr["Tel_No_Dept"].ToString();
Person.Tel_NO_Home = dr["Tel_NO_Home"].ToString();
Person.TrueName = dr["TrueName"].ToString();
Person.DEPT_NAME = dr["DEPT_NAME"].ToString().Equals("") ? "离职/外部人员" : dr["DEPT_NAME"].ToString();
return Person;
}
else
{
return null;
}
}
/// <summary>
/// 用户个人信息
/// </summary>
/// <param name="Person">个人信息对象</param>
/// <returns></returns>
public int Account_PersonInfo_Update(PersonInfo Person)
{
return dal.Account_PersonInfo_Update(Person);
}
/// <summary>
/// 用户个人信息
/// </summary>
/// <param name="Person">个人信息对象</param>
/// <returns></returns>
public int Account_PersonInfo_Update(PersonInfo Person)
{
SqlParameter[] paras =
{
new SqlParameter("@AcountName",SqlDbType.NVarChar,20),
new SqlParameter("@Sex",SqlDbType.Bit),
new SqlParameter("@BIRTHDAY",SqlDbType.DateTime),
new SqlParameter("@Tel_No_Dept",SqlDbType.VarChar,50),
new SqlParameter("@Fax_No_Dept",SqlDbType.VarChar,50),
new SqlParameter("@MOBIL_NO",SqlDbType.VarChar,50),
new SqlParameter("@MOBIL_NO_HIDDEN",SqlDbType.Bit),
new SqlParameter("@Email",SqlDbType.VarChar,50),
new SqlParameter("@QQ_NO",SqlDbType.VarChar,50),
new SqlParameter("@MSN",SqlDbType.VarChar,50),
new SqlParameter("@ICQ_NO",SqlDbType.VarChar,50),
new SqlParameter("@ADD_Home",SqlDbType.NVarChar,500),
new SqlParameter("@Post_NO_Home",SqlDbType.VarChar,50),
new SqlParameter("@Tel_NO_Home",SqlDbType.VarChar,50)
};
paras[0].Value = Person.AcountName;
paras[1].Value = Person.Sex;
paras[2].Value = Person.BIRTHDAY;
paras[3].Value = Person.Tel_No_Dept;
paras[4].Value = Person.Fax_No_Dept;
paras[5].Value = Person.MOBIL_NO;
paras[6].Value = Person.MOBIL_NO_HIDDEN;
paras[7].Value = Person.Email;
paras[8].Value = Person.QQ_NO;
paras[9].Value = Person.MSN;
paras[10].Value = Person.ICQ_NO;
paras[11].Value = Person.ADD_Home;
paras[12].Value = Person.Post_NO_Home;
paras[13].Value = Person.Tel_NO_Home;
try
{
int iReturn;
int i = DbHelperSQL.RunProcedure("[Account_PersonInfo]", paras, out iReturn);
return iReturn;
}
catch
{
return -1;
}
}