[WebMethod(Description = "
参数说明:
UserCode:准考证号
UserName:用户姓名
UserSex:性别
UserPwd:密码
DeptID:单位部门
UserLevel:用户级别
UserSFZH:身份证")]
public string AddUser(string UserCode, string UserName, string UserSex, string UserPwd, string DeptID, string UserLevel, string UserSFZH)
{
StringBuilder strSql = new StringBuilder();
SqlParameter[] parameters = null;
strSql.Append("insert into UserInfo(UserCode,UserName,UserSex,UserPwd,DeptID,UserLevel,UserSFZH) values(");
strSql.Append("@UserCode,@UserName,@UserSex,@UserPwd,@DeptID,@UserLevel,@UserSFZH)");
parameters = new SqlParameter[] {
new SqlParameter("@UserCode", SqlDbType.VarChar),
new SqlParameter("@UserName", SqlDbType.VarChar),
new SqlParameter("@UserSex", SqlDbType.VarChar),
new SqlParameter("@UserPwd", SqlDbType.VarChar),
new SqlParameter("@DeptID", SqlDbType.Int),
new SqlParameter("@UserLevel", SqlDbType.VarChar),
new SqlParameter("@UserSFZH", SqlDbType.VarChar)
};
parameters[0].Value = UserCode;
parameters[1].Value = UserName;
parameters[2].Value = UserSex;
parameters[3].Value = UserPwd;
parameters[4].Value = DeptID;
parameters[5].Value = UserLevel;
parameters[6].Value = UserSFZH;
string adduser = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters).ToString();
我想把这个改为一次性接收很多值。一次性传很多值过来,我要调用然后实现