using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
using DBUtility;
using Utility;namespace DAL
{
public class datasql
{ public void updatauser(UserInfo userInfo)
{ SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@p_name",SqlDbType.VarChar,50),
new SqlParameter("@p_sex",SqlDbType.VarChar,50),
new SqlParameter("@p_e_mail",SqlDbType.VarChar,50),
new SqlParameter("@p_nowplace",SqlDbType.VarChar,50),
new SqlParameter("@p_birthday",SqlDbType.DateTime),
new SqlParameter("@p_province",SqlDbType.VarChar,50),
new SqlParameter("@p_city",SqlDbType.VarChar,50),
}; parms[0].Value = userInfo.Name;
parms[1].Value = userInfo.Sex;
parms[2].Value = userInfo.E_mail;
parms[3].Value = userInfo.Nowplace;
parms[4].Value = userInfo.Birthday;
parms[5].Value = userInfo.Province;
parms[6].Value = userInfo.City; sqlhelper.RunProc("Updatebaseinfo", parms);
}
}
}
怎么用登录的用户名作为条件修改用户信息?
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
using DBUtility;
using Utility;namespace DAL
{
public class datasql
{ public void updatauser(UserInfo userInfo)
{ SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@p_name",SqlDbType.VarChar,50),
new SqlParameter("@p_sex",SqlDbType.VarChar,50),
new SqlParameter("@p_e_mail",SqlDbType.VarChar,50),
new SqlParameter("@p_nowplace",SqlDbType.VarChar,50),
new SqlParameter("@p_birthday",SqlDbType.DateTime),
new SqlParameter("@p_province",SqlDbType.VarChar,50),
new SqlParameter("@p_city",SqlDbType.VarChar,50),
}; parms[0].Value = userInfo.Name;
parms[1].Value = userInfo.Sex;
parms[2].Value = userInfo.E_mail;
parms[3].Value = userInfo.Nowplace;
parms[4].Value = userInfo.Birthday;
parms[5].Value = userInfo.Province;
parms[6].Value = userInfo.City; sqlhelper.RunProc("Updatebaseinfo", parms);
}
}
}
怎么用登录的用户名作为条件修改用户信息?
说清楚点