Exemplo n.º 1
0
        /// <summary>
        /// 插入fee用
        /// </summary>
        /// <param name="fee"></param>
        /// <returns></returns>
        public int innsertFeeStudent(fee1 fee)
        {
            SqlConnection con = new SqlConnection(@"Data Source=WIN-L8SRCUH9LF2\JACK;Initial Catalog=StudentroomDB;Persist Security Info=True;User ID=sa;pwd=720713");
            SqlCommand cmd = con.CreateCommand();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "dbo.pro_insertFeestudent";
            cmd.Parameters.Add("@studentid", SqlDbType.Int).Value = fee.Studentid;
            cmd.Parameters.Add("@Feefood ", SqlDbType.Int).Value = fee.Feefood;
            cmd.Parameters.Add("@Feecon", SqlDbType.Int).Value = fee.Feeconditioner;
            cmd.Parameters.Add("@Feewarm", SqlDbType.Int).Value = fee.Feewarm;
            cmd.Parameters.Add("@Feebook", SqlDbType.Int).Value = fee.Feebook;
            cmd.Parameters.Add("@Feeroom", SqlDbType.Int).Value = fee.Feeroom;
            //返回值
            SqlParameter parret = new SqlParameter("@retvalues",SqlDbType.Int);
            parret.Direction = ParameterDirection.ReturnValue;
            int ret = 0;
            cmd.Parameters.Add(parret);
            try
            {
                con.Open();
                cmd.ExecuteNonQuery();
                ret = (int)parret.Value;

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);

            }
            finally
            {
              con.Close();
            }
            return ret;
        }
Exemplo n.º 2
0
 public bool innsertFeeStudent(fee1 fee)
 {
     int ret= feeser.innsertFeeStudent(fee);
        if (ret == 1)
        {
        return true;
        }
        else
        return false;
 }
Exemplo n.º 3
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="fee"></param>
        /// <returns></returns>
        public DataSet selectfeestudent(fee1 fee)
        {
            SqlConnection con = new SqlConnection(@"Data Source=WIN-L8SRCUH9LF2\JACK;Initial Catalog=StudentroomDB;Persist Security Info=True;User ID=sa;pwd=720713");
            DataSet dt = new DataSet();
            SqlCommand cmd = new SqlCommand("dbo.selectfee", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@studentid",SqlDbType.Int).Value=fee.Studentid;
            //返回值
            SqlDataAdapter adp = new SqlDataAdapter();
            try
            {

                adp.SelectCommand = cmd;
                adp.Fill(dt, "feestudent");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
               // int rettu = (int)parret.Value;
            return dt;
        }
Exemplo n.º 4
0
 public DataSet selectfeestudent(fee1 fee)
 {
     return feeser.selectfeestudent(fee);
 }