public void Update(M_AdminProfile adminProileInfo)
{
SqlParameter[] cmdParams = new SqlParameter[]
{
new SqlParameter("@AdminName", SqlDbType.NVarChar, 50),
new SqlParameter("@PersonalSetting", SqlDbType.NText, 16)
};
cmdParams[0].Value = adminProileInfo.AdminName;
string str = this.adminProfileSer.SerializeField(adminProileInfo);
cmdParams[1].Value = str;
SqlHelper.ExecuteSql("UPDATE PE_AdminProfile SET PersonalSetting=@PersonalSetting WHERE AdminName=@AdminName", cmdParams);
}
public void Add(M_AdminProfile adminProileInfo)
{
SqlParameter[] cmdParams = new SqlParameter[]
{
new SqlParameter("@AdminName", SqlDbType.NVarChar, 50),
new SqlParameter("@PersonalSetting", SqlDbType.NText, 16)
};
cmdParams[0].Value = adminProileInfo.AdminName;
string str = this.adminProfileSer.SerializeField(adminProileInfo);
cmdParams[1].Value = str;
SqlHelper.ExecuteSql("INSERT INTO ZL_AdminProfile (AdminName,PersonalSetting) VALUES (@AdminName,@PersonalSetting)", cmdParams);
}
public M_AdminProfile GetAdminProfile(string adminName)
{
M_AdminProfile info = null;
SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@AdminName", SqlDbType.NVarChar, 50) };
cmdParams[0].Value = adminName;
using (SqlDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, "SELECT * FROM ZL_AdminProfile WHERE AdminName=@AdminName", cmdParams))
{
if (reader.Read())
{
info = this.adminProfileSer.DeserializeField(reader["PersonalSetting"].ToString());
info.AdminName = reader["AdminName"].ToString();
return(info);
}
return(new M_AdminProfile());
}
}
