public void Insert(Users obj)
{
SqlParameter[] parameters =
{
new SqlParameter("@paperName", SqlDbType.NVarChar, 50),
new SqlParameter("@paperType", SqlDbType.NVarChar, 30),
new SqlParameter("@deptID", SqlDbType.SmallInt, 2)
};
parameters[0].Value = obj.ID;
parameters[1].Value = obj.Name;
parameters[2].Value = obj.Password;
DBHelperProcedure.Insert("UP_T_Paper_ADD", parameters);
}
public void InsertProc()
{
SqlParameter[] parameters =
{
new SqlParameter("@deptID", SqlDbType.NVarChar, 50),
new SqlParameter("@TestId", SqlDbType.Int, 3),
new SqlParameter("@deptName", SqlDbType.NVarChar, 50),
new SqlParameter("@reutrnValue", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Direction = ParameterDirection.Output;
parameters[2].Value = "李四";
parameters[3].Direction = ParameterDirection.ReturnValue;
DBHelperProcedure.Insert("UP_User_Name", parameters);
int s = Convert.ToInt32(parameters[3].Value);
string ss = parameters[0].Value.ToString();
// int retValue = Convert.ToInt32(parameters["@RetValue"].Value.ToString());
}