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);
}