public static bool AddTbmember(Tbmember member, string regip) { bool check = false; try { SqlCommand sqlcommnad = new SqlCommand("Pro_AddUsers", sqlconn.GetConn()); sqlcommnad.CommandType = CommandType.StoredProcedure; //指定参数 sqlcommnad.Parameters.Add("@membername", SqlDbType.VarChar, 50).Value = member.Membername; sqlcommnad.Parameters.Add("@pwd", SqlDbType.VarChar, 50).Value = member.Pwd; sqlcommnad.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = member.Eamil; sqlcommnad.Parameters.Add("@tel", SqlDbType.VarChar, 50).Value = member.Tel; sqlcommnad.Parameters.Add("@yingyezhizhao", SqlDbType.VarChar, 50).Value = member.Yingyezhizhao; sqlcommnad.Parameters.Add("@memberturename", SqlDbType.VarChar, 50).Value = member.Memberturename; sqlcommnad.Parameters.Add("@companyadress", SqlDbType.VarChar, 50).Value = member.Companyadress; sqlcommnad.Parameters.Add("@callnumber", SqlDbType.VarChar, 50).Value = member.Callnumber; sqlcommnad.Parameters.Add("@question1", SqlDbType.VarChar, 50).Value = member.Membername; sqlcommnad.Parameters.Add("@ask1", SqlDbType.VarChar, 50).Value = member.Ask1; sqlcommnad.Parameters.Add("@question2", SqlDbType.VarChar, 50).Value = member.Question2; sqlcommnad.Parameters.Add("@ask2", SqlDbType.VarChar, 50).Value = member.Ask2; sqlcommnad.Parameters.Add("@tuiguang", SqlDbType.VarChar, 50).Value = member.Tuiguang; sqlcommnad.Parameters.Add("@sortid", SqlDbType.Int, 4).Value = member.Sortid; sqlcommnad.Parameters.Add("@groupid", SqlDbType.Int, 4).Value = 10; sqlcommnad.Parameters.Add("@regip", SqlDbType.Char, 15).Value = regip; sqlcommnad.Parameters.Add("@uid", SqlDbType.Int, 4).Value = 0; SqlParameter outPutParam = new SqlParameter("@result", SqlDbType.Int, 4); outPutParam.Direction = ParameterDirection.Output; sqlcommnad.Parameters.Add(outPutParam); sqlcommnad.Connection.Open(); sqlcommnad.ExecuteNonQuery(); int result = (int)sqlcommnad.Parameters["@result"].Value; if (result > 0) { check = true; } else { check = false; } sqlcommnad.Connection.Close(); } catch (Exception) { throw; } return check; }