示例#1
0
        public int InsertAndGetID(VO.PhieuDatPhongVO valueObject)
        {
            try
            {
                string sp = "SP_INSERT_PHIEU_DAT_PHONG";

                SqlParameter[] param = new SqlParameter[4];

                param[0]           = new SqlParameter("@IDENTITY", SqlDbType.Int);
                param[0].Direction = ParameterDirection.Output;

                param[1] = new SqlParameter("@MA_KHACH_HANG", valueObject.MA_KHACH_HANG);
                if (valueObject.MA_KHACH_HANG == -1)
                {
                    param[1].Value = DBNull.Value;
                }

                param[2] = new SqlParameter("@MA_DOAN_KHACH", valueObject.MA_DOAN_KHACH);
                if (valueObject.MA_DOAN_KHACH == -1)
                {
                    param[2].Value = DBNull.Value;
                }

                param[3] = new SqlParameter("@TIEN_COC", valueObject.TIEN_COC);

                return(Program.DBConnection.ExecuteSPReturnsID(sp, param));
            }//end try
            catch
            {
                throw;
            } //end catch
        }     //end method InsertAndGetID
示例#2
0
 public int InsertAndGetID(VO.PhieuDatPhongVO valueObject)
 {
     try {
         return(phieuDatPhongDAO.InsertAndGetID(valueObject));
     }//end try
     catch {
         throw;
     } //end catch
 }     //end method InsertAndGetID