コード例 #1
0
    public void Save(BllPaperTransaction transactionObj)
    {
        SqlCommand cmd = new SqlCommand("spTransactionPaper", con);

        cmd.CommandType = CommandType.StoredProcedure;
        con.Open();

        cmd.Parameters.Add("@Flag", SqlDbType.TinyInt).Value      = 1;
        cmd.Parameters.Add("@AutoId", SqlDbType.Int).Value        = transactionObj.TransactionNo;
        cmd.Parameters.Add("@PAPERNAME", SqlDbType.VarChar).Value = transactionObj.PaperName;
        cmd.Parameters.Add("@TRADATE", SqlDbType.Date).Value      = transactionObj.Date;
        cmd.Parameters.Add("@station", SqlDbType.VarChar).Value   = transactionObj.Station;
        cmd.Parameters.Add("@TRAAMOUNT", SqlDbType.Int).Value     = transactionObj.Amount;
        cmd.ExecuteNonQuery();
        con.Close();
    }
コード例 #2
0
 public void Save(BllPaperTransaction transactionObj)
 {
     transactionDALObj.Save(transactionObj);
 }